[ad_1]
I’m trying to write some code that would read a google spreadsheet and write to an XML file. Initially, I made an XML file template and would modify it based on which field within the google spreadsheet I was on.
SITE_REM_ID DOC_TITLE DOC_TYPE DATE (YYYYMMDD) PAGES file name
an example for each field:
SR-18-0068 (SITE_REM_ID) Laboratory Report & Summary of Surface Water Analysis Results Report (DOC_TYPE) 2010.05.01 (DATE) 37 (PAGES) SR-18-0068 – 2010.05.01 – Laboratory Report & Summary of Surface Water Analysis Results (file name)
Where row[5] is the file name, would create an XML file titled with that name. The file name itself is a string (acts as a title); however, I think it reads them absolutely fine since it doesn’t have any backslashes. However, when I reaches a “filename” with a backslash, I get “FileNotFoundError: [Errno 2] No such file or directory”. So for example, I would get an error for this: SR-18-0068 – 2006.03.21 – Laboratory Report & Summary of Surface Water/Compliance Well Analysis Results.
My code:
tree = et.parse('/Users/jarraomar/Desktop/work/Code for Reading and Writing Google Spreadsheets/Template.mods.xml')
I placed the absolute path of the file ^
tree.write(str(row[5]) + ".xml", encoding="utf-8")
I’ve also tried to use the rawstring instead:
tree = et.parse(r’C:/Users/jarraomar/Desktop/work/Code for Reading and Writing Google Spreadsheets/Template.mods.xml’)
tree.write(str(row[5]) + ".xml", encoding="utf-8")
But instead I get “OSError: Error reading file ‘C:/Users/jarraomar/Desktop/work/Code for Reading and Writing Google Spreadsheets/Template.mods.xml’: failed to load external entity “C:/Users/jarraomar/Desktop/work/Code for Reading and Writing Google Spreadsheets/Template.mods.xml””
Upon removing the backslashes it’s able to read and write XML files titled from the google spreadsheet but I would like to keep them there. Also, I looked at similar questions but it didn’t seem to work either, any suggestions?
[ad_2]