Article

Outputting CSV file from WebSpeed, not automatically handled by all versions of Microsoft Excel

Information

 
Article Number000064498
EnvironmentProduct: OpenEdge
Version: All supported versions
OS: All supported platforms
Other: MS Excel
Question/Problem Description
WebSpeed application returns responses containing CSV formatted data.
Goal is to have the data open as .csv file in Microsoft Excel
Some versions of MS Excel don't open the .csv file when it's received from the WebSpeed
 
Steps to Reproduce
Clarifying Information
Error Message
Defect/Enhancement Number
Cause
Content type in HTML header is set to "application/vnd.ms-excel", which is the registered MIME type for .xls files (MS Excel native format until MS Office 2003).
For CSV data, registered content type should be "text/csv" instead.
 
Resolution
Use the correct content type for the content format. 

The more common content types /MIME types for MS Excel are:
.csv ->
text/csv (comma-seperated text file)
.xls -> application/vnd.ms-excel (binary MS-Office format, pre-Office 2007)

.xlsx -> application/vnd.openxmlformats-officedocument.spreadsheetml.sheet (xml-based MS-Office format, default and preferred since MS-Office 2007)
Workaround
Notes
It is at all times left up to the HTTP client (web browser, application, device...) to decide how to handle which content type, as the web server + WebSpeed can not predict which client has which programs installed.
For example, the client receiving the csv file may not have MS Excel installed at all, and may choose to open the file in another spreadsheet program instead.
Attachment 
Last Modified Date11/12/2015 10:41 AM


Feedback
 
Did this article resolve your question/issue?

   

Your feedback is appreciated.

Please tell us how we can make this article more useful. Please provide us a way to contact you, should we need clarification on the feedback provided or if you need further assistance.

Characters Remaining: 1025