BobyIsProgress
Member
Hello guys,
When I need to output some formatted data on excel I used the excel API that progress give us. But it's very slow.
Do find maybe a speed up way to do it by using the Microsoft.Office.Interop.Excel .
So I found some code on progress KB that was demonstrating the error you get when trying to use a range object (OE 10.2/11)
But on my station the compiler is not able to found the class.
I'm on windows server 2012 with office 2016 and OE 10.2B08 (soon I will go to OE 11.7 and maybe OE 12).
Best Regards,
- BobyIsProgress -
When I need to output some formatted data on excel I used the excel API that progress give us. But it's very slow.
Do find maybe a speed up way to do it by using the Microsoft.Office.Interop.Excel .
So I found some code on progress KB that was demonstrating the error you get when trying to use a range object (OE 10.2/11)
Code:
USING Microsoft.Office.Interop.Excel.* .
DEFINE VARIABLE objExcel AS CLASS Microsoft.Office.Interop.Excel.Application.
DEFINE VARIABLE objWorkbook AS CLASS Workbook.
DEFINE VARIABLE objRange AS Range.
DEFINE VARIABLE objSheet AS CLASS WorksheetClass.
objExcel = NEW Microsoft.Office.Interop.Excel.ApplicationClass().
objWorkbook = objExcel:Workbooks:Add("").
objExcel:VISIBLE = TRUE.
objSheet = CAST(objWorkbook:ActiveSheet,WorkSheetClass).
objRange = objSheet:Range("A1", "A2").
But on my station the compiler is not able to found the class.
I'm on windows server 2012 with office 2016 and OE 10.2B08 (soon I will go to OE 11.7 and maybe OE 12).
Best Regards,
- BobyIsProgress -