× The internal search function is temporarily non-functional. The current search engine is no longer viable and we are researching alternatives.
As a stop gap measure, we are using Google's custom search engine service.
If you know of an easy to use, open source, search engine ... please contact support@midrange.com.



Hi Vicki

If you're generating the file in XML (SpreadsheetML) then set the file extension to *.xml. As long as you define the relationship within Windows Explorer for xml files to be opened by MS Excel you won't have a problem opening them (assuming that the XML structure is valid).

Thanks for the tip about the "Short Date" format, I'll add that in to my service program as an option.

You may find the resources at https://msdn.microsoft.com/en-us/library/bb226687%28v=office.11%29.aspx useful.

All the best
Jonathan


----------------------------------------------------------------------

date: Thu, 12 Mar 2015 22:36:12 +0000
from: Vicki Wilson <VWilson@xxxxxxxxxxxxx>
subject: Re: Date formats in XML for Excel Spreadsheet download?
(Vernon Hamberg) (Jonathan Mason)

Vern, Jonathan & all,

Thanks for the helpful replies. I have a solution but I have one more question. When I go to open the file saved as .xls I get the following pop-up in excel "The file you are trying to open, 'xxx.xls', is in a different format than specified by the file extension. Is there anything I can change in the xml header to prevent this? The users actually want to be able to pass this information off without any fussing. I'm running MO 2010.

Vern to address some of your questions. I am creating this via websmart which I think would be fairly close to CGIDEV2. " Are you talking about the 2003 Spreadsheet XML format for Excel?" Is there a difference? I see about 4 references to excel in the header.
<?mso-application progid="Excel.Sheet"?>
xmlns:x="urn:schemas-microsoft-com:office:excel"
<ExcelWorkbook xmlns="urn:schemas-microsoft-com:office:excel">

Jonathan - I thought I was going to have to build a full time stamp - but the following works:
<Style ss:ID="s21">
<NumberFormat ss:Format="Short Date"/>
</Style>

<Cell ss:StyleID="s21"><Data ss:Type="DateTime">2013-09-12</Data></Cell>

I appreciate your response because I drove in this morning thinking I needed to build the full timestamp. I still might have to - I will let the users take a whack at it.

Thanks again for the reponses. I was kind of surprised that I had never done one of these before and we didn't have any examples in the shop.
Vicki



Proud partner of The Ageas Bowl and the Ageas Salisbury International Arts Festival.

Registered Address: Ageas House, Hampshire Corporate Park, Templars Way, Eastleigh, Hampshire, SO53 3YA Registered Number: 354568 England

Authorised by the Prudential Regulation Authority and regulated by the Financial Conduct Authority and the Prudential Regulation Authority

This e-mail together with any attachments are intended for the addressee only and may be private and confidential. If you are not the intended recipient, or the person responsible for delivering it to the intended recipient, you must not open any attachments, or copy, disclose, distribute, retain or use this e-mail, including any attachments, in any way whatsoever; please return it to us immediately using the reply facility on e-mail.

Consider the environment and think before you print this email.


As an Amazon Associate we earn from qualifying purchases.

This thread ...

Follow-Ups:

Follow On AppleNews
Return to Archive home page | Return to MIDRANGE.COM home page

This mailing list archive is Copyright 1997-2024 by midrange.com and David Gibbs as a compilation work. Use of the archive is restricted to research of a business or technical nature. Any other uses are prohibited. Full details are available on our policy page. If you have questions about this, please contact [javascript protected email address].

Operating expenses for this site are earned using the Amazon Associate program and Google Adsense.