Can I use Python to connect to an XML, and then based on the data and certain rules, create a spreadsheet similar to OpenOffice calc ? Or it doesn't have to specifically be a spreadsheet, but simply a GUI output containing the resultant data. The data in XML format is from a KMyMoney database. Can also export to an SQL format.
Have found a few basic guides, at https://www.pythonforbeginners.com/basic...-in-python and https://www.geeksforgeeks.org/reading-an...in-python/ , so obviously possible. The XML file is 10 Mb; I assume all of the file is read into memory. I only need to open it for read purposes.
As there is other data besides the KMyMoney , which needs to be modified from time to time, not sure if the XML format will do. That said, it is possible to merge two XML files together with Python - https://pypi.org/project/xmlmerge/
Have found a few basic guides, at https://www.pythonforbeginners.com/basic...-in-python and https://www.geeksforgeeks.org/reading-an...in-python/ , so obviously possible. The XML file is 10 Mb; I assume all of the file is read into memory. I only need to open it for read purposes.
As there is other data besides the KMyMoney , which needs to be modified from time to time, not sure if the XML format will do. That said, it is possible to merge two XML files together with Python - https://pypi.org/project/xmlmerge/