Skip to Content

How to Handle CSV with multiple sheet in csv to xml converter

my scenario is csv via sftp to rest via http adapter, for conversion i have to add csv to xml converter or xml to json. but in my case only single csv file having multiple sheets and all sheets contains data and different headings, so how i can handle that in csv to xml converter as i have to add xsd of csv in converter and structure.

Add comment
10|10000 characters needed characters exceeded

  • Get RSS Feed

1 Answer

  • Aug 18, 2017 at 04:30 AM

    Hello Sidharth,

    If I am not wrong as per Standard CSV it cannot have multiple sheets. CSV can have only one sheet.

    Please confirm are you getting EXCEL file from 3rd party?

    Regards,

    Sriprasad Shivaram Bhat

    Add comment
    10|10000 characters needed characters exceeded