05-22-2006 11:32 AM
Hi Group,
How to read Excel file from Application server which is having multiple sheets.
05-22-2006 11:36 AM
hi,
check this link:
/people/sap.user72/blog/2006/01/19/upload-data-from-multiple-worksheets-within-a-single-excel-file-into-internal-table-from-abap - 24k
Award points if helpful.
regards,
keerthi.
05-22-2006 11:39 AM
05-22-2006 11:37 AM
Check these links
/people/sap.user72/blog/2006/01/19/upload-data-from-multiple-worksheets-within-a-single-excel-file-into-internal-table-from-abap
http://sap.ittoolbox.com/code/archives.asp?d=3027&a=s&i=10
Thanks,
Susmitha
05-22-2006 11:37 AM
05-22-2006 3:28 PM
Hi Group,
Can any body suggest how to read the Excel file which is existing on Application Server.
05-22-2006 3:30 PM
hi
chk this out
DATA:
dsn(20) TYPE C VALUE '/usr/test.xls',
rec(80) TYPE C.
OPEN DATASET dsn FOR INPUT IN TEXT MODE ENCODING DEFAULT.
IF sy-subrc <> 0.
EXIT.
ENDIF.
READ DATASET dsn INTO rec.
WHILE sy-subrc <> 0.
WRITE / rec. READ DATASET dsn INTO rec.
ENDWHILE.
CLOSE DATASET dsn.
05-22-2006 3:35 PM
HI Pra,
Use these
<b> OPEN DATASET <NAME> FOR INPUT IN TEXT MODE.
READ DATASET <NAME) INTO <OUTPUT></b>
Regards,
Santosh
05-22-2006 3:36 PM
Hi Ganesh,
In my Excel file I am having data in Multiple sheets,how to read these multiple sheets data
05-22-2006 3:43 PM