Microsoft Office Forums

Go Back   Microsoft Office Forums > >

 
 
Thread Tools Display Modes
Prev Previous Post   Next Post Next
  #1  
Old 08-18-2017, 02:26 AM
PhillJ PhillJ is offline Generated spreadsheet in SLK format causes message upon browsing: format / extentsion don't match. Windows 8 Generated spreadsheet in SLK format causes message upon browsing: format / extentsion don't match. Office 2013
Novice
Generated spreadsheet in SLK format causes message upon browsing: format / extentsion don't match.
 
Join Date: Aug 2017
Posts: 3
PhillJ is on a distinguished road
Default Generated spreadsheet in SLK format causes message upon browsing: format / extentsion don't match.

Our financial application shows data grids (Oracle Forms), which users can EXPORT. This creates an Excel spreadsheet on the server which is then opened automatically by the browser. This allows the users to have their own spreadsheet copy of what they were viewing in the application.
The spreadsheet is generated in SYLK format, for example:

Content-type: application/vnd.ms-excel

ID;ORACLE
P;FVerdana;M200
P;FVerdana;M200;SB
P;FVerdana;M200;SUB
F;C1;FG0R;SM1
F;C2;FG0G;SM0
F;C3;FF0G;SM0
F;C4;FF0G;SM0
F;C5;FF2G;SM0
F;C6;FG0G;SM0
F;C7;FG0G;SM0
F;C8;FF2G;SM0
F;C9;FF2G;SM0
F;C10;FG0G;SM0
F;C11;FG0G;SM0
F;C12;FG0G;SM0
F;R1;FG0C;SM2
C;Y1;X1;K"eFin"
C;X2;K"Module"
C;X3;K"Usage"
- etc.

This is long-standing source code that has been working satisfactorily for years. Note the leading "Content-type:" setting.

However, some clients are getting messages which they do not like:


This appears to be a mismatch between the file contents, in SYLK format, and the file extension .xls. Note that the filename 'cfxsof.xls' appears to be generated by some layer within the browsing 'stack'; there is a CGI program called cfxsof.exe which 'provides' the generated file to the browser.

How can we ensure a match between the file contents and file extension?
Is there an alternative to the Content-Type setting?
Is there a way of defining a filename to overrule the generated "cfxsof.xls"?

Thank you in advance.
Reply With Quote
 

Tags
browser, sylk



Similar Threads
Thread Thread Starter Forum Replies Last Post
Macro to find and format with whole word match option Marrick13 Excel Programming 0 03-13-2016 10:04 AM
Generated spreadsheet in SLK format causes message upon browsing: format / extentsion don't match. HOW TO: Create an auto generated number format for saving templates Matkinson89 Word 2 09-03-2015 07:07 PM
Generated spreadsheet in SLK format causes message upon browsing: format / extentsion don't match. Mail merge will not format date field generated by Excel IF statement borntorun75 Mail Merge 3 12-16-2011 06:28 AM
Outlook Message Format Default hobo222 Outlook 2 11-23-2010 08:25 PM
How to set Message Format default TonyBender Outlook 0 10-27-2009 11:52 AM

Other Forums: Access Forums

All times are GMT -7. The time now is 04:57 PM.


Powered by vBulletin® Version 3.8.11
Copyright ©2000 - 2024, vBulletin Solutions Inc.
Search Engine Optimisation provided by DragonByte SEO (Lite) - vBulletin Mods & Addons Copyright © 2024 DragonByte Technologies Ltd.
MSOfficeForums.com is not affiliated with Microsoft