Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Posted to microsoft.public.excel.programming
external usenet poster
 
Posts: 1
Default Web to Excel, the format run out

What im doing is, I got a html page that got a table
Date Item Price
03-04-2005 XXX 12.50
03-08-2005 XXX 35.50
30-06-2005 XXX 20.50
28-07-2005 XXX 50.00

then I wan to export this to excel when I click my export button
*I wan to remain the style setting(That is why cannot export as .cvs)

Then I create an excel object in my script and open it with the html
text

Yes, the excel come out seem like exactly same as my web page(I mean
the style)
By, when I look carefully, the datatype change as below

03/04/2005 XXX 12.5
03/08/2005 XXX 35.5
30-06-2005 XXX 20.5
28-07-2005 XXX 50

It seem like auto format the cell

What should I do to the keep my data exactly the same as the table in
my web?

  #2   Report Post  
Posted to microsoft.public.excel.programming
external usenet poster
 
Posts: 1,588
Default Web to Excel, the format run out

http://groups-beta.google.com/group/...ce9b10f9e99c9e

Tim

--
Tim Williams
Palo Alto, CA


wrote in message
oups.com...
What im doing is, I got a html page that got a table
Date Item Price
03-04-2005 XXX 12.50
03-08-2005 XXX 35.50
30-06-2005 XXX 20.50
28-07-2005 XXX 50.00

then I wan to export this to excel when I click my export button
*I wan to remain the style setting(That is why cannot export as .cvs)

Then I create an excel object in my script and open it with the html
text

Yes, the excel come out seem like exactly same as my web page(I mean
the style)
By, when I look carefully, the datatype change as below

03/04/2005 XXX 12.5
03/08/2005 XXX 35.5
30-06-2005 XXX 20.5
28-07-2005 XXX 50

It seem like auto format the cell

What should I do to the keep my data exactly the same as the table in
my web?



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
Excel 2003. Custom format gets replaced by Special format. jasper New Users to Excel 0 September 1st 08 03:46 AM
Convert Excel 2007 format (*.xlsx) into Excel 2003 format JD Moss Excel Discussion (Misc queries) 2 September 27th 07 06:46 PM
How to covert picture excel format to editable excel format SANJUZ Excel Discussion (Misc queries) 1 January 8th 06 09:27 PM
How can I convert a date format to an ISO week format (in EXCEL)? ELI Excel Discussion (Misc queries) 2 July 6th 05 06:31 PM
how to format excel format to text format with separator "|" in s. azlan New Users to Excel 1 January 31st 05 12:57 PM


All times are GMT +1. The time now is 06:09 AM.

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

About Us

"It's about Microsoft Excel"