Can UltraWebGrid Exptor to Excel In Multi-sheet

State See Verified Answer
Replies 4 replies
Subscribers 11 subscribers
Views 1755048 views
Users 0 members are here

240

Can UltraWebGrid Exptor to Excel In Multi-sheet

sun posted over 12 years ago

Hi team,

Now I am in such a situation, I have a urtalwebgrid and one of its colums named "category" ,and has three categories. When I use the UltraGridExcelExporter to export the webgrid I want to create three spreadsheets in a workbook,say "A","B","C",and exprot the data the each spreadsheet according to the colum named "category", just like rows with category "A", export to spreadsheet "A"; rows with category "B", export to spreadsheet "B"; rows with category "C", export to spreadsheet "C".

Can anyone give me some help.

Thanks Inadvance.

Parents

49378

Verified Answer
[Infragistics] Petar Ivanov posted over 12 years ago
Hi sunqy1212,

Thank you for posting in the community.

I am attaching a sample illustrating how your requirement can be achieved by creating a grid to be exported for each sheet and filtering the original datasource. Below is the code used in this case:

Code Snippet

    protected void Button1_Click(object sender, EventArgs e)

    {

        UltraWebGrid grid1 = new UltraWebGrid();

        UltraWebGrid grid2 = new UltraWebGrid();

        UltraWebGrid grid3 = new UltraWebGrid();

        grid1.DataSource = GetData().Where(c => c.CategoryName == "A");

        grid1.DataBind();

        form1.Controls.Add(grid1);

        grid2.DataSource = GetData().Where(c => c.CategoryName == "B");

        grid2.DataBind();

        form1.Controls.Add(grid2);

        grid3.DataSource = GetData().Where(c => c.CategoryName == "C");

        grid3.DataBind();

        form1.Controls.Add(grid3);

        UltraWebGridExcelExporter1.ExportMode = Infragistics.WebUI.UltraWebGrid.ExcelExport.ExportMode.Custom;

        Workbook book = new Workbook();

        book.Worksheets.Add("grid1");

        book.Worksheets.Add("grid2");

        book.Worksheets.Add("grid3");

        UltraWebGridExcelExporter1.Export(grid1, book.Worksheets["grid1"]);

        UltraWebGridExcelExporter1.Export(grid2, book.Worksheets["grid2"]);

        UltraWebGridExcelExporter1.Export(grid3, book.Worksheets["grid3"]);

        UltraWebGridExcelExporter1.ExportMode = Infragistics.WebUI.UltraWebGrid.ExcelExport.ExportMode.Download;

        UltraWebGrid dummy = new UltraWebGrid();

        form1.Controls.Add(dummy);

        UltraWebGridExcelExporter1.Export(dummy, book);

    }

}

Please note that the UltraWebGrid control is now outdated and as of .NetAdvantage 2011 Volume 2 is no longer included in our product package. I would suggest that you consider switching to the WebDataGrid/WebHieararchicalDataGrid. More information regarding these controls is available at:

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

Additional samples demonstrating the features of these grids can be found at:
http://samples.infragistics.com/aspnet/

Hope this helps.
UltraWebGridExportInDifferentSheetsBasedOnValues.zip
Cancel
Reply

Reject Answer

Cancel
49378

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

Hi sunqy1212,

Please feel free to contact me if are experiencing any issues.
Cancel
Reply

Cancel
25

Raju posted over 11 years ago in reply to [Infragistics] Petar Ivanov

When you click on Export to Excel button the drop downs which are there in the ultrwingrid. Dropdowns are not coming to xls as shown in above screen shots

Could you please help me
Cancel
Reply

Cancel

Reply

53790

Georgi posted over 11 years ago in reply to Raju

Hello Raju,

The mentioned behavior is expected and by design, because our excel engine use ValueList functionality. Also MS Excel does not allow multi column value list. For more details please take a look on http://help.infragistics.com/Help/Doc/WinForms/2013.2/CLR4.0/html/WinGridExcelEdporter_Exporting_DropDown_List_To_Excel.html

Let me know if you have any questions.

Regards
Cancel
Reply

Cancel

Children

No Data