locked
Load Multiple Excel files with multiple sheets into single csv files RRS feed

  • Question

  • Hi,

    I have 10 excel files and each excel file contains 10 excel sheets. All the excel sheets from all the excel files have the same header file. I need to convert them all into 10 csv files.

    Ex - 

    1.xls   - Sheets - a,b,c

    2.xls    - Sheets - a,b,c

    .

    .

    10.xls  - Sheets - a,b,c

    Output    - 

    a.csv

    b.csv

    c.csv

    a.csv contains data from "a" worksheet from all the excel files.

    Appreciate help, if someone can guide me.

    Thanks in advance.

    Tuesday, April 7, 2015 2:02 PM

Answers

All replies