Open & Edit an Excel File

[heepofajeep]

I am using 'Write to XL' Example VI with Labview 7.0 .

I would like to be able the data on the front panel to an already existing Excel spreadsheet, without deleting the old data in the original spreadsheet. 

I have the opening an existing spreadsheet handled, but I cannot seem to write without losing the old data first.

I have attached my edited VI & the example VI [almost identical, but nonetheless...]

Thanks!

[Scott P]

Hello,

      There are some words missing for me to understand exactly what you want to do.  You state "I would like to be able the data...."  What is it you want to do with the data.  I'm guessing that you want to be able to ADD the data to an exising Excel file without disturbing the old data.  Is that true.  I couldn't tell from your vi's because I couldn't properly open them.  I have LabView 7.1 and I may not have all of the sub-vi's you do.  It would help if you would save your vi's into an library file with the supporting vi's included.  Then I can easily open the vi and look at it.  Try "Save with Options" and tick "Application Distribution".  It should default to a library file (llb).  Then post that. 

Thanks, Scott

[heepofajeep]

---

@Scott P wrote:

Hello,

      There are some words missing for me to understand exactly what you want to do.  You state "I would like to be able the data...."  What is it you want to do with the data.  I'm guessing that you want to be able to ADD the data to an exising Excel file without disturbing the old data.  Is that true.  I couldn't tell from your vi's because I couldn't properly open them.  I have LabView 7.1 and I may not have all of the sub-vi's you do.  It would help if you would save your vi's into an library file with the supporting vi's included.  Then I can easily open the vi and look at it.  Try "Save with Options" and tick "Application Distribution".  It should default to a library file (llb).  Then post that. 

Thanks, Scott

---

I would like to be able to ADD data on the front panel to an already existing Excel spreadsheet, without deleting the old data in the original spreadsheet. 


Sorry about that, I couldn't even make sense of it when I read it, lol. 

I will resave the Vi in the morning with the subvis attached. 

Thanks!

[heepofajeep]

?!?!?!?

[Spex]

heepofajeep,

I think you are on the right track.  Instead of using the "Open New Workbook" and "Open New Worksheet.vi" VI's, I think you need to use the "Open Specific Workbook.vi" and "Open Specific Worksheet.vi" VI's,  These VI's are within the same llb as the "Open New" VI's.  This will get you started with the existing data already in the .xls, rather than an empty sheet. 

Next, you just need to set an offset in the rows and/or columns that you will be writing data to so that you don't overwrite the old data.  Within the nested For loops of your VI, the rows and columns are being set.   A simple offset of +4 on the row data would put a new set of the data directly below the existing data in the .xls file.

Hope this helps!

[Joe_H]

you can also check out the Excel board for a host of excel VI's that me and many others have posted. If you are still struggling with this let me know and I will help you.

[srinates]

hello

i wil try to open your sub vi ..but its not possible can u atachec ur sub vi files

[Dennis_Knutson]

You realize that you are posting to an EIGHT year old thread?