1

I need to know if we can read an excel file through DOS command prompt and display the output in CSV format. Easiest possible way appreciated. Thanks.

vibha
  • 11
  • 1
  • 1
    What's stopping you from using Excel to save the file as csv? – Bathsheba Feb 12 '16 at 13:16
  • 2
    Via the command line? http://stackoverflow.com/questions/1858195/convert-xls-to-csv-on-command-line – Trenin Feb 12 '16 at 13:21
  • 1
    Use Python (Excel not needed). – durasm Feb 12 '16 at 13:41
  • @durasm Does python have an excel library? Or are you suggesting parsing the excel formatted document and outputting CSV? Would you handle all types of Excel documents? – Trenin Feb 12 '16 at 16:05
  • @Trenin There is 'xlrd' module which reads both, xls and xlsx formats. – durasm Feb 12 '16 at 17:15
  • I actually want to read the contents of the file from a tool. the tool will run command from DOS to read it. I hope this explains – vibha Feb 15 '16 at 09:31

1 Answers1

0

Not completely relevant, but, in java, you can use Apache POI

vijayinani
  • 2,548
  • 2
  • 26
  • 48