extract excel data by cell name?

[drd525]

I'm developing a program to extract, process, and compile data from Excel spreadsheets. It works just fine when the cell ranges are explicitly defined (Open Excel > Open Book > Open Sheet > Read Number/String), however, I'd like to rewrite my code in order to read numbers/strings based on cell name (e.g. "Data1" instead of defining the worksheet number and cell range that comprises "Data1"). I think this should be possible without the special NI Excel Report Generation toolkit thing, but I'm not sure how to go about it. I'm using LV7.1.

Thanks for any assistance provided on this issue.

[Joe_H]

Yes you can and actually you do it the same way but instead of putting A1,A1 you put in your name.

I have attached an example VI and xls file.

For more information and some sample VI's and tool kits, you can go to the excel board

[Joe_H]

After reading your post again I do not think that you will be able to do it without specifying a sheet.

[drd525]

Thanks very much for your help Jhoskins. However, the example code you provided is for LV 8.2.1, and I only have 7.1 at my disposal. Could you provide a snapshot of the block diagram?

Message Edited by drd525 on 07-09-2007 12:35 PM

[Joe_H]

All that I really did was instead of putting something like A1:A1 I put in the name of the cell. You can use the example and do the same thing.

[BME_genuis]

How does Excel know what cell name you specify in Labview corresponds to what cell in Excel?

[Joe_H]

---

BME genuis wrote:
How does Excel know what cell name you specify in Labview corresponds to what cell in Excel?

---

I am not sure what you are asking. You have to set up name ranges in the Excel spreadsheet. you can look at the Excel help for that.

For more information and some sample VI's and tool kits, you can go to the excel board

[BME_genuis]

How do you setup name ranges in the Excel spreadsheet.

[Joe_H]

In the spreadsheet you will have to name your cells. You can have a look at the Excel help.

Excerpt from Excel help.

Message Edited by Joe_H on 05-28-2009 02:50 PM

[amél]

I'm trying to create a program in LabVIEW which must automatically populate an Excel file with different types of grandeurs.j 'reuçi have to do with laision labview excel in a file that was in the file c \ program over \ National Instruments \ comm com file is in exmpleexcel I clicked on disue is reuçi I have a table that was created by repmli labview but the problem is I want each hour repmli line Exmple: 06:30 is fulfilled the box in line 1 7:30 filled the box in row 2 ............ when it exceeds 8d fau hours a pose and it will encor continuier Comsa I have put the file that I ss entr1 of travaillier with (if you help me plaier)