Upload xlsx file with multi worksheet into web dynpro abap

[Former Member]

hi folks,

i am uploading xlsx file having 5 worksheet into web dynpro abap using class zcl_excel_reader_2007. but when i try to take the contents of worksheet 3 by setting it as active worksheet, then i don't get correct data of worksheet 3; some of it's cells shows value from other worksheet too. how to get it resolve?? my excel it macro-enabled. but when i tried it with .xls even then faced same problem. i tried to take help from project abap2xlsx as well but didn't get resolve. does abap2xlsx project having any new version which can resolve this issue??

regards,

sunil.

[former_member221367]

hi Sunil ,

try by the  link below

http://scn.sap.com/docs/DOC-45719

Regards,

Ankita

[Former Member]

Hi Sunil,

Can you provide us the code that you are writinig in the Method to read the contents of the worksheet from Xcel sheet?

How ever for reference you can go through the wiki below :

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

You can try with the above code.
Kindly let us know if you still have this issue!

Waiting for your reply!

Best Regards,

NKC

[Former Member]

hi NKC,

thanks for your reply and assistence..but i m doing above in web dynpro abap.

regards,

sunil.

[Former Member]

Hi,

Please refer to below links,

http://scn.sap.com/message/7403952

http://sap.ittoolbox.com/groups/technical-functional/sap-dev/ole-and-abap-open-with-two-worksheets-a...

Hope this helps you.

Best Regards,

Abirami