LabVIEW

cancel
Showing results for 
Search instead for 
Did you mean: 

Excel easy table. vi , column headers problem

Hello!

 

I am using Excel Easy Table.vi to write testing datas into a excel file.

I indicated column headers names, but it didn´t work. The file is always generated without column headers. 

 

The structure I make is: Creat Report. vi --> Excel Get Worksheet. vi --> Excel Easy Table. vi --> Dispose Report. vi

 

Anyone can help me? Thanks!

0 Kudos
Message 1 of 5
(317 Views)

Keep "Iteration" Value Zero (0), It will work. 

Don't forget to provide True constant to "Save Changes?" input, if you want to save the excel sheet.

Download All
0 Kudos
Message 2 of 5
(308 Views)

Thanks for your solucion. Now it shows column headers. But it does not capture all datas. Everytime the older datas are overwritten by new ones. Excel always show 2 rows, the column headers and the lastest datas.  

0 Kudos
Message 3 of 5
(303 Views)

That's correct. 
In order to append the data, you will have to write a logic by using "build array" function. 

 

 

Atul Ghumade

LabVIEW Enthusiast,
Kudos are welcome

If you feel that my answer is really helpful, don't forget to mark the reply as solution. 

0 Kudos
Message 4 of 5
(269 Views)

Good morning, John.

 

     If you go to the Search Bar at the top of the LabVIEW Forum and start typing "revised", it should pop up Revised "Generate Excel Report" Example that I submitted to the Forum a decade ago.  It uses the Report Generation Toolkit and Excel Easy Table, shows how to make Row and Column headers, even inserts a graph (of fake "generated data".  It still works, though you might replace Item #6, "New Report", with the current "Create Report", but this really isn't necessary.

 

Bob Schor

0 Kudos
Message 5 of 5
(250 Views)