3.3.7 Exporting a Viewsheet for Editing in Excel

Note: Offline editing features are available only if product is licensed for Viewsheet Forms.

Viewsheets provide several features to assist in offline data editing. You can export data from Viewsheet Tables and Input Components into an Excel file, edit the data values and make input selections within the Excel file, and re-import the revised data and selections into the Viewsheet at a later time. This allows you to edit a Viewsheet offline, while not actively logged into the server.

To export a Viewsheet for editing (and subsequent importing), follow the steps below:

Note: Do not use the 'Export' button in the table title bar.

1. Press the 'Export' button in the Viewsheet toolbar.

 

2. On the Content tab, select the 'Excel' export option.

3. Deselect the 'Match Layout' option.

 

4. Under the Location tab, select the 'Desktop' option.

5. Press 'OK' to close the dialog box and export the Viewsheet.

This saves the Excel file (with the same name as the Viewsheet) in the browser's default download directory. You can now open the file in Excel, and edit the tables or modify input elements as desired. To re-import the modified Excel data back into the Viewsheet, see Importing Excel Data into a Viewsheet.

See Also

Exporting Table Data for Editing, in Dashboard Design, for information on how to configure editing features.

<< 3.3.6 Exporting a Viewsheet for Viewing © 1996-2013 InetSoft Technology Corporation (v11.4) 3.3.8 Importing Excel Data into a Viewsheet >>