Read specific cell and worksheet in excel

[Mr_Papagorgio]

Hello,

I have multiple excel files with multiple worksheets. The worksheets default names were sheet1, sheet2, sheet3, etc.... but have been renamed to main, calculations, results, etc... ( i didn't know if this bit of information was important). I want to read a specific cell in a specific worksheet of every excel file in a directory, for example read cell "B3" in the "results" worksheet of all excel files in a certain directoy and display this value on the front panel.

I've been able to programtically populate a list of all the excel files in a directory, but cannot figure out how to read the files. Anyone know how to achieve this or even where to start?

I've seen that activex is useful in reading/writing excel files but cannot find any good refernces on how to use activex. Any help is appreciated, thanks.

[Bob_Schor]

It is always helpful to us, and to you, when you post code.  Among other things, it tells us which Version of LabVIEW you are running.  We can also "guess" at your level of expertise and experience by examining the code, and adjust our comments accordingly.

The easiest (by far!) method of reading data from named Excel Workbooks is to use the Report Generation Toolkit.  You can use New Report to open a named Excel Workbook, Get Worksheet to open a named Worksheet, Get Excel Location to map B3 to Excel row and column, and Get Data to return the contents of the cell.

There are examples included in LabVIEW, and more examples here in the Forums.

Bob Schor

[vsenthil957@gmail.com]

hi

   there are number of ways to do it. Best is to use Labview report generation toolkit, but if you dont want to spend on toolkit, u can use free Labview excel librerys. example i have given a link here.  

https://decibel.ni.com/content/docs/DOC-39826

you search in google and come up a numerous other free toolkit or librerys.

regards

V.Senthil kumar

[paul_cardinale]

Try starting with this.

[mohanseenivasan]

can u see the attachment specify part in New report and advice me for solutions

[Bob_Schor]

Hello, @mohanseenivasan.

    You are trying to "hijack" a Post on the Forum that is more than 8 years old!

     Please start a new post, explaining clearly what you are trying to do, and providing examples of code you have tried that doesn't work.  

     When providing your code, you should remember that many long-time LabVIEW Forum members are probably not using the most recent version of LabVIEW, so you should "Save for Previous Version" and specify LabVIEW 2019 or 2021, for example.

Bob Schor