In my situation, the test station always records the same type of data with maybe a dozen header fields that describe the test setup. For each type of test, I create a master template workbook that I open, fill with data, print the report and then Save As a new file.
Rather than compress the data into the top left corner of the sheet, I space out the fields, give each one a descriptive title and make the whole page look more presentable.
In Excel, I use Insert->Name->Create to give the data locations unique names. In LabVIEW, I use the Range Names instead of cell references to save each data into the proper location. Just wire the name into the Cell1 input. Excel translates the Range Name into the corresp
onding cell location and directly addresses the proper cell. I also use relative row and column indexes to accomodate repeating data.
In the example attached, notice how "Fit_MSE" appears in Excel's cell address just above the "A" column instead of "C8". You can define new names by typing into this box directly.
The two benefits are that I don't have to keep track of each data's cell address, and if I make major edits to the template, I don't have to change my LabVIEW code. All Range Names are adjusted automatically when rows or columns are inserted.
Michael Munroe
www.abcdefirm.com