Excel export to export complete dataset | Infragistics Forums

840

Excel export to export complete dataset

anil kumar posted over 12 years ago

hi,

Can anyone let me know ,

Is there any way to export to excel from complete dataset without using the webdatagrid.

Thanks in Advance

49378

[Infragistics] Petar Ivanov posted over 12 years ago in reply to anil kumar
Hi anilkoomar_1202,

It is possible to donwload the workbook you have created using the ExcelExporter by using a dummy grid. For instance:

Code Snippet

protected void Button1_Click(object sender, EventArgs e)

{

    Workbook book = new Workbook();

    WebDataGrid grid = new WebDataGrid();

    form1.Controls.Add(grid);

    WebExcelExporter1.Export(grid, book);

}

Please let me know if this helps.
Cancel
Reply

Cancel
840

anil kumar posted over 12 years ago in reply to [Infragistics] Petar Ivanov

Hi Petar Ivanov,

Thanks for your quick relpy,

i have gone to the link that you have provided me. i need to save the workbook with save as dialog ,i.e providing the user to select a location to save the file.but i have find the save as in the workbook .

Can you provide the information to save a file with "Save as" dialog.

Or

Is there any way to save the workbook using the excelexporter

Thanks In Advance.
Cancel
Reply

Cancel
49378

[Infragistics] Petar Ivanov posted over 12 years ago

Hi avilkoomar_1202,

Thank you for posting in the community.

You can use the Infragistics.Excel library in order to create a workbook using a dataset. A complete guide on how this can be achieved is available at:

http://help.infragistics.com/NetAdvantage/ASPNET/2011.2/CLR4.0/?page=ExcelEngine_Populating_a_Worksheet_from_a_DataSet.html

Please let me know if this helps.
Cancel
Reply

Cancel