LabVIEW

cancel
Showing results for 
Search instead for 
Did you mean: 

excel update

Hello
I'd like to update an existing Excel Spreadsheet with some new values. Does anyone have an example of this? I need it not to ask whether to update an existing file, everything else works just fine? I represent the spreadsheet internally as an arry of variants, and update this.array. The problem is that if I just delete teh file and write it as a new file, then I loose all teh formatting, and some columns haave date formatting which I particularly need not to mention the computation formulae.
Yours Sincerely
john
0 Kudos
Message 1 of 3
(2,653 Views)

Hi!

Can u just upload your vi, so we can get clear idea.

It will help to solve your query.

 

Kaustubh

0 Kudos
Message 2 of 3
(2,634 Views)
John,
 
I might suggest taking a look at some of the Excel examples that ship with LabVIEW.  If you launch the Example Finder (Help >> Find Examples) and search for Excel and select Write Table to XL.vi.   This is a good place to start.  Basically it involves ActiveX calls to Excel to add data to a spreadsheet.  If you already have the spreadsheet made, there are calls to open these files and edit them without completely destroying the data.  You might be able to index through your dataset and find where you need to start adding data.  Hope this helps!
 
Andy F.
-----------------------------------------------------------------
National Instruments
0 Kudos
Message 3 of 3
(2,613 Views)