LabVIEW

cancel
Showing results for 
Search instead for 
Did you mean: 

Copy Excel sheet to another workbook

I'm trying to copy an excel sheet to another sheet in another workbook (and save all formulas and formats).
I'm using LabView 6.1 and win2000.
can you help me with that ?
Thanks.
0 Kudos
Message 1 of 5
(5,718 Views)
You will need to use the Worksheet.Copy Invoke node and wire the Before or After input with a reference to a worksheet in another workbook.

If you are already accessing both workbooks, just create a reference to a sheet in the target workbook using the Workbook->Sheets Property and Sheets->Item Invoke nodes. Use Variant to Data to convert that variant into a _Worksheet reference.

Use a _Worksheet->Copy Invoke node with the source sheet as the input reference. Then wire the target reference into the Before or After input and you are done.

Michael
www.abcdefirm.com
Michael Munroe, CLD, CTD, MCP
Automate 1M+ VI Search, Sort and Edit operations with Property Inspector 5.0, now with a new Interactive Window Manager!
Now supports full project automation using one-click custom macros or CLI.
Message 2 of 5
(5,718 Views)
It works fine - thanks for the help !
0 Kudos
Message 3 of 5
(5,718 Views)
It works fine - thanks for the help !
0 Kudos
Message 4 of 5
(5,718 Views)
Thanks a lot for the insight. This is an example that I made in Labview 8.21.
0 Kudos
Message 5 of 5
(4,842 Views)