datasheet


Windows > Datasheet Datasheet Window The Datasheet Window contains Datasheets where you can enter data. A Datasheet takes the form of a spreadsheet and is placed within a tab. By default, a Datasheet has 300 rows (1, 2, …, 300) and 50 columns (C1, C2, …, C50). The variable row of the table is for the variable names of the columns. Variables names cannot contain characters ' and ", and they cannot be the same for different columns. A cell in a datasheet can contain both text and numbers. Numbers in data cells are internally stored as double-precision 64-bit IEEE 754 floating point values, even though they are displayed to at most 6 decimal places. The tooltip of a cell shows the precise value stored in a cell. Adding a New Datasheet To add a new Datasheet to the Datasheet window, select File > New Datasheet. Saving a Datasheet A Datasheet can be saved in the following formats: Tab-delimited values (.txt) Comma-separated values (.csv) Excel (.xls) To save a Datasheet, make sure it is active (by selecting its corresponding tab) and select File > Save Current Datasheet…. In the save file dialog, enter the filename and choose the desired file format. To save the current Datasheet as a different file, use File > Save Current Datasheet As…. Opening a Datasheet/Import Data To open a saved Datasheet or import data from a file, select File > Open Datasheet. The following file formats are supported: Tab-delimited values (.txt) Comma-separated values (.csv) Excel (.xls) Closing a Datasheet Before closing a Datasheet, make sure it is the current Datasheet by selecting its corresponding tab. You can close a Datasheet by one of the following two ways: Select File > Close Current Datasheet. Click the cross button next to the Datasheet name on the tab. You will be given the option to save the Datasheet before closing it if there is any unsaved data. Printing / Exporting Data To print a Datasheet or export data to a file, select File > Print/Export Datasheet. In the print Datasheet dialog, select the desired print area: All: The entire Datasheet Selection: The selected (highlighted) cells Specified rows and columns: Enter the starting and ending row/column numbers Enter in the given text boxes the desired header and footer to be printed. Press Print to continue the printing or exporting process. A Print Preview window will appear. Use the File Menu to export data to the following formats: PDF (Portable Document Format) Excel RTF (Rich Text Format) HTML (HyperText Markup Language) CSV (Comma-Separated Values) Text file

Wyszukiwarka