Read Excel cell data automatically

[David_Lee]

From the given examples, before reading an excel data, you have to specify the start cell and the end cell number. Is there a method to read out excel data just by giving the file name?

David

[ebalci]

Hi David,

I cannot understand what you are trying to achieve by "read Excel just by file name".

Excel is cell-oriented. Everything written in it belongs to some cell.

If you are sure the data is in cell A1 then go and read A1.

If your data does not need to be grouped in a table fashion, then write it in a ASCII text file, you do not need Excel in that case.

What do you want to do finally?

Maybe you can tell more about your application.

[mkossmann]

Well, you will be able to load an excel file with fopen() . But that's probably not what you want, because you have to decode ondisk excel format yourself then.

Could you describe more precise, what you want to achieve ?

[David_Lee]

Sorry maybe describe cleared. In fact, my excel file is a  template, and just have one sheet, but the l row numbers will different, I do not want to import it into cvi table by specify the start cell and the end cell number each time, I need an interface to read all contents in the 1st sheet.

David

[RobertoBozzolo]

Well, then you can open Excel, open the first sheet in the collection and then iterate into the sheet and search for non-empty cells.

You can use the source code for ExcelRpt_ReadDataToTableControl () function into excelreport.c code as a guideline to develop your own function: iterate on all cells in the sheet and try to load only those that do not return CAVT_EMPTY in CA_VariantGetType () function.

[David_Lee]

Thank you Roberto.

[mahto]

Hi Robert,

I want to open an existing .xls file and read all cell values one by one  in a particular column.

example: in column E i want to read it in E1, E2, E3....so on manner by checking end of file also.

Could you please help me how to do it?

[RobertoBozzolo]

I suggest you look at the examples that ships with CVI: you can either follow Excel-only way (excel2000dem is the sample to look at) or Excel Report, which is built on top of this and which most user find more handy to use.

In either case, ways to read back cells content from a workbook are given for you to test and adapt to your needs.