Spreadsheet

MGI Read Spreadsheet File

Reads a spreadsheet file by returning the first non-empty, non numeric containing rows as a header, then the following numeric rows. Reading starts at Start Offset. End Offset is the file offset for the next Header/Values section. This VI is similar to the vi.lib file "Read From Spreadsheet File.vi", but it supports headers.

MGI Write Spreadsheet File

Creates or opens the specified spreadsheet file and writes the specified data to the end of the file. This VI is similar to the vi.lib\Write Spreadsheet File.vi, but it includes headers. By default, headers are only written if the file is created new. Wire true to "Append Headers to existing files?" to add them to existing files as well.