Spreadsheet Util DSC

h2. SpreadsheetUtil Service

Spreadsheet Utilities: Utility Service for Manipulating Spreadsheet

h3. Operation Title: Generate spreadsheet   (generateSpreadsheet)

Generate spreadsheet: Generates a spreadsheet from process data using xml mapping to specify the spreadsheet contents
|| Input Parameter || Type || Description || Editor ||
| Spreadsheet XML Mapping | java.lang.String | The XML document specifying the mapping rule to create a spreadsheet | |
| Spreadsheet Output File Path | java.lang.String | The file path to store the result spreadsheet | |

|| Output Parameter || Type || Description ||
| Result | boolean | Process variable to store the result of generating the spreadsheet. True if successful, otherwise stalled. |

h3. Operation Title: Convert Spreadsheet to CSV   (convertSpreadsheetToCSV)

Convert Spreadsheet to CSV: Converts a spreadsheet into a CSV format
|| Input Parameter || Type || Description || Editor ||
| Spreadsheet | com.adobe.idp.Document | The spreadsheet document to convert | |
| Sheet Name | java.lang.String | The sheet name of the spreadsheet to convert. If not specified, the first sheet will be used. | |
| Header Row Location | int | The location of the header row in the spreadsheet. Note: the row number is 0-based, with 0 for the first row. | |
| Content Row Start Location | int | The location of the row where content of the sheet starts. Note: the row number is 0-based, with 0 for the first row. | |
| Column Starts From | int | The location of the column where content of the sheet starts. Note: the column number is 0-based, with 0 for the first column. | |

|| Output Parameter || Type || Description ||
| CSV Document | com.adobe.idp.Document | Process variable to store the result CSV document |

h5.

{panel:borderStyle=solid}
For how to configure license information for this component service - Spreadsheet Utilities, please click on the following link:
[Avoka LiveCycle ES Component License Configuration]

Please send us any questions or comments on this documentation regarding Spreadsheet Utilities by clicking on the following link:
[Feedback|mailto:docfeedback@avoka.com?subject=DSC Documentation Feedback on Service: Spreadsheet Utilities]
{panel}

h3. Licence Configuration:

|| Parameter || Type || Description ||