2

I would like to know how I would have a python web scrape dump all of it's results into excel. It's not that I don't know how to webscrape, it's just I do not know how to scrape into excel.

Improve this question
3
  • 1
    Check this other thread Commented Apr 21, 2012 at 0:48
  • 1
    writemycode.net - give us something to comment on please Commented Apr 21, 2012 at 0:49
  • I've developed a product that uses JavaScript rather than Python but sounds like what you need. It creates Excel so you can have multiple sheets. The demo and example projects that should provide an good start with it. Script Scraper thanks, Martin Commented May 15, 2012 at 21:25

2 Answers 2

Reset to default
2

You say you know how to web-scrape, presumably into memory.

Then you just need to dump the contents into Excel. Use an Excel Python API .

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

1 Comment

It has been a while since the question you quoted and I have learned since then. Thanks for the link.
2

if you don't want to introduce a full excel library, you can write an HTML table or CSV and Excel will happily import those. The downside with this is that you're limited to one worksheet and no formulaes.

Improve this answer

Comments

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service and acknowledge you have read our privacy policy.

Start asking to get answers

Find the answer to your question by asking.

Ask question

Explore related questions

See similar questions with these tags.