OpenDocument Spreadsheet

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 Excel 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
OpenDocument Spreadsheet - Activate worksheet 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.
OpenDocument Spreadsheet - Add hyperlink Adds a hyperlink to a cell in a worksheet.  
OpenDocument Spreadsheet - Add worksheet Adds a new worksheet to a workbook in an established OpenDocument session.
OpenDocument Spreadsheet - AutoFit rows/columns Auto sizes the width and height of a cell row or column in a worksheet according to its content.
OpenDocument Spreadsheet - Close workbook Closes a workbook previously opened or created by the Open/Create workbook activity and ends the associated session.
OpenDocument Spreadsheet - Copy worksheet Copies the data and format of a source worksheet onto a destination worksheet.
OpenDocument Spreadsheet - Decrypt Decrypts an encrypted Excel workbook by specifying a password.
OpenDocument Spreadsheet - Delete cell(s) Deletes an entire row or column from the specified position in the worksheet, or clears a specific cell of its contents.
OpenDocument Spreadsheet - Delete rows/columns Deletes one or more rows/columns in the specified worksheet or clears the contents of one or more rows/columns.
OpenDocument Spreadsheet - Encrypt Encrypts and password protects an Excel workbook in order to protect its data from being read or manipulated.
OpenDocument Spreadsheet - Get active worksheet 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.
OpenDocument Spreadsheet - Get cell reference/position Retrieves the cell position or cell reference of an individual cell and populates one or more variables with results.
OpenDocument Spreadsheet - Get cell(s) Retrieves an individual cell and populates a variable with its value or retrieves a range of cells and populates a dataset with their values.
OpenDocument Spreadsheet - Get selected cell(s)

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.

OpenDocument Spreadsheet - Hide/Unhide worksheet Hides an Excel worksheet or unhides a currently hidden one.
OpenDocument Spreadsheet - Insert cell(s) Inserts a an individual cell, a cell row or cell column in a worksheet.
OpenDocument Spreadsheet - Insert rows/columns Inserts an individual cell, a cell row or cell column in a worksheet.
OpenDocument Spreadsheet - List worksheet(s) Retrieves information about the worksheets contained in a workbook and populates a dataset with results.
OpenDocument Spreadsheet - Move worksheet Moves the data and format of a source worksheet onto a destination worksheet.
OpenDocument Spreadsheet - Open/Create workbook Opens an existing workbook or creates a new workbook and establishes a unique session in which subsequent OpenDocument Spreadsheet activities can link to.
OpenDocument Spreadsheet - Remove worksheet

Removes a worksheet from a workbook.

OpenDocument Spreadsheet - Rename worksheet Renames a worksheet.
OpenDocument Spreadsheet - Search

Searches for cells in a worksheet that contains specified data and populates a dataset with results.

OpenDocument Spreadsheet - Select cell(s) Selects a single cell or multiple cells, ranges, rows or columns within the currently active worksheet.
OpenDocument Spreadsheet - Set cell(s) Sets the text of one or more cells in a workbook.

 

p Back to Top