Re: DEV2 pushing application/vnd.msexcel

[Michael_Schutte@xxxxxxxxxxxx]

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.