Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Posted to microsoft.public.excel.misc
external usenet poster
 
Posts: 1
Default 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
  #2   Report Post  
Posted to microsoft.public.excel.misc
external usenet poster
 
Posts: 248
Default 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

Reply
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
Importing Multiple Word Documents into excel Matt Bennette[_2_] Excel Discussion (Misc queries) 0 January 6th 09 04:43 PM
Importing HTML table to Excel - Can it bring in formula? jleavens Excel Discussion (Misc queries) 1 May 18th 07 03:26 PM
importing and exporting documents using word/excel Denise Camara Excel Discussion (Misc queries) 0 July 7th 06 07:31 PM
Importing HTML data into excel Mike Excel Discussion (Misc queries) 0 February 1st 06 02:51 AM
Literally displaying imported cells with and tags [email protected] Excel Discussion (Misc queries) 3 January 13th 05 11:54 PM


All times are GMT +1. The time now is 12:25 PM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
Copyright ©2004-2025 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"