How to write content into Excel
Options
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
10-30-2014 04:24 PM
Example:
<javascript>
var carpetaReporte = companyhome.childByNamePath("Sites/comex-y-logistica/documentLibrary/Comex y Logistica");
var logFile = carpetaReporte.childByNamePath("backuplog.xlsx");
logFile = carpetaReporte.createFile("backuplog.xlsx");
logFile.content += "test";
</javascript>
I can create the Excel file and write some content, but I want to separate in cells, rows, etc. Is it possible?
<javascript>
var carpetaReporte = companyhome.childByNamePath("Sites/comex-y-logistica/documentLibrary/Comex y Logistica");
var logFile = carpetaReporte.childByNamePath("backuplog.xlsx");
logFile = carpetaReporte.createFile("backuplog.xlsx");
logFile.content += "test";
</javascript>
I can create the Excel file and write some content, but I want to separate in cells, rows, etc. Is it possible?
Labels:
- Labels:
-
Archive
2 REPLIES 2
Options
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
10-31-2014 01:25 AM
You could use Apache POI on a Java webscript, but I think that it is not possible to achieve this from JavaScript API.
Hyland Developer Evangelist
Options
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
11-03-2014 10:46 AM
If you really want to use javascript api , you can try to write javascript data to CSV file,office excel can open it correctly.
