how to convert a html page to excel format ?

I tried to cut and paste and the format becomes disorganised. Moreover, when I copied the picture, it transferred into a cell. Is there any shareware or aid available that helps in this aspect. URGENT ....

You could try File - Open, and enter the URL in the filename box.
Depending on your version of Excel, it might work well enough.

- Jon
-------
Jon Peltier, Microsoft Excel MVP
Peltier Technical Services
Tutorials and Custom Solutions
http://PeltierTech.com/
_______


michaeltan wrote:

> I tried to cut and paste and the format becomes disorganised. Moreover,
> when I copied the picture, it transferred into a cell. Is there any
> shareware or aid available that helps in this aspect. URGENT ....
>
>
>

and for the picture did you want it or not.

If you want to get rid of the picture it is a shape and you
and delete shapes by their type or by the location of the
upper left corner as examples of what you might do.
http://www.mvps.org/dmcritchie/excel/shapes.htm

such as the macro on that page delShapesSel

disorganized is probably not a good description, but for the
moment will assume you will get what you want from Jon's reply.
--
HTH,
David McRitchie, Microsoft MVP - Excel [site changed Nov. 2001]
My Excel Pages: http://www.mvps.org/dmcritchie/excel/excel.htm
Search Page: http://www.mvps.org/dmcritchie/excel/search.htm

"Jon Peltier" <[email protected]> wrote in message news:[email protected]...
> You could try File - Open, and enter the URL in the filename box.
> Depending on your version of Excel, it might work well enough.
>
> - Jon
> -------
> Jon Peltier, Microsoft Excel MVP
> Peltier Technical Services
> Tutorials and Custom Solutions
> http://PeltierTech.com/
> _______
>
>
> michaeltan wrote:
>
> > I tried to cut and paste and the format becomes disorganised. Moreover,
> > when I copied the picture, it transferred into a cell. Is there any
> > shareware or aid available that helps in this aspect. URGENT ....
> >
> >
> >

No, I have not get the problem resolved. I certainly would appreciate if you can help to convert existing html to excel. http://147.202.45.242/~calscan/intra...int.php?LID=33

HI Michael,
Please explain messed up. I opened the file in Excel 2000 (file, open) as Jon
suggested and it it looks fine in Excel. In fact if you will notice in the
HTML there are rows that do not line up, yet Excel lined those rows
up -- like the stuff under "Packing Specifications" does not originally
line up with content to the left and I was very much surprised that
something that looks independently formatted would appear on
same rows.

You could make some changes like the following, you probably won't
like the results as far as readability goes because of the merged cells.

format, cells, alignment, vertical: top (Excel defaults to bottom)

select numeric cells -- Ctrl+A, Edit, go to (Ctr+G), Special, Constants + Numbers
then on the Excel toolbars click on the Centered format to unselect it.

select numeric cells -- Ctrl+A, Edit, go to (Ctr+G), Special, Constants + Text
then on the Excel toolbars click on the Centered format to unselect it.

Because of merged cells you find some of your numbers way far to the
right


HTH,
David McRitchie, Microsoft MVP - Excel [site changed Nov. 2001]
My Excel Pages: http://www.mvps.org/dmcritchie/excel/excel.htm
Search Page: http://www.mvps.org/dmcritchie/excel/search.htm

"michaeltan" <[email protected]> wrote in message
news:[email protected]...
>
> No, I have not get the problem resolved. I certainly would appreciate if
> you can help to convert existing html to excel.
> http://147.202.45.242/~calscan/intra...int.php?LID=33

After converting as per Jon's instruction, the column widths are all different, rows 2 to 10 are redundant while height of row 1 has to be increased. Pictures have to be re-sized.

This is almost a standard format that I would have to convert from html to excel (so as to facilitate changes to the data); and it would be very unproductive to do all these adjustments of widths and heights of cells and pictures. Can the html file be opened and placed on a "template" such that the adjustments are made once and for all ?

Thank you very much for your help !!!