Spreadsheet Util DSC

 Browse Space
Added by Kendy Yus, last edited by Kendy Yus on Nov 26, 2008  (view change)

Labels:

Enter labels to add to this page:
Wait Image 
Looking for a label? Just start typing.

Please read the article on How to generate Excel Spreadsheet from XML data in process variables and How to import table and its content from an Excel spreadsheet into a database for the scenario and usage on this component.

Component: com.avoka.livecycle.spreadsheetutil 8.0

SpreadsheetUtil Service

Spreadsheet Utilities: Utility Service for Manipulating Spreadsheet

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.

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

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

Licence Configuration:

Parameter Type Description