Solved

Paste HTML into Excel INCLUDING COLUMN WIDTHS

Posted on 2011-03-03
3
266 Views
Last Modified: 2012-05-11
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
Comment
Question by:rberke
  • 2
3 Comments
 
LVL 30

Accepted Solution

by:
SiddharthRout earned 250 total points
ID: 35032199
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
 
LVL 5

Author Comment

by:rberke
ID: 35032791
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
 
LVL 5

Author Closing Comment

by:rberke
ID: 35116781
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

Netscaler Common Configuration How To guides

If you use NetScaler you will want to see these guides. The NetScaler How To Guides show administrators how to get NetScaler up and configured by providing instructions for common scenarios and some not so common ones.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Suggested Solutions

INDEX and MATCH can be used to great effect to replace HLOOKUP and VLOOKUP as it does not have the limitation of needing the data to be sorted so that the reference value is in the first column or row. It also has the ability to perform a bi-directi…
Introduction While answering a recent question (http:/Q_27311462.html), I created an alternative function to the Excel Concatenate() function that you might find useful.  I tested several solutions and share the results in this article as well as t…
This Micro Tutorial demonstrate the bugs in Microsoft Excel for Mac with Pivot Charts.
Many functions in Excel can make decisions. The most simple of these is the IF function: it returns a value depending on whether a condition you describe is true or false. Once you get the hang of using the IF function, you will find it easier to us…

831 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question