OpenDocument Spreadsheet Actions
Description: The OpenDocument Spreadsheet action is similar to the Excel action. Unlike the Excel action, however, the OpenDocument Spreadsheet action enables creation and management of spreadsheets without requiring Microsoft Excel to be installed on the system. This action not only supports spreadsheet generation and other basic file formatting features, but also supports a number of advanced features such as importing as well as exporting spreadsheet data, reading, writing and modifying XLSX, XLS, ODS, CSV or HTML files. This makes it much more convenient for developers to manipulate spreadsheet contents, format cells and protect files.
A common use of OpenDocument Spreadsheet is for deploying on the Web Server or in Web Services for server side processing. For example, users can upload manually created spreadsheets to a server. The OpenDocument action is then used to open the files and retrieve data. Additionally, users can input data in web pages where it is collected by the web server. The OpenDocument action can then used to populate data in brand new files or pre-defined template files. After the spreadsheet file is created, it can be sent to the user as a report, receipt, etc.
Available Activities
The list of activities for this action are arranged below in alphabetical order. For more information about a specific activity, click its associated link.
Activity |
Description |
---|---|
Activates a specific worksheet from a workbook in an established OpenDocument Spreadsheet session. The worksheet to activate can be specified by its name or current index. Performing this activity is equivalent to manually clicking the sheet's tab. |
|
Adds a hyperlink to a cell in a worksheet. |
|
Adds a new worksheet to a workbook in an established OpenDocument session. |
|
Auto sizes the width and height of a cell row or column in a worksheet according to its content. |
|
Closes a workbook previously opened or created by the Open/Create workbook activity and ends the associated session. |
|
Copies the data and format of a source worksheet onto a destination worksheet. |
|
Decrypts an encrypted Excel workbook by specifying a password. |
|
Deletes an entire row or column from the specified position in the worksheet, or clears a specific cell of its contents. |
|
Deletes one or more rows/columns in the specified worksheet or clears the contents of one or more rows/columns. |
|
Encrypts and password protects an Excel workbook to protect its data from being read or manipulated. |
|
Retrieves the name or index of the currently active worksheet and populates either or both of two variables, one for the worksheet name and the other for the index. |
|
Retrieves the cell position or cell reference of an individual cell and populates one or more variables with results. |
|
Retrieves an individual cell and populates a variable with its value or retrieves a range of cells and populates a dataset with their values. |
|
Retrieves the position of the active cell or range of cells in a workbook and populates one or more existing variables with the cell reference and/or position coordinates. |
|
Hides an Excel worksheet or unhides a currently hidden one. |
|
Inserts a an individual cell, a cell row or cell column in a worksheet. |
|
Inserts an individual cell, a cell row or cell column in a worksheet. |
|
Retrieves information about the worksheets contained in a workbook and populates a dataset with results. |
|
Moves the data and format of a source worksheet onto a destination worksheet. |
|
Opens an existing workbook or creates a new workbook and establishes a unique session in which subsequent OpenDocument Spreadsheet activities can link to. |
|
Removes a worksheet from a workbook. |
|
Renames a worksheet. |
|
Searches for cells in a worksheet that contains specified data and populates a dataset with results. |
|
Selects a single cell or multiple cells, ranges, rows or columns within the currently active worksheet. |
|
Sets the text of one or more cells in a workbook. |