01-27-2014 02:10 PM
Hi!
Often when I save data, I saved them as a text file. But sometimes, you need to show them directly as excel file. In that case, save the data first, and then read them as a report to present in excel.
What I want to know is why you can't save files directly in Excel. It is just for curiosity.
Thanks for your answers,
Best Regards,
Samuel G
Solved! Go to Solution.
01-27-2014 02:14 PM
01-27-2014 02:51 PM
Well,
I have done many searches, I've been using Labview a long time, so please don't be ironic. From someone like you, I would expect a very well founded response.
I have seen that many users don't use the Report Generation Toolkit. I have used the report generation and have many problems, because it leaves open the file where one is save the data, which is troublesome for the end user.
I hope someone can give me a well founded answer.
Best Regards,
SG
01-27-2014 03:02 PM
You might not be making the right calls. I use Excel for reports in labview and do not have the issue you are reporting with report file being left open. Do you have a specific question? Or what exactly are you looking for?
01-27-2014 03:02 PM
01-27-2014 03:08 PM
I have always used Active X for writing to excel and never had any issues. Can you be more specific or show the code your having problems with? Sorry, but I agree with Dennis, did you do a search?
01-27-2014 03:13 PM
01-27-2014 03:17 PM
I think Dennis should get a Kudos for his Well Founded Answer!
01-27-2014 03:46 PM
I use ActiveX to access Excel all the time. I have found that if you are not careful to close EVERY reference you either get or create you will leave an instance of Excel open. If you are using Excel invisibly you won't realize this has happened until you start seeing problems accessing your file. In that case you need to use Windows Task Manager to kill the process, it won't show up in the Applications window.
01-27-2014 08:50 PM
One of those 6000 posts was from me, about two weeks ago. I reworked an example given in the LabVIEW Example Finder using the Report Generator Toolkit, absolutely no ActiveX. The trick is to not use Excel templates, but to simply open an Excel report, write the data, then save the Report with the Excel name you want to use and close Excel. I'll try to paste a link here ...
http://forums.ni.com/t5/LabVIEW/Revised-quot-Generate-Excel-Report-quot-Example/m-p/2699083#M801667