return to gGraph® Manual

Data Files

gGraph saves data externally as .xlsx files, which can be created, opened and manipulated using Microsoft® Excel. An .xlsx file readable by gGraph will contain column labels (text) in the first row followed by rows of numbers in decimal or exponential (e.g., 1.0E3) format.

When the user clicks the Data Files menu item on the main menu, the user has the option to:

New: Create a new data file. A gGraph datagrid will open, allowing the user to manually input data by typing in individual entries, or pasting CSV (e.g., columns from an Excel file) data from the clipboard (see below).

Open: The user can import data into a datagrid from an existing .xlsx file either saved previously from gGraph or created with Excel. Note that opening (importing) data into gGraph (displayed in a datagrid) can be done while the .xlsx file is open in Excel. However, a warning will be issued, as this practice can cause difficulty when changes are made to the .xlsx file or the corresponding datagrid. Internally, the .xlsx file is closed as soon as the data importing is complete, but will remain open if opened through an external instance of Excel.

Save: Any changes made to the datagrid are committed to the .xlsx file (or a new file is created if it does not exist) provided the corresponding .xlsx file is NOT currently open.

Save as: The datagrid is committed to an .xlsx file of the user’s choice.

Close: The datagrid will be closed. The user has the option of committing changes made to the datagrid to the corresponding .xlsx file, or the option of creating a new .xlsx file if one does not currently exist.

Note on updating plots based on changes to data: If the .xlsx file is changed (e.g., in Excel), the corresponding graph must be activated, the data file opened (imported as a datagrid), and the plots updated by choosing the “Refresh” option under the “Plots” menu item or on the datagrid selection window. Changes made to the datagrid are propagated to the plots by choosing “Refresh” and written to the corresponding .xlsx file through the “Save” or “Close” options.

Characteristics of the datagrid A datagrid can be easily and robustly edited as follows:

Column Header Cell (double-click): Allows the name of the column to be edited.

Column Header Cell (single-click, followed by shift-click on another Header Cell): Selects a range of columns.

Column Head Cell (right-click): Allows the user to insert columns before the current column, after the current column, to clear the current column, to delete the current column, to copy the current column, to paste a column or to perform mathematical operations (not yet functional).

Column Head Cell (right-click following selection of a range of columns): Allows the above operations to be performed on a range of columns.

Row Header Cell (single-click, followed by shift-click on another Header Cell): Selects a range of rows.

Row Head Cell (right-click): Allows the user to insert rows before the current row, after the current row, to clear the current row, to delete the current row, to copy the current row or to paste a row. The row can also be masked (shows as bold) or unmasked. Masked data are not plotted. Note that when a datagrid is saved as a .xlsx file, the formatting (masking) is lost. We are working on rectifying this deficiency in future versions.

Row Head Cell (right-click following selection of a range of rows): Allows the above operations to be performed on a range of rows.

Data cell (single-click): Selects the cell.

Data cell (single-click followed by shift-click on another cell): Selects a range of cells.

Data cell(right-click): Allows the user to clear selection, copy selection, paste previously copied selection, paste from clipboard, mask and unmasked selection.

Data cell(right-click following selection of a range of cells): Allows the user to clear, copy, mask and unmasked the selected cells.