Re: DEV2 pushing application/vnd.msexcel

Here I go again, ask the question and find the solution on my own again.


SOLUTION:


Content-type: text/html
Content-disposition: attachment; filename=test.xls



with attachment being the key to display correctly.



Michael Schutte
Admin Professional
Bob Evans Bob-B-Q: You haven't had barbeque until you've had Bob Evans
Bob-B-Q. Try our six Bob-B-Q dishes, starting at $5.99. For more
information, visit www.BobEvans.com.


web400-bounces@xxxxxxxxxxxx wrote on 08/11/2008 12:25:56 PM:

I'm trying to push back to the browser an HTML table that should be

opened

in Excel. But apparently the code page isn't correct. Because I am
getting garbage when excel opens. Here's my HTML skeleton.

/$top
Content-type: application/vnd.ms-excel

<table>
<tr>
<td>&nbsp;</td>
<td>Location</td>
<td>Name</td>
<td>Date</td>
<td>Net D/I</td>
<td>Net C/O</td>
<td>Net B&W</td>
<td>Net Liq</td>
<td>Net<BR>Sales</td>
<td>Sales<BR>Tax</td>
<td>Gross<BR>Sales</td>
<td>Cash<BR>Dep#1</td>
<td>Cash<BR>Dep#2</td>
<td>Visa/MC<BR>Dep</td>
<td>Amex<BR>Dep</td>
<td>Discov<BR>Dep</td>
<td colspan=2>Paid Outs</td>
<td>Over/Short</td>
</tr>
</table>

Has anyone else had any luck doing this? I know that I can push to a

stmf

and specify the code page that way. But I'm trying to avoid build a file
on the IFS and pushing that location to the browser.



Michael Schutte
Admin Professional
Bob Evans Farms, Inc.
3776 South High Street, Columbus, OH 43207
Phone: 614/492-7419 Fax: 614/409-2017
Visit us on the web! www.bobevans.com



Bob Evans Bob-B-Q: You haven't had barbeque until you've had Bob Evans
Bob-B-Q. Try our six Bob-B-Q dishes, starting at $5.99. For more
information, visit www.BobEvans.com.--
This is the Web Enabling the AS400 / iSeries (WEB400) mailing list
To post a message email: WEB400@xxxxxxxxxxxx
To subscribe, unsubscribe, or change list options,
visit: http://lists.midrange.com/mailman/listinfo/web400
or email: WEB400-request@xxxxxxxxxxxx
Before posting, please take a moment to review the archives
at http://archive.midrange.com/web400.