12-01-2010 01:38 AM
hi,All
i am using LabVIEW Report Generation Toolkit,and a newer.i want to insert the data in excel for every loop.
so at first,need to creat a excel file(xxx).and when every loop end,the test data can be insert into the file(xxx).when the test finished,the file will be saved.
i have seen the examples in LabVIEW Report Generation Toolkit, all of them need to creat a new file.i need update the data in the same file.
can you give me some advances for that?
my labview's version is 8.5 and LabVIEW Report Generation Toolkit's version is 1.1.0.
thanks a lot.
12-14-2010 10:24 PM - edited 12-14-2010 10:26 PM
Hi cat099,
One question, why don't you store data of each loop, say in shift register and update all data in excel at once when your test is finished.
It will be easy. Or else, if you want to build same functionality as you mentioned, then you can build your own vi to write in excel. No need to use report generation toolkit.
See attached example.
12-14-2010 10:58 PM - edited 12-14-2010 10:59 PM
Hi
Did you try using the "write to spreadsheet" option in the File i/o palette?
That works better and is easier to implement.
Vijay Chand Ganti
12-15-2010 09:28 AM
cat099,
Opening an existing Excel file is pretty easly. 'New Report.vi' has an input named 'Template'. Use this input to open an existing file. This can be either a .xls or .xlt Excel file.
12-21-2010 07:27 PM
do you have a 7.1 version of the example?
12-15-2017 07:45 AM
Hello Gaurav,
Excellent Its working fine
Is there any option to find the last row of the active work sheet and then add content after the last row+1.
Regards,
Vivek G.
12-15-2017 10:27 PM
@vivek1006058 wrote:
Is there any option to find the last row of the active work sheet and then add content after the last row+1.
Yes. Look at the Excel-specific Functions on the Report Generation Toolkit Palette and choose the one with the "obvious" name. Read its help description to find out exactly how it works. Put a little of your own effort into solving your problem (it really isn't that difficult -- it might take you 1-2 minutes of your time ...).
Bob Schor