open and read a excell file

[PerBorgvad]

Hi

I'm trying to open an existing excell file but the function Excel_WorkbooksOpen() returns error.

The code is as below :

err=Excel_NewApp(NULL,1,LOCALE_NEUTRAL,0,&applicationHandle);
 
 err=Excel_GetProperty(applicationHandle, NULL, Excel_AppWorkbooks,
                    CAVT_OBJHANDLE,&workbooksHandle);
                   
 err=Excel_WorkbooksOpen(workbooksHandle,NULL,"MyFile.xls",CA_DEFAULT_VAL,
                                             CA_DEFAULT_VAL, CA_DEFAULT_VAL,
                                             CA_DEFAULT_VAL, CA_DEFAULT_VAL,
                                             CA_DEFAULT_VAL, CA_DEFAULT_VAL,
                                             CA_DEFAULT_VAL, CA_DEFAULT_VAL,
                                             CA_DEFAULT_VAL, CA_DEFAULT_VAL,
                                             CA_DEFAULT_VAL, &workbookHandle);

A second question is :

How can I deterime how many rows the excell sheet has ?

Regards Per

[dsappet]

It looks like you are playing with the example givin by NI? \CVI\samples\activex\excel\excel2000dem.cws ? What do you mean by returns an error? Does it not compile? or does it compile but crash and return an error when you run it? Are you sure that the file you are trying to open exists and you are pointing to the proper location that the file is kept in? If it is in your main project folder and you are running the program in debug mode than the program will be running in a different folder than the xls is kept in. With a little more detail I'm sure we can get it working for ya.

Cheers

[dsappet]

Also I forgot to check and make sure that you have an instrument file for excel (an .fp file) included in your project, this is important. if you don't have one you can look at root\ . .... \National Instruments\CVI85\samples\activex\excel\excel2000.fp

[PerBorgvad]

You are right, I'v copied lines from the excell2000 example into my app. The xls file is present in the same

directory as the source code.

My app compiles and do not crash, but the function Excel_WorkbooksOpen() returns the error code -2147352567

and the variable "workbookHandle" remains 0.

I do run the app in the debuger.

excelreport.fp is included in the project.

Regards Per

[dcl9000]

Hi! Per,

You need to add two backslashes to your file name like this "\\MyFile.xls"

[RobertoBozzolo]

If I'm not wrong you must pass a complete filename to Excel_WorkbooksOpen. Try this:

char   file[MAX_PATHNAME_LEN];

GetProjectDir (file);

MakePathname (file, "MyFile.xls", file);

error = Excel_WorkbooksOpen (ExcelWorkbooksHandle, NULL, file, CA_DEFAULT_VAL,
   CA_DEFAULT_VAL, CA_DEFAULT_VAL,
   CA_DEFAULT_VAL, CA_DEFAULT_VAL,
   CA_DEFAULT_VAL, CA_DEFAULT_VAL,
   CA_DEFAULT_VAL, CA_DEFAULT_VAL,
   CA_DEFAULT_VAL, CA_DEFAULT_VAL,
   CA_DEFAULT_VAL, &ExcelWorkbookHandle);
 

[dsappet]

It is obviously best practice to use a complete filename including the total path. But I tested out the example project and played around, finding that you can open things locally, so if define just myfile.xls it will open it as long as it is in the directory you are running the program out of, this means however if you are playing in debug mode, you need to put the file in the debug folder!