ASP.NET, obout suite: ExportToExcel from Grid
Posted on 2009-02-18
Again, I'm using the obout suite of components (brilliant stuff). I have a grid populated from a database. In my aspx file I created a button that looks like this:
<asp:Button ID="Button1" runat="server" Text="Export to Excel" />
In the codebehind (.aspx.vb) I have the following line in the Button1_click event:
Grid1.ExportToExcel("Servers", False, False, True, True)
It DOES save the excel file to the folder specified in the FolderExports property, however, it does not prompt the browser to download the file. The site is running from a nonstandard port, ie http://servername.domain.com:8910 so I'm wondering if that would have anything to do with it... I e-mailed obout support and they tried to help, but don't speak the best English. He indicated I may be using the serverside export method instead of the clientside method, but I'm really not sure the difference between implementation for the two...
I'm using Visual Studio.