LabVIEW

cancel
Showing results for 
Search instead for 
Did you mean: 

save excel after every row

Hi,

      I'm using labVIEW8.6. I'm saving data into an excel sheet.For this I'm using "excel save report.vi".But I want to save it after inserting values in each row.that is it has to be automatically saved sfter inserting values in each row.How can I go about it?

Regards
RobinHood
0 Kudos
Message 1 of 7
(2,754 Views)
Why not just call Save Report to File VI after each insert with Prompt to Replace set to False?  Seems to be the simple solution.
Matthew Fitzsimons

Certified LabVIEW Architect
LabVIEW 6.1 ... 2013, LVOOP, GOOP, TestStand, DAQ, and Vison
0 Kudos
Message 2 of 7
(2,725 Views)

Hi Matthew,

                  I've modified my code as per your instructions but I'm getting one error saying"ERROR 5 occured at open/create/replace file in NI_Excel lvclass:save repor to file.vi->excel save.vi.I've attached my code here. please find it.

Regards
RobinHood
0 Kudos
Message 3 of 7
(2,711 Views)

 

Try using Dispose Report.vi instead of Save Report to File.vi

Brian
0 Kudos
Message 4 of 7
(2,684 Views)

Hi McLean,

                 We can use it,.But the problem is if we run this program, a window will open asking where to save this excel sheet.I don't want this to happen.Once I run the code ,ecxcel sheet has to be saved automatically.

Regards
RobinHood
0 Kudos
Message 5 of 7
(2,674 Views)
If you give New Report.vi a file name before you start it wont prompt you.
Brian
0 Kudos
Message 6 of 7
(2,666 Views)

Smiley Tonguesorry...I don't understand what you said.If you donSmiley Sad't mind can you modify my code.

Regards
RobinHood
0 Kudos
Message 7 of 7
(2,644 Views)