how to update data to excel in runtime with LabVIEW Report Generation Toolkit

[cat099]

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.

[Gak]

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.

[Vijay Chand]

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

[Wayne.C]

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.

[Bernard14]

do you have a 7.1 version of the example?

[vivek1006058]

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.

[Bob_Schor]

---

@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