Read and write multiple sheets of xl placed on al11(application server)

[Former Member]

Hi Team,

There are two requirements.

1.  Transfer the data in an excel with multiple sheets into application server(al11) .

ex: 

excel name - multisheet_excel containing two sheets, sheet1 &2.

sheet1         - contains itab1 data

sheet2         - contains iteb2 data.

2. Read existing multisheet excel file from application server tcode al11

and edit certain cells in a required sheet and place the file back.

I've gone through various threads but couldn't find the solution. Can someone help with a sample example pls.

Thanks in advance

Regards,

Sonam

[Former Member]

Hi Sonam,

Try this..hope it serves your scenario.

http://wiki.scn.sap.com/wiki/display/Snippets/Read+multiple+sheets+of+an+Excel+file+into+SAP+through...

Regards

Raj

[Former Member]

Thanks Raj

it works very well in spliting the sheet into internal table .

but i need to read the file from transction AL11 , and want to edit the file and put back to the same place.

please help in this

regards

sonam

[Former Member]

Hi

Class CL_BDS_DOCUMENT_SET. You can explore this class to figure out how to use it.

Also, you can refer this wiki

http://wiki.scn.sap.com/wiki/display/ABAP/Excel+with+SAP+-+An+overview

http://help.sap.com/saphelp_nw70/helpdata/EN/e9/0be775408e11d1893b0000e8323c4f/content.htm?current_t...   

Section :  Exchanging Data between SAP and Desktop Application and Spreadsheet Interface in the above link.

Regards

Raj

[Former Member]

Thanks Raj

i have gone through the links but cudnt find anything .

i want to read multisheet xlsx file from application server al11 .

please help

regards

sonam

[Former Member]

Hi

The following might help you.

abap2xlsx - ABAP Development - SCN Wiki

Regards

Raj

[former_member686070]

Hi Sonam,

I have exact requirement.

I am stuck at update the multiple sheets and then uploading back in AL11.

Could you please help.

Vivek

[matt]

Try reading the answers to this question... or do you need it all repeated just for you?