Glen: Excel will parse pure html tagged as an xls? If it's easier
than .CSV converting, I have to implement this for a customer.
Mike: I generally use Comma Seperated Value tables for porting light
databases to users, since they are plain-text and very portable (and
any portion of a db small enough to view as html is small enough to
make csv feasible) There also are ample available code snippets to
parse CSVs in any language -- but it's quite easy to implement
dbarray=csv.split(",") yourself. jQuery would make it very easy to
build a CSV as well.
On Aug 9, 7:10 am, "Glen Lipka" <[EMAIL PROTECTED]> wrote:
> the format of the html can be a regular old <TBALE> tag. To have it point
> to Excel you need to change the headers. In php:
> <?php
> header("Content-type: application/vnd.ms-excel; name='excel'");
> header("Content-Disposition: filename=export.xls");
> header("Pragma: no-cache");
> header("Expires: 0");
>
> Glen
>
> On 8/8/07, Mike Miller <[EMAIL PROTECTED]> wrote:
>
>
>
> > Hi,
>
> > Am wondering if this is possible with ajax and jquery.
>
> > I have a table that contains data I would like to export to excel. Is
> > it possible using the .ajax() method to post the table data (e.g. $
> > ("#tableid")) to the php page on the backend and have it return an
> > excel file?
>
> > I plan on using the pear module Spreadsheet_Excel_Writer to generate
> > the xls file. Any ideas on whether or not this is possible.
>
> > M
