2

Is there there an open source command line tool that will convert xls/xlsx to xml? Ideally I'd like to do this on an *NIX system.

Lance Roberts
  • 22,383
  • 32
  • 112
  • 130
Cyrus
  • 3,687
  • 5
  • 35
  • 67

2 Answers2

2

XLSX is easy, the format is a zip file. Within the zip there's a "worksheets" folder in "xl" that has an xml file for the data in each sheet. If you unzip you can access the xml directly.

XLS I'm not sure.

Jesse

Jesse
  • 1,937
  • 3
  • 19
  • 28
0

happened to be using ruby to automate some excel operations, including save as xml.

but this requires win32OLE and will not be on *nix.

Jokester
  • 5,501
  • 3
  • 31
  • 39