|
On 7/14/05, Marvin Radding <MRadding@xxxxxxxxxxxx> wrote: > > This might be part of your problem. I think Excel will understand html in > a file with the extension .htm. If the extension is .xls it might assume > that it is properly formatted as an excel file. Try just changing the > extension and then reading it into Excel as an import. > > Marvin I have used the method of creating HTML, naming it with the .xls extension, and opening it up in excel extensively, with MS Office 2000, XP, and 2003, and I can tell you with 100% certainty, this is not a problem. Excel sees the HTML, and renders it as an Excel worksheet. You can even have table cells with formulas embedded, and Excel will calculate the formulas, as if you had typed them in. Before I tried it, I thought the same thing though ;-)
As an Amazon Associate we earn from qualifying purchases.
This mailing list archive is Copyright 1997-2024 by midrange.com and David Gibbs as a compilation work. Use of the archive is restricted to research of a business or technical nature. Any other uses are prohibited. Full details are available on our policy page. If you have questions about this, please contact [javascript protected email address].
Operating expenses for this site are earned using the Amazon Associate program and Google Adsense.
midrange.com
