Link to home
Start Free TrialLog in
Avatar of Scott Lamond
Scott LamondFlag for United States of America

asked on

Capturing a Webpage As Text and Importing Into Excel.

Using Windows Task Scheduler and a series of batch files that download reports (as CSV files) I'm able to automate the hourly updating of macro-enabled Excel files that auto-publish their reports as HTM files to a webserver. But I've hit a brickwall since one of the webpages from which I need data is only presented as a webpage (no downloadable report available). I see the obvious solution as capturing the page as text (manually I'd do it using <Ctrl>+<A>, <Ctrl>+<C> and pasting the text into Excel for manipulation). But I'm not familiar with how to accomplish this automatically, in Excel or otherwise.
Avatar of David Favor
David Favor
Flag of United States of America image

This process tends to be far more complex than you might think.

https://www.experts-exchange.com/questions/29075321/how-to-store-some-selected-text-from-a-webpage-to-a-string-in-java.html - take a read through my comments about this process as a good starting point.
ASKER CERTIFIED SOLUTION
Avatar of Scott Lamond
Scott Lamond
Flag of United States of America image

Link to home
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Start Free Trial
Avatar of Scott Lamond

ASKER

It works.