I want to use an XML file to facilitate data imports into an Oracle APEX application. The primary reason why I want to use XML is that some of the fields in the Excel spreadsheet could contain many commas which would plague a Comma-separated-value import. I was able to write a Python script using the xlrd and lxml libraries however this only works well if the scripts exist in a central location (server).
I was able to create an XML spreadsheet that could be used to convert Excel spreadsheets into an XML data file that could be used to import data into Oracle APEX. Unfortunately, I discovered that Microsoft Excel on the Macintosh does not appear to be able to export data as XML.
Is there any way that I can export the Excel data as an XML data file on the Macintosh?