Skip to Content
author's profile photo Former Member
Former Member

Upload xlsx file with multi worksheet into web dynpro abap

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.

Add a comment
10|10000 characters needed characters exceeded

Related questions

3 Answers

  • author's profile photo Former Member
    Former Member
    Posted on Sep 10, 2013 at 07:09 AM
    Add a comment
    10|10000 characters needed characters exceeded

  • author's profile photo Former Member
    Former Member
    Posted on Sep 10, 2013 at 08:47 AM

    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+ABAP

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

    Waiting for your reply!

    Best Regards,

    NKC

    Add a comment
    10|10000 characters needed characters exceeded

  • Posted on Sep 10, 2013 at 10:03 AM

    hi Sunil ,

    try by the link below

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

    Regards,

    Ankita

    Add a comment
    10|10000 characters needed characters exceeded

Before answering

You should only submit an answer when you are proposing a solution to the poster's problem. If you want the poster to clarify the question or provide more information, please leave a comment instead, requesting additional details. When answering, please include specifics, such as step-by-step instructions, context for the solution, and links to useful resources. Also, please make sure that you answer complies with our Rules of Engagement.
You must be Logged in to submit an answer.

Up to 10 attachments (including images) can be used with a maximum of 1.0 MB each and 10.5 MB total.