Network Details (Including networking gear model/manufacturer and if on WiFi/Ethernet)
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
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…