excel update

[jbrohan]

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

[Kaustubh_vc]

Hi!

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

It will help to solve your query.

Kaustubh

[Andy F.]

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.