Printable View
I am trying to export data from a Store to an excel file. The store is not linked to a grid though (I just want to pull the data in from the DB and export it). I used the OnSubmitData to fire the code behind. It successfully creates an Excel file, but it is blank! I belive the xmlNode I am creating is blank. How can I get an XmlNode from a Store?
Thanks,
Jon
Hi,
The following sample demonstrates exporting data in several different formats.
https://examples1.ext.net/#/GridPane...ort_Data_Ajax/
Hope this helps.
That is the example I have been working off of. However, it only shows how to get the XmlNode object from a gridpanel record, and I need to be able to extract one from the Store itself.
Hi,
You can use the Store's getRecordsValues method instead of the GridPanel's getRowsValues one.
After some work, I managed to get the record to export to excel. However, it simply comes as a basic table. I tried editing the .xsl file, but I cannot find a good guide for styling the exported excel file. Could you please provide me with some information on how to customize the excel file? For instance, I would like to export the file with the fields as rows and the values as columns. Is this possible?
Thank you,
Jon
It would probably be best to use the Google to find the correct format required by Excel.Quote:
Originally Posted by JonC
I tried looking for a guide for editing the .xsl file on google, but I did not have any luck. I was hoping someone there had some expertise on it, or knew where I could find more information.
I would look into:
http://www.w3schools.com/xsl/xsl_languages.asp
There is the "Next Chapter" button.
I am using https://examples2.ext.net/#/GridPane...Data_PostBack/ from server side as an example and it works, my problem is that the xls file that I build take a few seconds, upto a minute or 2, so how can I display a mask or any progress to the user?
[Html]
I would like to use the following, just for consistancy of the whole application:Code:<ext:Button ID="btnXls" Text="To Excel" runat="server" Icon="PageExcel" ToolTip="Search for unallocated documents From date To date"
ToolTipType="Qtip" AutoPostBack="true">
</ext:Button>
, but as soon as I use the code above, I then can not use:Code:<ext:Button ID="btnXls" runat="server" Text="Search for unallocated documents From date To date">
<DirectEvents>
<Click OnEvent="btnXls_Click" Before="Ext.Msg.wait('Building report...', 'Report');"
Failure="Ext.Msg.show({
title : 'Error',
msg : 'Error during report building,
minWidth: 200,
modal : true,
icon : Ext.Msg.ERROR,
buttons : Ext.Msg.OK
});">
</Click>
</DirectEvents>
</ext:Button>
I have even tried https://examples2.ext.net/#/Miscella...r_Side_Update/, but it also give an error.Code:Context.Response.AppendHeader("Content-Disposition", "inline;filename=" + System.IO.Path.GetFileName(TempFilename));
Context.Response.ContentType = AS2.MIME.MimeType.Get_MIMETypeFromFile(TempFilename);
Context.Response.AddHeader("Content-Length", (string)Microsoft.VisualBasic.FileLen(TempFilename));
Context.Response.WriteFile(TempFilename);
I can build the report in a handler like https://examples2.ext.net/#/GridPane...it_to_Handler/, but I can not see how to pass multi parameters like below?
Can you sugest which way to go?Code:ResourceManager1.AddScript("window.open('../Handler1.ashx?Type=Documents_Not_Received&UAType=" + dropDocumentType.SelectedItem.Text + "&FromDate=" + DateFrom.SelectedDate.ToString + "&ToDate=" + DateTo.SelectedDate.ToString + "&DepotID=" + DepotID + "&EmailAddress=" + (string)Session("EmailAddress") + "&SessionID=" + Session.SessionID + "','_blank')")
Hi @Picman,
Unfortunately, it is an AJAX downloading limitation - no success/failure events. So, no way to hide a mask.
Here is a single approach we can suggest with AJAX downloading.
http://forums.ext.net/showthread.php...ll=1#post83757
Or you can try another ways to download files. For example, Flash.