4.1.14 Exporting Table Data for Editing
Viewsheets provide several features to assist in offline data editing. A user can export data from a Viewsheet to an Excel file, edit the data values within the Excel file, and re-import the revised data into the Viewsheet at a later time. This gives a user the ability to edit a Viewsheet “offline,” while not actively logged into the server.
Note: Offline editing features are available only if product is licensed for Viewsheet Forms.
To configure a Viewsheet so that users can export data to an Excel file for editing (and subsequent importing), follow the steps below:
1. For each table that you wish to make editable in Excel, right-click the table, and select 'Properties' from the context menu. This opens the 'Table Properties' dialog box.
2. Select the General tab, and enter a unique name for the table in the 'Name' field. (This name will be used to label the table in the Excel export, and to match the Excel table to the Viewsheet table during subsequent importing.)
3. Select the Advanced tab, and check the 'Enable Table Editing' option. Select the desired editing features, 'Add Rows', 'Delete Rows', and/or 'Edit Rows'. See Table Properties: Advanced Tab for more information about these options.
4. Press 'OK' to close the 'Table Properties' dialog box.
See Also
Table Properties: Advanced Tab, for information on how to make a table editable.
Importing Excel Data into a Dashboard, in End User, for information on how to import the generated Excel file.
Exporting a Dashboard for Editing in Excel, in End User, for information on how to export the Viewsheet.
| << 4.1.13 Exporting Table Data for Viewing | © 1996-2013 InetSoft Technology Corporation (v11.5) | 4.2 Freehand Tables >> |