Skip to Content
0
Former Member
Mar 22, 2010 at 10:11 AM

Dataset Problem while reading an excel file

368 Views

Hi Friends,

I have a excel sheet in one of the directory in application server...

Now iam opening the data in text mode to read line by line of the excel..

Open data Zsample in text mode encoding default

Now iam able to open a file here but when i try to read data using read dataset iam getting a short dump here...

The dump error is cannot convert to code page 4102.

Now how to over come this senario... i tried using UTF-8 also but iam getting the same dump.. UTF-16 is giving me a syntax error.

when i tried to open the same excel sheet using AL11 manually iam getting the same dump as above..

Now my question is can we read an excel file from application server... if so how to proceed further .. ?

Suggestions will be appreciated..

Regards

Kumar