Excel to Database Converter_____ A python script that converts an Excel XML spreadsheet into an sqlite database copying the rows and columns into the database just the way they are in the Excel file.
It looks like that FredAPI is using getchildren () method, which is no longer supported by Python >3.9. This method was used in the xml.etree.ElementTree library but has been deprecated.
I'm trying to run Xpath queries using etree, but I can't seem to figure out the Xpath syntax. Here's a (sanitized) section of my XML document. 1) Query using XML based on some value like the 'id' or ...