Python Open XML and Save to CSV

Question

I need to open an XML file and save it as a CSV. I am not interested in extracting contents (i.e. via lmtree). I just want Python to do what I would normally do (open the XML file in Excel and save as a CSV file).

I know this can work to open the XML file in Excel:

import subprocess
subprocess.Popen("%s %s" % (application_path, filepath))

...but I'm not sure where to go from here.

Thanks in advance!

Updates:

Here's a sample file (it's an XML Spreadsheet file, if that helps): https://drive.google.com/open?id=193ML_2r5i56cEhydm1wYFQtXJCgRA3r_
No need for Python to enable editing. I just had to read this:

https://www.thrivenetworks.com/blog/turn-off-enable-editing-office-2010/

If the XML file is a .xlsx check out this answer: stackoverflow.com/questions/20105118/… — Jonathon McMurray
– Jonathon McMurray, Commented Jan 24, 2018 at 21:06

Cullub · Accepted Answer · 2018-01-24 21:27:30Z

0

There's a library already built for this called xmlutils.

Run pip install xmlutils to install
xml2csv --input "samples/fruits.xml" --output "samples/fruits.csv" --tag "item" to convert to CSV

_{See this site or the documentation for more details.}

answered Jan 24, 2018 at 21:27

Cullub

3,3384 gold badges33 silver badges51 bronze badges

Sign up to request clarification or add additional context in comments.

4 Comments

Dance Party2 Over a year ago

Didn't work. I think the structure of the XML was is too complex.

Cullub Over a year ago

Hmm, that's too bad. Did it give you an error? And would you mind putting down the command you used specifically?

Cullub Over a year ago

Oh, also, this was built in Python 2.7 I believe -- are you using Python 3?

Dance Party2 Over a year ago

Yes, Sorry, I'll update the tags. I just substituted the XML and CSV file names with the path\names to my file and desired output. This was the error: AttributeError: 'IterParseIterator' object has no attribute 'next'

Dance Party2 · Accepted Answer · 2018-01-26 16:31:37Z

This worked for me:

pip install pyautogui

files=glob.glob(pathin+"*.xml")

def lazysave(inputs):
    print("%s" % (inputs))
        #subprocess.Popen("%s %s" % (path, file),shell=True)
    subprocess.Popen(inputs,shell=True)
    time.sleep(3)
    pag.FAILSAFE = True
    pag.keyDown('ctrlleft');pag.press('s');pag.keyUp('ctrlleft') #save file
    pag.PAUSE = 1
    pag.press('right') #go to "No - do not keep same format"
    #pag.PAUSE = .5
    pag.press('enter') #select "No - do not keep same format"
    #pag.PAUSE = 2
    pag.press('tab') #go to filetype dropdown menu
    #pag.PAUSE = 2
    pag.press('down') #activate filetype dropdown menu
    #pag.PAUSE = 2
    pag.press('down');pag.press('down') #go to CSV filetype
    #pag.PAUSE = .5
    pag.press('enter') #select CSV filetype
    #pag.PAUSE = .5
    pag.press('enter') #select "SAVE" button
    #pag.PAUSE = .5
    pag.press('enter') #select "Yes" button to keep CSV format
    #pag.PAUSE = .5
    pag.keyDown('altleft');pag.press('f4');pag.keyUp('alt') #close file
    pag.PAUSE = .5
    pag.press('right') #go to do not save (already saved)
    #pag.PAUSE = .5
    pag.press('enter') #select do not save (already saved)

for f in files:
     inputs=[path,f]
     lazysave(inputs)

Collectives™ on Stack Overflow

Python Open XML and Save to CSV

2 Answers 2

4 Comments

Comments

Your Answer

Linked

Hot Network Questions

Collectives™ on Stack Overflow

2 Answers 2

4 Comments

Comments

Your Answer

Sign up or log in

Post as a guest

Linked

Related