Convert a website to Html to Excel

Question

I have the below as part of a web application(asp.net) is there any way to convert it to excel? The problem is printing it. Landscape is the desired format and persons in the organization are very novice so to improve usability i want to allow it to be in landscape. I tried activex and sendkeys commands. This works but not what i desire..

Please help....

Budget Application

This wont work because its formatted with css and more than one tables. — Amarnauth Persaud, May 13 '11 at 14:05
Have you tried? Also, you copy mutiple tables one by one and paste them into separate places on the worksheet. — Seva Alekseyev, May 13 '11 at 14:16

score 2 · Answer 1 · answered May 06 '11 at 21:04

2

Two ideas:

(1) Copy + paste. If there is too much noise then try (2).

(2) Copy the HTML into a text file, read the text file into a program, have the program parse the HTML in the way that you need it. From there you should be able to format it as needed or just flat out copy/paste it into Excel.

answered May 06 '11 at 21:04

Christopher Logel

123
7

@Amarnauth Persaud - thousands if not millions of people scrape websites for data every day. This looks easy to parse into excel from a website using simple querytables/regex/split string etc. It seems you have control over the content so why not allow export to excel as part of your app or redesign the webpage? – May 06 '11 at 23:40

score 2 · Answer 2 · edited May 23 '17 at 12:09

2

Are your pages table-driven (<table><tr>...) and not laid out with CSS? If so, this has been asked and answered before. Excel can consume tabular HTML like a champ.

edited May 23 '17 at 12:09

Community

1
1

answered May 06 '11 at 21:09

48klocs

6,073
3
27
34

It is both tables and standard divs. most are tables...i will try it out.. thank... – Amarnauth Persaud May 06 '11 at 21:47

Convert a website to Html to Excel

2 Answers2