
Appendix G. Importing Files into Excel
Data files saved by LoggerNet can be imported into a spreadsheet program for
analysis or manipulation. Instructions are given below for importing a comma
separated file into Microsoft Excel.
From the Excel menu, select File | Open. Browse for the *.dat file that you
want to import. Excel will recognize the file as not being in an xls format, and
will invoke the Text Import Wizard. The Text Import Wizard consists of three
steps, each having its own window.
G.1 Array-Based Data File Import
Array-based data files are typically comma separated with the first column of
each line being an array ID. If time and date are included in the arrays, they
may be in columns 2 through 5, with some of the columns optional. Excel will
easily read the comma separated file. Getting the different time columns
pulled together into one timestamp field takes a little manipulation.
Step 1 of 3
Select the Delimited option from the Original Data Type group box. Using the
arrow buttons to the right of the Start Import at Row field, select the number of
the first row of data to be imported. Select the Next button.
G-1
Содержание LoggerNet
Страница 2: ......
Страница 30: ...Preface What s New in LoggerNet 4 xxvi...
Страница 32: ...Section 1 System Requirements 1 2...
Страница 44: ...Section 2 Installation Operation and Backup Procedures 2 12...
Страница 136: ...Section 4 Setting up Datalogger Networks 4 80...
Страница 227: ...Section 7 Creating and Editing Datalogger Programs 7 9...
Страница 298: ...Section 7 Creating and Editing Datalogger Programs 7 80...
Страница 402: ...Section 9 Automating Tasks with Task Master 9 12...
Страница 406: ...Section 9 Automating Tasks with Task Master 9 16...
Страница 450: ...Section 11 Utilities Installed with LoggerNet Admin and LoggerNet Remote 11 22...
Страница 454: ...Section 12 Optional Client Applications Available for LoggerNet 12 4...
Страница 462: ...Section 13 Implementing Advanced Communications Links 13 8...
Страница 482: ...Section 14 Troubleshooting Guide 14 20...
Страница 570: ...Appendix F Calibration and Zeroing F 16...
Страница 578: ...Appendix G Importing Files into Excel G 8...
Страница 579: ......