cancel
Showing results for 
Search instead for 
Did you mean: 

Saving Excel sheet

P_innovative
Member

Saving Excel sheet

Message contains an attachment

Hello All,

 

I am student doing my Master Thesis in Knorr Bremse Munich. As i am begineer to LabVIEW facing some difficulties in few topics. Below is my problem and i hope i get solution for this.

 

I am writing some random numbers into table and generating report on same. Report generated is Excel format. As part of my work i want to save this generated report on clicking save button. Below is the simple code i have designed. The problem i am facing is no saving function for excel sheet is present instead i find same for HTML. I there any solution for this. And report should be saved on clicking save button.

 

Thanks in advance.

6 REPLIES 6
James.M
Active Participant

Re: Saving Excel sheet

Message contains a hyperlink Message contains an image

There is a Save Report to File VI in the report generation palette.

Here is a very simple way to do this:

Save.PNG

 

But it looks like you have some other functionality you want to add. You should look in to the State Machine architecture. 

The Simple State Machine template that ships with LabVIEW is really the best way for new developers to get familiar with LabVIEW while utilizing a semi-scalable architecture.

 

Cheers


--------,       Unofficial Forum Rules and Guidelines                                           ,--------

          '---   >The shortest distance between two nodes is a straight wire>   ---'


P_innovative
Member

Re: Saving Excel sheet

Hi,

 

Thank you so much for quick response.

 

I tried using Save report to file function. Since i want to save data during runtime i am unable to do this. The report generated is blank. i tried saving providing path but again the file is still blank.Does this save function work during runtime? If not what would be the solution?

 

Regards,

Pragathi

Gregory
Trusted Enthusiast

Re: Saving Excel sheet

Yes it definitely works during runtime. Do you have Excel on the computer you are trying to run it on?

P_innovative
Member

Re: Saving Excel sheet

Yes.

 

I got the issue. Thank you so much for fixing it.

 

Regards,

Pragathi

Gregory
Trusted Enthusiast

Re: Saving Excel sheet

Hi Pragathi, 

 

Please post your solution so that others can learn if they come across this thread later.

P_innovative
Member

Re: Saving Excel sheet

The problem was with my system internal storage. the files were getting saved in wrong location because of which i could not figure out right report. But yes code works properly. Thanks again.

 

Regards,

Pragathi