Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
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
Posted to microsoft.public.excel.programming
|
|||
|
|||
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 |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Excel 2003. Custom format gets replaced by Special format. | New Users to Excel | |||
Convert Excel 2007 format (*.xlsx) into Excel 2003 format | Excel Discussion (Misc queries) | |||
How to covert picture excel format to editable excel format | Excel Discussion (Misc queries) | |||
How can I convert a date format to an ISO week format (in EXCEL)? | Excel Discussion (Misc queries) | |||
how to format excel format to text format with separator "|" in s. | New Users to Excel |