09-19-2024 12:07 PM
Hi everyone,
I’m working on a project where I need to pass the data from a LabVIEW interface into a report format that is both user-friendly and customizable. The goal is to generate a report (preferably in Word or Excel) where the data can be easily understood and modified by others if needed.
Currently, I’m able to save images of the interface, but I need to include the data (organized in arrays) into a more flexible format like Word or Excel, allowing users to edit and customize it if necessary. I’m looking for a way to do this directly from LabVIEW, ideally using something that would allow formatting and easy editing.
Here’s what I’ve tried so far (I’ve attached my VI and screenshots of the current output), but I’m not sure how to proceed with creating a more structured and editable report format.
Goals:
Any advice or examples on how to achieve this would be greatly appreciated!
Thank you in advance!
09-19-2024 05:05 PM
Have you tried this toolkit?
09-19-2024 09:51 PM
Yesterday, you asked basically the same thing. I suggested that if you were creating a Report, then the Report Generation Toolkit might be helpful. @Artem.SPb suggested the same thing (see previious Reply).
There are examples that ship with LabVIEW that demonstrate creating an Excel Report. A decade ago, I posted on this Forum a "Revised Generate Excel Report" demo that shows how you can programmatically generate an Excel Report, with Headers at the top of selected columns and Row Labels to the left of selected rows, and even adds a Plot of some of the data on the Excel Worksheet. You can find it by going to the Search bar on the first page of this Forum and starting to type "Revised Excel " and it should pop up. [The real title is Revised "Generate Excel Report" Example, but the Search bar should find this just by typing "Revised Excel ".]
Please do not start a new Post for the same question!
Bob Schor
09-20-2024 05:57 AM - edited 09-20-2024 05:58 AM
First, I’d like to thank you all for your previous responses and understanding, and I apologize for posting a similar question. However, the issue I’m facing this time has a slightly different focus (and that’s on me for the confusion!).
I’ve been trying to export data from a LabVIEW interface into Excel, but I keep running into problems. For some reason, the data either doesn’t transfer properly, or the output is simply blank. Despite my attempts at organizing the data for Excel, nothing seems to work.
What I’m looking for is guidance on how to create an interface in LabVIEW that can successfully capture the data and pass it to Excel in a way that’s structured and editable. This differs from my last post because I’m now focusing on how to build the interface itself to ensure the data transfer works properly.
Here’s what I’ve tried so far (I already attach my current VI and screenshots), but I’m really struggling to get the data to transfer in a usable format.
I will try to use the "Revised Excel " and see what I get
Any advice on how I can fix this and properly set up an interface for exporting data to Excel would be greatly appreciated!
Thanks again for all your help!
09-20-2024 06:23 AM
09-20-2024 06:30 AM
... True, I forget, my bad
09-20-2024 07:50 AM
As an experiment try removing the "talvez" input and see if you get anything.
09-20-2024 08:08 AM
Well, it really worked in the test field, amazing!
I will try to populate the .vi and see what happens. Thank you for noticing this detail, @ooth.