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?