LabWindows CVI Opening existing Excel file and writing a float value to a specific cell

[ras27]

I am trying to open an existing Excel file in CVI and write to a specific (not a range) .

I have tried:

error = ExcelRpt_ApplicationNew(1, &applicationHandle); 

ExcelRpt_WorkbookNew(applicationHandle, &workbookHandle);

ExcelRpt_WorkbookOpen (applicationHandle, "TestBook.xls", &workbookHandle);

ExcelRpt_GetWorksheetFromName (workbookHandle, "Sheet1", &worksheetHandle);

ExcelRpt_SetCellValue (worksheetHandle, "F2", ExRConst_dataDouble , pin5_value_1);

The above will open a new file (not the TestBook.xlsx file) and write to the proper cell with the correct information

Then I tried the example in "excel2000dem" (error stuff removed)

Excel_NewApp (NULL, 1, LOCALE_NEUTRAL, 0, &ExcelAppHandle);

Excel_SetProperty (ExcelAppHandle, NULL, Excel_AppVisible, CAVT_BOOL, appVisible?VTRUE:VFALSE);

MakeApplicationActive ();

excelLaunched = 1;

Excel_GetProperty (ExcelAppHandle, NULL, Excel_AppWorkbooks, CAVT_OBJHANDLE, &ExcelWorkbooksHandle);

GetProjectDir (fileName);

strcat(fileName, "\\TestBook.xlsx");
Excel_WorkbooksOpen (ExcelWorkbooksHandle, NULL, fileName, 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);

Excel_GetProperty (ExcelAppHandle, NULL, Excel_AppSheets, CAVT_OBJHANDLE, &ExcelSheetsHandle);

Excel_SheetsItem (ExcelSheetsHandle, NULL, CA_VariantInt(1), &ExcelWorksheetHandle);

Excel_WorksheetActivate (ExcelWorksheetHandle, NULL);

The above worked get at opening the existing file but then I couldn't write to the correct cell (or any cell)

I tried:

ExcelRpt_SetCellValue (ExcelSheetsHandle, "F2", ExRConst_dataDouble, pin5_value_1);

and a couple of other items but to no avail.

Can anyone help with this issue?

Thanks

ExcelRpt_SetCellValue (ExcelWorkbookHandle, "F2", ExRConst_dataDouble, pin5_value_1);

[RobertoBozzolo]

One possible reason is that ExcelSheetsHandle is the handle to the collection of all sheets in the file while ExcelWorkbookHandle is the handle to the whole file: none of them is the handle to the active sheet you are working on. Moreover, I don't think you can mix functions from Excel Report instrument and from base Excel Object Library in the same function (but I may be wrong on this, I never used Excel Report instrument).

If you want to follow the path of Excel2000dem example you could create and activate a single cell range and then write the value you want to it, more or less the way done in WriteDataToExcel (), case 2 of the example.