Skip to main content
kavyashreeh3453
Inspiring
Jun 30, 2023 7:54 AM UTC
Solved

Generate CSV from Excel

When CSV is generated from Excel, first row is being skipped. And a blank row is added at the end.

Any suggestions?

    sanchitg0002
    Inspiring
    Jun 30, 2023 8:59 AM UTC

    If you are using Convert Excel to CSV smart service available in Excel Tools plugin then for first row getting skipped, make sure that you are passing "0" for "Row Number To Read From" input parameter and for blank row at last, it might be due to the excel document you have provided.

    4 replies

    sanchitg0002
    Inspiring
    Jun 30, 2023 8:59 AM UTC

    If you are using Convert Excel to CSV smart service available in Excel Tools plugin then for first row getting skipped, make sure that you are passing "0" for "Row Number To Read From" input parameter and for blank row at last, it might be due to the excel document you have provided.

    kavyashreeh3453
    Inspiring
    Jun 30, 2023 9:16 AM UTC

    We have set 0 for starting row number. Still the issue persists.

    sanchitg0002
    Inspiring
    Jun 30, 2023 9:20 AM UTC

    It worked perfectly fine for me. Can you share the excel file here?