Network Details (Including networking gear model/manufacturer and if on WiFi/Ethernet)
Not applicable.
Description Of Issue
Export albums to Excel is not quite right. Document format appears to be off. When opened with numbers, Numbers thoughtfully puts the XML text into spreadsheet text cells rather than interpreting the XML document as a spreadsheet.
The MacOS file command reports that the file is …
$ (base) trey:Desktop davey$ file LibraryAlbums-637105299654588100.xls
LibraryAlbums-637105299654588100.xls: XML 1.0 document text, UTF-8 Unicode text
(base) trey:Desktop davey
The file is created with the .xml type which, by convention, indicates the old binary format. The file actually contains the new XML format which has a different extension.
Creating a simple sheet using Numbers and exporting to .xlsx gives an example. File command reports
Only Excel is opening the file. Google Docs also failed. I’ve not tried OpenOffice.
That sucks for the rest of the world. Recommend switching to XSLX using XSD schema and validating your results.
There should be a class library for this in mono but I don’t know enough about the library organization to run it down. Can find several mono examples out there of writing a workbook from a mono app.
This may help your developers. If they use Visual Studio Code, they can select plugins, then XSD, and VS Code will find a plugin, “XmlComplete” that will do partial validation. There are pretty clean tools for JSON to XSLX and CSV to XSLX. CSV is probably a sufficient option. Anybody wanting a workbook can take that option in their spreadsheet import. XmlComplete is selfcontained.
I’ve done this a lot in Python but not Mono. In Python pretty well to bring a collection of tuples out as a a collection of CSV lines. Python has a nice class for reading and writing CSV…