How do I save an XML file from a URL and convert XML to XSLX using Python?

Question

I need a python code to read XML file from this URL (https://www.treasury.gov/ofac/downloads/consolidated/consolidated.xml). And convert this XML to XLSX file. So, this will be an automated code. Whenever i run this it will directly read from URL and it should save as XLSX. So that i will save in database on regular basis.

This link(https://cdkm.com/xml-to-xls) is actually reading XML from URL and converting to XLSX(In which format i need). But this is manual work. we need automated one, so that we can run the code regularly.

I have tried different methods, like convert XML to JSON to XLSX still not working. The main problem is that there are many columns which have same names. So, the conversion of XML to XLSX is not coming properly. Can any one please help me out solving this. Thanks in advance.

"I have tried different methods, but the main problem is that..." - Please show us your code. Provide a minimal reproducible example, — mzjn
– mzjn, Commented Apr 25, 2022 at 8:09
stackoverflow.com/questions/45239059/… - I have tried first answer code. It did not worked for me. — bura jyothi
– bura jyothi, Commented Apr 25, 2022 at 8:40

Luca Rizzo · Accepted Answer · 2022-04-25 07:51:07Z

0

If with some filters and patterns on a python loop doesn't work, you can try creating a .NET bot, to combine your link (https://cdkm.com/xml-to-xls) with a web browser form.

It exists some software to create bot on web browser form. Sorry, I couldn't help you more. But I hope it will help you, to find a good way to solve this task.

answered Apr 25, 2022 at 7:51

Luca Rizzo

11 bronze badge

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

Collectives™ on Stack Overflow

How do I save an XML file from a URL and convert XML to XSLX using Python?

1 Answer 1

Comments

Your Answer

Linked

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

Comments

Your Answer

Sign up or log in

Post as a guest

Linked

Related