Read excel cell when excel is already open

[Djamel_LFC]

Hello,

I want to read a specific cell of a sheet with excel already open. Labview has only to read the cell and not have to open excel.

I have several examples that show :

1. Labvview open excel
2. select excel file
3. select workbook
4. select sheet
5. select cell
6. read cell
7. close workbook
8. close excel

In my vi i only need the step 3 to 6

Thank for your help

Djamel

[Ken_Naylor · Accepted solution]

The attached (LabVIEW 2012) vi will return the value in the cell 'A1' of 'Sheet1' of the already open excel workbook 'book1'

Change the values for your specific names of workbook and worksheet and required cell.

The value returned is a variant so need to be converted with 'Variant to Data' according to data type

Ken

[Djamel_LFC]

Thanks a lot thank you for your quick answer, it's precisely the solution I was looking for.

Djamel