[2 days left] What’s wrong with your cloud strategy? Learn why multicloud solutions matter with Nimble Storage.Register Now

x
?
Solved

Paste HTML into Excel INCLUDING COLUMN WIDTHS

Posted on 2011-03-03
3
Medium Priority
?
279 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
[X]
Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people just like you are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
  • 2
3 Comments
 
LVL 30

Accepted Solution

by:
SiddharthRout earned 1000 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

Hire Technology Freelancers with Gigs

Work with freelancers specializing in everything from database administration to programming, who have proven themselves as experts in their field. Hire the best, collaborate easily, pay securely, and get projects done right.

Question has a verified solution.

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

Some code to ensure data integrity when using macros within Excel. Also included code that helps secure your data within an Excel workbook.
How to get Spreadsheet Compare 2016 working with the 64 bit version of Office 2016
The viewer will learn how to use the =DISCRINV command to create a discrete random variable, use this command to model a set of probabilities and outcomes in a Monte Carlo simulation, and learn how to find the standard deviation of a set of probabil…
The viewer will learn how to create a normally distributed random variable in Excel, use a normal distribution to simulate the return on an investment over a period of years, Create a Monte Carlo simulation using a normal random variable, and calcul…

649 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