Load excel document using Infragistics

Posted by atuldalvi123 on 14-Mar-2019 09:04

Hello,

I am using below code as a sample test to load the excel file using the Infragistics objects but it fails, getting error message as

" Could not locate method 'Load' with matching signature in class 'Infragistics.Documents.Excel.Workbook'. (14457)
**  Could not understand line 8. (196) "
 

Pls suggest.

--------- Code ------------------------

USING Infragistics.Documents.Excel.*.
USING Infragistics.Documents.Core.*.

DEFINE VARIABLE VWorkbook  AS Workbook            NO-UNDO.
DEFINE VARIABLE VWorksheet AS Worksheet           NO-UNDO.
 
 
VWorkbook = Infragistics.Documents.Excel.Workbook:Load("c:\tmp\test.xls").

Posted by tmasood on 14-Mar-2019 09:42

Hi Atul,

Try this

VWorkbook = Infragistics.Documents.Excel.Workbook:Load("c:\temp\test.xls",no).

I hope it work for you.

Regards,

Talha

All Replies

Posted by tmasood on 14-Mar-2019 09:42

Hi Atul,

Try this

VWorkbook = Infragistics.Documents.Excel.Workbook:Load("c:\temp\test.xls",no).

I hope it work for you.

Regards,

Talha

This thread is closed