08-28-2024 03:50 AM
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!
08-28-2024 04:07 AM - edited 08-28-2024 04:13 AM
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.
08-28-2024 04:20 AM
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.
08-28-2024 07:59 AM
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.
08-28-2024 08:42 AM
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