How do I put data into a template using the Labview report generation toolkit for Microsoft Office?

[JPhillips]

I am running Lookout 5.0 and have recently purchased the Labview Report Generation Toolkit for Microsoft Office to create reports from my Lookout logged data. Since I have never used Labview I am having my problems. I tried following the tutorials but they do not seem to be examples of what I want to do.

I log rainfall totals (1 spreadsheet)in Lookout from 40 different sites in 5 minute increments. I copy these totals and paste them into another spreadsheet which sums them up to give me hourly totals and then paste those totals into a spreadsheet for distribution.

In Labview I create a new report and use the distribution sheet as my template, but how do I complete
the steps of loading the raw 5 minute data into labview and then paste it into the hourly total spreadsheet and then transfer those totals into the distribution template?

I have been trying to figure this out for over a week, and I am getting nowhere.

Any response would be appreciated.

Thanks

Jason P

[Faraclas]

In terms of loading the data, I am not familiar with lookout and thus do not know what type of file the data will be in.

Once the data is in LabVIEW and the report (template) is opened, you can send it to Excel. I use the Excel_Insert_Table.vi (although I have modified it to accept a reference to the worksheet instead of the report) to copy ALL of my data into Excel. All you need to know are the cell locations (starting point) where the data is headed

Without more specifics, I don't know what else to tell you. Hope this helps.

[JPhillips]

Lookout saves the files in .csv form which can be opened in Excel. I did make some progress by using the "append table to report" vi which allowed me to put values into an array and then those values were entered into my template on my report vi.

Where I am stuck now is I want to be able to put values into my template from a .csv file, not from an array I have to manually put numbers in.

Once those values are in my template I want to pull summed values from the template and place them into a final excel file for printing.

I have attached examples of the files I am working with to help you better understand what I am trying to do.

I hope that makes sense.

[Faraclas]

When I have a spare moment I will look at these for you. Until then, you should read the .csv file into LabVIEW (Read Spreadsheet File.vi using "," as the delimeter) and then format this array into the appropriate form to use in the "append table to report".vi

Once this is done, you can manipulate the data as you see fit (either in LabVIEW or the first Excel template) until it is ready to be exported to the final spreadsheet.

Hope this will get you started in the meantime