Loading ...
Excel export to XML
home
browse
articles
blogs
events
forums
jobs
people
wiki
Login
Register
×
Choose a location:
home
articles
forums
blogs
jobs
events
wiki
people
home
»
forums
»
asp.net topics
»
data access
»
Excel export to XML
forums
Excel export to XML
Posted in:
ASP.NET Topics
»
Data Access
Subscribe to RSS
nbsabbj mino
Posted: 8/25/2011
Hi
Im having problems with dates when exporting an excel spreadsheet as an XML file. I have applied an XML map to the spreadsheet in which the users enter data. They then save the spreadsheet as an xml document. Everything exports fine apart from the dates which are appearing as the XLS serial date format (a number). If I format all date fields as text then the data exports fine. The prob Im having is that the users are copying these dates from another spreadsheet where the fields are formatted as dates. When they copy into my spreadsheet it is defaulting my text field back to a date field and thus the dates are saving again as the serial date format. Is there a way tp get the XML file to save whats in the field as when I save as a CSV that date appears fine even though it is formatted as a date field.
http://www.rsdisnow.com/
Page 1 of 1 (1 items)
×
Loading ...