Convert a website to Html to Excel
I have the below as part of a web application(asp.net) is there any way to convert it to excel? The problem is p开发者_如何学JAVArinting 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....
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.
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.
精彩评论