LabVIEW

cancel
Showing results for 
Search instead for 
Did you mean: 

Read and Write specific sheet in excel

is there and way to read and write a specific sheet in excel?

or must i have this report generation tookit to read from specific sheet in excel and write to a specific sheet?

 

i already have a template with quite a number of sheet, and all of them is formatted

so i want to read the data from the specific sheet and display in my labview table

and

i also wan to write the data to a specific sheet in the excel file.

is it possible?

0 Kudos
Message 1 of 4
(2,717 Views)

You'll need to use ActiveX functions in LabVIEW to open the Excel File and get to the particular sheet.  Search help for "ActiveX" and Excel.  Also browse the listing of links in the Excel thread.  Don't post there.  It is just a collection of links to other message threads about working with Excel.

 

Actually, I now see you already found that thread, but apparently did read.

 

1.  Go through that board page by page, message by message.

2.  If you see a message that looks like it applies, then click on the link provided to go to the original thread in the LabVIEW board to read the discussion or see the example that posted.

0 Kudos
Message 2 of 4
(2,704 Views)

cant really find it...

theres some is either too old version or missing VIs

0 Kudos
Message 3 of 4
(2,697 Views)

You should pay attention to http://msdn.microsoft.com/en-us/library/wss56bz7(VS.80).aspx in order to find out how to interact with Excel without Report Generation Toolkit.

0 Kudos
Message 4 of 4
(2,665 Views)