Hi Everyone. Im Trying to import an Excel file and into Temp-Tables. Ive pretty much given up on trying to import an xlsx Files so right now im trying to import CSV. Due to Commas included within the Test i cant simply just use the Comma seperated method.
Now Im Attempting to Use the Infragistic Method described in this Post.
The Issues im Having is when declaring my Workbook variable
DEFINE VARIABLE VWorkbook AS Workbook NO-UNDO.
I get the Invalid Datatype specified:Workbook Error
I did import these on the top on my code.
USING Infragistics.Documents.Excel.*.
USING Infragistics.Documents.Core.*.
Would i need to Add a library to my Propath?
[quote user="ridingmac"]
Hi Everyone. Im Trying to import an Excel file and into Temp-Tables. Ive pretty much given up on trying to import an xlsx Files so right now im trying to import CSV. Due to Commas included within the Test i cant simply just use the Comma seperated method.
Now Im Attempting to Use the Infragistic Method described in this Post.
The Issues im Having is when declaring my Workbook variable
DEFINE VARIABLE VWorkbook AS Workbook NO-UNDO.
I get the Invalid Datatype specified:Workbook Error
I did import these on the top on my code.
USING Infragistics.Documents.Excel.*.
USING Infragistics.Documents.Core.*.
Would i need to Add a library to my Propath?
[/quote]
Have you added InfragisticsN.Documents.Excel.vXX.X and InfragisticsN.Documents.Core.vXX.X to your assemblies.xml?
Values for N and XX.X depend on the version you are using.
[quote user="ridingmac"]
Hi Everyone. Im Trying to import an Excel file and into Temp-Tables. Ive pretty much given up on trying to import an xlsx Files so right now im trying to import CSV. Due to Commas included within the Test i cant simply just use the Comma seperated method.
Now Im Attempting to Use the Infragistic Method described in this Post.
The Issues im Having is when declaring my Workbook variable
DEFINE VARIABLE VWorkbook AS Workbook NO-UNDO.
I get the Invalid Datatype specified:Workbook Error
I did import these on the top on my code.
USING Infragistics.Documents.Excel.*.
USING Infragistics.Documents.Core.*.
Would i need to Add a library to my Propath?
[/quote]
Have you added InfragisticsN.Documents.Excel.vXX.X and InfragisticsN.Documents.Core.vXX.X to your assemblies.xml?
Values for N and XX.X depend on the version you are using.
You are my Hero. Thank you very much