ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Discussion (Misc queries) (https://www.excelbanter.com/excel-discussion-misc-queries/)
-   -   Importing html documents into Excel adds rows to the body. (https://www.excelbanter.com/excel-discussion-misc-queries/227530-importing-html-documents-into-excel-adds-rows-body.html)

Dave Murdock

Importing html documents into Excel adds rows to the body.
 
I am creating sales confirmation documents in html. There are three sections
to each document (Header, Body, Footer). If you open the html document in a
browser, all is displayed properly. If you open it into Excel, the importing
process doubles the number of rows in the body portion of the document. I
have an example. Is there any way to prevent this and open it so that it
looks like the html version with only one line for each entry in the body?
--
Dave

Sheeloo[_5_]

Importing html documents into Excel adds rows to the body.
 
No.

You can however open the HTML in a browser and then copy and paste into Excel.


--
Pl click the YES button
(if you see it - don''''''''t worry if you don''t),
if this answer was helpful.



"Dave Murdock" wrote:

I am creating sales confirmation documents in html. There are three sections
to each document (Header, Body, Footer). If you open the html document in a
browser, all is displayed properly. If you open it into Excel, the importing
process doubles the number of rows in the body portion of the document. I
have an example. Is there any way to prevent this and open it so that it
looks like the html version with only one line for each entry in the body?
--
Dave



All times are GMT +1. The time now is 02:41 PM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com