[jQuery] Re: Create excel file from table data, not making new server request

2008-09-02 Thread SamW11
SamW11 wrote: Since we can get all table data easily using the client side technology only, can we export/popup new window(using javascript or ..) to display these table data without making new server request ? Glen Lipka wrote: the format of the html can be a regular old TBALE

[jQuery] Re: Create excel file from table data

2008-09-02 Thread SamW11
Glen Lipka 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);

[jQuery] Re: Create excel file from table data

2007-08-10 Thread Glen Lipka
On 8/9/07, polyrhythmic [EMAIL PROTECTED] wrote: 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. Yes. Specifically a table. You can even add CSS backgrounds, and borders which Excel picks up too. (Assuming the

[jQuery] Re: Create excel file from table data

2007-08-10 Thread Mike Miller
Hi...how would you post this back with an ajax request? M On Aug 9, 8: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;

[jQuery] Re: Create excel file from table data

2007-08-10 Thread polyrhythmic
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

[jQuery] Re: Create excel file from table data

2007-08-10 Thread Bil Corry
Glen Lipka wrote on 8/10/2007 10:34 AM: Yes. Specifically a table. You can even add CSS backgrounds, and borders which Excel picks up too. (Assuming the headers say its excel) And you can tell Excel how to format the data, for example to display a US zip code: td

[jQuery] Re: Create excel file from table data

2007-08-10 Thread duma
I'll take this opportunity to announce an Excel reading-and-writing library for .Net that I've made available: Get the library http://pinkblack.org/excel_dotnet/ here ! I ported the code from a Java library called JExcelApi (thanks, you all!! ;-)) Keep creating! Sean Glen Lipka wrote:

[jQuery] Re: Create excel file from table data

2007-08-09 Thread Glen Lipka
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

[jQuery] Re: Create excel file from table data

2007-08-09 Thread SeViR
I used the TABLE HTML method for Excel file creation, the problem is that, the result file is not editable. If you try edit this file in Excel, requires to save as other native file. Glen Lipka escribió: the format of the html can be a regular old TBALE tag. To have it point to Excel you

[jQuery] Re: Create excel file from table data

2007-08-09 Thread Glen Lipka
So you want to use Excel as a web client and edit? Not sure how that could work without WebDav or something. I know some people who are using Google Spreadsheets to do that. They have an open API and everything. Glen On 8/9/07, SeViR [EMAIL PROTECTED] wrote: I used the TABLE HTML method for