Paste HTML into Excel INCLUDING COLUMN WIDTHS
Posted on 2011-03-03
I have set this at 250 point because it is not too important to me, and because I don't have much time to devote to the problem. But, if somebody has an easy solution that does a good job I will bump points to 500.
When pasting HTML into a spreadsheet, Excel does a pretty good job of honoring HTML formatting.
The big exception is column widths which Excel simply ignores.
In a certain way, this makes sense because internet browsers also tend to "ignore" column width. When HTML is rendered on a high resolution display, it will look totally different than when it is squeezed into a low resolution display. Luckily, I hardly ever care what the pasted data looks like, but sometimes I spend a fair amout of time adjusting column widths manually to make things look better.
Does anybody have any nifty tricks that will do this more or less automatically?