Read MS Excel XML file to pandas dataframe?

Question

I have an MS Excel XML (2003) file with the following metadata:

<?xml version="1.0" encoding="UTF-8"?>
<?mso-application progid="Excel.Sheet"?><Workbook xmlns="urn:schemas-microsoft-com:office:spreadsheet" 
xmlns:c="urn:schemas-microsoft-com:office:component:spreadsheet" xmlns:html="http://www.w3.org/TR/REC-html40" xmlns:o="urn:schemas-microsoft-com:office:office" xmlns:ss="urn:schemas-microsoft-com:office:spreadsheet" 
xmlns:x2="http://schemas.microsoft.com/office/excel/2003/xml" 
xmlns:x="urn:schemas-microsoft-com:office:excel" 
xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance"><OfficeDocumentSettings xmlns="urn:schemas-microsoft-com:office:office">

I'd like to read it into a pandas dataframe. What's a good way to go about doing this? Thanks.

Does it have to be in XML format? If not then you can read it in using read_excel. — Phillip Cloud
– Phillip Cloud, Commented Aug 14, 2013 at 18:33

dgg32 · Accepted Answer · 2014-09-01 21:43:38Z

1

Did you try Canopy python's pyxll, it is advertised as "Python for Excel Solution"

Check it out please and see if it solves your problem.

answered Sep 1, 2014 at 21:43

dgg32

1,4771 gold badge16 silver badges34 bronze badges

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

Collectives™ on Stack Overflow

Read MS Excel XML file to pandas dataframe?

1 Answer 1

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

Comments

Your Answer

Sign up or log in

Post as a guest

Related