In your AddType, is the MIME type of MS Excel correct ? Related : http://www.idug.org/solutions-journal-content/idug-e-bulletin-september-2010.html#N2005A
N On Sun, May 15, 2011 at 5:17 PM, Naqvi Aman <naqvi_a...@hotmail.com> wrote: > Thanks Steve, > > I'm one step closer now after adding the following to my httpd.conf: > > AddType .xls text/plain ebcdic 1.0 # XLS > document > But now instead of Iexplorer proposing to open the document in Microsoft > Excel, it reads it and displays the contents of the html/xml in the browser. > > I think easiest will be to simply put a link to save the target file and > open it under Windows..... Unless you have a different suggestion. > > Thanks, > > Aman Naqvi > > > > Date: Sat, 14 May 2011 16:27:16 -0600 > > From: st...@trainersfriend.com > > Subject: Re: USS webserver downloading .xls (html) file corrupt/bad > format > > To: IBM-MAIN@bama.ua.edu > > > > On 5/14/2011 3:32 PM, Naqvi Aman wrote: > > > Hi all, > > > > > > I have a requirment to update a MS Excel spreadsheet with data residing > on the mainframe. For this I have saved the excel file in html/xml format, > and transferred it on to the mainframe where I can edit its contents via a > batch process. I store the file under USS, and via a webserver, allow the > possibilty for people to download it and view it in Microsoft Excel. > > > > > > The issue I am facing is that once I download the file from the USS > location, Microsoft Excel opens the file but there seems to be a problem > with the text translation and all I see is unreadable characters. If I > transfer the file via a tool (filezilla), I dont have any problems reading > the file in Excel. > > > > > > Anyone have any similar experiences and any hints to solving this > issue? > > > > > > Regards, > > > > > > Aman Naqvi > > > > I suspect it is an issue of your file name and conversion mappings. > > What suffix does your file name have? For example, In our httpd.conf > > file I added: > > > > AddType .xml text/xml ebcdic 1.0 # XML > document > > > > > > Alternatively, you could add an extra extension to your file names. > > For example, I have some Unicode encoded xhtml files; if I name > > them 'file_name.xhtml.ascii' they get transmitted without code > > page conversion and they can open fine in a browser. > > > > Finally, if you're using cascading style sheets, you need to know > > the default is set wrong (in my opinion) so you want: > > > > AddType .css text/css ebcdic 1.0 # W3C Cascading Style > Sheets > > > > (the supplied default is '8bit' instead of ebcdic) > > > > > > > > HTH. > > > > > > > > -- > > > > Kind regards, > > > > -Steve Comstock > > The Trainer's Friend, Inc. > > > > 303-393-8716 > > http://www.trainersfriend.com > > > > * To get a good Return on your Investment, first make an investment! > > + Training your people is an excellent investment > > > > * Try our new tool for calculating your Return On Investment > > for training dollars at > > http://www.trainersfriend.com/ROI/roi.html > > > > ---------------------------------------------------------------------- > > For IBM-MAIN subscribe / signoff / archive access instructions, > > send email to lists...@bama.ua.edu with the message: GET IBM-MAIN INFO > > Search the archives at http://bama.ua.edu/archives/ibm-main.html > > ---------------------------------------------------------------------- > For IBM-MAIN subscribe / signoff / archive access instructions, > send email to lists...@bama.ua.edu with the message: GET IBM-MAIN INFO > Search the archives at http://bama.ua.edu/archives/ibm-main.html > ---------------------------------------------------------------------- For IBM-MAIN subscribe / signoff / archive access instructions, send email to lists...@bama.ua.edu with the message: GET IBM-MAIN INFO Search the archives at http://bama.ua.edu/archives/ibm-main.html
