• Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 282
  • Last Modified:

Paste HTML into Excel INCLUDING COLUMN WIDTHS

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?  
0
rberke
Asked:
rberke
  • 2
1 Solution
 
SiddharthRoutCommented:
Unfortunately there is no inbuilt method to do that or maybe I am not aware of it. I will share what I usually do. After pasting, I select all the cell in the worksheet and then I expand any one of the columns. This expands the columns for the rest as well. I repeat the same with rows. Once done I simply double click between the column headers or Row headers and Excel automatically auto fits them for me. If anything is still left, then I manually do it.

Sid
0
 
rberkeAuthor Commented:
And I will share what I usually do:  After pasting html to Excel, I select the entire sheet and turn text wrapping off and autosize all rows.  

I then go back to the source website, and use Snagit (or similar screenshot software) to cut a picture of the webpage the way it really looks.  

I return to excel and paste that picture onto the spreadsheet and resize picture to be about the "right" size.

I then start on the leftmost column and drag it to match the picture's first column. I then drag the second column to match etc.

I then "eyeball" the spread sheet and turn wrapping back on to whichever columns seem to need it.

Quite a pain the you-know-what.

rberke
0
 
rberkeAuthor Commented:
The portion of the solution that is "complete" is the portion that says there is no builit in tricks, other than the tricks we all have already been using.

So I am closing the question to keep it from laying around.
0

Featured Post

Concerto's Cloud Advisory Services

Want to avoid the missteps to gaining all the benefits of the cloud? Learn more about the different assessment options from our Cloud Advisory team.

  • 2
Tackle projects and never again get stuck behind a technical roadblock.
Join Now