Hi Jeremy,

Did you restrieve the dataset from a webservice?
Here is a link, you may have a look to see if it is what do you want to do.
http://msdn.microsoft.com/library/de...us/dnofftalk/h
tml/office12092002.asp
Did I misunderstand your meaning?
If so, please post some code for me to reproduce the problem?

Regards,
Peter Huang
Microsoft Online Partner Support
Get Secure! www.microsoft.com/security
This posting is provided "as is" with no warranties and confers no rights.

--------------------
Content-Class: urn:content-classes:message
From: "Jeremy Holt"
Sender: "Jeremy Holt"
Subject: Date formatting XML datasets in Excel 2003
Date: Fri, 19 Sep 2003 11:41:58 -0700
Lines: 21
Message-ID:
MIME-Version: 1.0
Content-Type: text/plain;
charset="iso-8859-1"
Content-Transfer-Encoding: 7bit
X-Newsreader: Microsoft CDO for Windows 2000
Thread-Index: AcN+3bUusmYvRrsUSPqxrhfx6oQdtA==
X-MimeOLE: Produced By Microsoft MimeOLE V5.50.4910.0300
Newsgroups: microsoft.public.excel.programming
Path: cpmsftngxa06.phx.gbl
Xref: cpmsftngxa06.phx.gbl microsoft.public.excel.programming:417461
NNTP-Posting-Host: TK2MSFTNGXA12 10.40.1.164
X-Tomcat-NG: microsoft.public.excel.programming

I've just downloaded Office Excel 2003

While messing around with the XML import functions, I've
noticed that Excel does not naturally format a date from
an ADO.Net dataset, i.e.

2003-08-24T00:00:00.0000000-03:00

I would have thought that it should be able to do this.
While I could easily write a parser to strip the date and
time from this date, I would much rather not have to
include a new column in the spreadsheet to do this.

Another thing I think should be automatically formattable
is a tick/cross for TRUE/FALSE values.

Any thoughts?
Jeremy

Hi Jeremy,

I think you may need to convert the date format your self.
Here is a sample which will ConvertISO8601DateFormatToVBDateTime.
You may download it at the link below.
http://msdn.microsoft.com/library/de...us/dnofftalk/h
tml/office08012002.asp


Regards,
Peter Huang
Microsoft Online Partner Support
Get Secure! www.microsoft.com/security
This posting is provided "as is" with no warranties and confers no rights.

--------------------
From: "Jeremy Holt"
References:

Subject: Date formatting XML datasets in Excel 2003
Date: Mon, 22 Sep 2003 11:06:34 -0300
Lines: 173
X-Priority: 3
X-MSMail-Priority: Normal
X-Newsreader: Microsoft Outlook Express 6.00.2800.1158
X-MimeOLE: Produced By Microsoft MimeOLE V6.00.2800.1165
Message-ID:
Newsgroups: microsoft.public.excel.programming
NNTP-Posting-Host: ce130110.user.veloxzone.com.br 200.164.130.110
Path: cpmsftngxa06.phx.gbl!TK2MSFTNGP08.phx.gbl!tk2msftn gp13.phx.gbl
Xref: cpmsftngxa06.phx.gbl microsoft.public.excel.programming:417976
X-Tomcat-NG: microsoft.public.excel.programming

Hi Peter

No its a dataset created in the VB Studio 2003 DataSet designer.

The dataset is saved to the local disk with the generated schema, i.e.

dim da as new sqlDataAdapter
dim ds as new dsFinancials
da.fill(ds)
ds.writexml("myData.xml,XmlWriteMode.WriteSchem a)

I attach an example XML File with schema, and the Excel spreadsheet.

I'll look at the link later in the day.

All I'm doing is dragging the XML file onto Excel and then dragging the
"table" from the XML pane into the spreadsheet - which works great for
everything but these dates.

Regards
Jeremy Holt

"Peter Huang [MSFT]" wrote in message
...
Hi Jeremy,

Did you restrieve the dataset from a webservice?
Here is a link, you may have a look to see if it is what do you want to
do.

http://msdn.microsoft.com/library/de...-us/dnofftalk/
h
tml/office12092002.asp
Did I misunderstand your meaning?
If so, please post some code for me to reproduce the problem?

Regards,
Peter Huang
Microsoft Online Partner Support
Get Secure! www.microsoft.com/security
This posting is provided "as is" with no warranties and confers no
rights.

--------------------
Content-Class: urn:content-classes:message
From: "Jeremy Holt"
Sender: "Jeremy Holt"
Subject: Date formatting XML datasets in Excel 2003
Date: Fri, 19 Sep 2003 11:41:58 -0700
Lines: 21
Message-ID:
MIME-Version: 1.0
Content-Type: text/plain;
charset="iso-8859-1"
Content-Transfer-Encoding: 7bit
X-Newsreader: Microsoft CDO for Windows 2000
Thread-Index: AcN+3bUusmYvRrsUSPqxrhfx6oQdtA==
X-MimeOLE: Produced By Microsoft MimeOLE V5.50.4910.0300
Newsgroups: microsoft.public.excel.programming
Path: cpmsftngxa06.phx.gbl
Xref: cpmsftngxa06.phx.gbl microsoft.public.excel.programming:417461
NNTP-Posting-Host: TK2MSFTNGXA12 10.40.1.164
X-Tomcat-NG: microsoft.public.excel.programming

I've just downloaded Office Excel 2003

While messing around with the XML import functions, I've
noticed that Excel does not naturally format a date from
an ADO.Net dataset, i.e.

2003-08-24T00:00:00.0000000-03:00

I would have thought that it should be able to do this.
While I could easily write a parser to strip the date and
time from this date, I would much rather not have to
include a new column in the spreadsheet to do this.

Another thing I think should be automatically formattable
is a tick/cross for TRUE/FALSE values.

Any thoughts?
Jeremy