Ask Your Question
0

How to convert specific sheet in xlsx file to csv file?

asked 2020-05-06 19:18:04 +0100

hanumant gravatar image

updated 2020-08-03 12:36:46 +0100

Alex Kemp gravatar image

Hi All,

I am using libreoffice5.2 --headless --convert-to csv --outdir outputdirectory input_xlsxfile to convert xlsx file to csv file.Here i am facing a issue, if i use mentioned command it is converting first sheet(tab) of xlsx file to csv. my targeted xlsx file has may tabs.do you have any clue how to convert targeted sheet(tab) of xlsx file into csv file. for example if i want to convert 3rd sheet(tab) of xlsx file to csv file how to do that.

-hanumant.

edit retag flag offensive close merge delete

1 Answer

Sort by » oldest newest most voted
0

answered 2020-05-06 19:39:28 +0100

erAck gravatar image

updated 2020-05-07 18:17:02 +0100

You can't from the command line. The command line conversion always converts the first sheet.

Update 2020-05-07T18:16+02:00

Probably this macro helps, specifically the For Each loop that imports files and saves each sheet to CSV. Adjust to your needs.

edit flag offensive delete link more

Comments

is there any other way in linux systems?

or can we form each sheet of xlsx file to another(separate) xlsx file with its sheet name?

hanumant gravatar imagehanumant ( 2020-05-07 06:32:38 +0100 )edit
Login/Signup to Answer

Question Tools

2 followers

Stats

Asked: 2020-05-06 19:18:04 +0100

Seen: 876 times

Last updated: May 07 '20