Thread: Select particular column

Hi,

I am working on batch conversion of XLS to CSV files.

Ex: There are 100 excel files in Root Folder.
From file "xyz.xls" I would like to select particular ColumnA, ColumnM, and Column Z
and from other file "abc.xls" I would like to select ColumnB, ColumnG
and I would be even looking for transpose (Row Column exchange data\values)
so on from other multiple files and then convert the selection into CSV file.

Basically from couple of files I am looking for particular file and then either convert it to XLS or CSV file.

Please guide me in the above matter.

Appreicate your response