Converts an Excel spreadsheet to an XML document or converts an XML document to an Excel spreadsheet.


Revision History

1.0.5.7 - Fixed an issue that caused generation of some documents to fail due to word dictionary handling bug
1.0.5.5 - Added Connection property to node. DropPoint connection necessary when file size > 10MB.

1.0.5.3 - Fixed issues that caused a repair warning to display when attempting to open an Excel Workbook rendered by this Node.

Properties

Action

Description: Open existing document, create a new one or insert into an existing document.
Direction: Input
Type: List
Open
Create
Insert

Formatting

Description: Allows you to specify the type of formatting on the resulting Excel document.
Direction: Input
Type: List
AllText
None
Smart

TableXml

Description: The table Xml which is returned when opening an Excel document, used to create a new Excel document or insert a worksheet into an existing Excel document.
Direction: Input / Output
Type: Xml

ExcelDocument

Description: The Excel document as a byte array. Use a variable (Variable Bar Node) with a type of 'File' to upload and download Excel documents. Used for the Open Action
Direction: Input / Output
Type: Multiline Text

ExcelDocumentTemplate

Description: This property is only used for the Insert Action. Allows the supplied Excel document to create a new sheet with the data from the TableXml property
Direction: Input
Type: Multiline Text

Remarks

Only the OpenOffice file format is supported (ie. xlsx file extension).

When using the Insert action, if a worksheet with the same name already exists, the worksheet with the specified name will be replaced.

When using the Create action, it is necessary to have a Connection Property set.

Number & Date Formats

If you are parsing a date cell and it is being returned as a number, change the cell formatting for the entire row to a Date (or other appropriate) format.

Examples


See https://flowgear.me/s/yS0qceX for examples.

See Also

XML to HTML

Did this answer your question?