How i can use this code in VB.NET ?

 

protected void ExportToExcel(object sender, EventArgs e)
    {
        Infragistics.Excel.Workbook workbook = new Infragistics.Excel.Workbook();
        workbook.Worksheets.Add("Sheet1");
        workbook.Worksheets.Add("Sheet2");

        this.CopyPasteGrid1.DisplayLayout.ColHeadersVisibleDefault = ShowMarginInfo.No;
        this.UltraWebGridExcelExporter1.Export(this.CopyPasteGrid1, workbook);
        for (int i = 0; i < this.CopyPasteGrid1.Columns.Count; i++)
        {
            workbook.Worksheets[0].Columns[i].Width = 2000;
        }

        this.CopyPasteGrid2.DisplayLayout.ColHeadersVisibleDefault = ShowMarginInfo.No;
        workbook.ActiveWorksheet = workbook.Worksheets[1];
        this.UltraWebGridExcelExporter1.Export(this.CopyPasteGrid2, workbook);
        for (int i = 0; i < this.CopyPasteGrid2.Columns.Count; i++)
        {
            workbook.Worksheets[1].Columns[i].Width = 2000;
        }
        workbook.ActiveWorksheet = workbook.Worksheets[0];

    }

Tony

 

Exactly my scenario is the same what you are describing. 

The same was done by me and I found the data getting erased everytime of new export.

whereas I'm not able to get the property "ActiveWorksheet".

workbook.ActiveWorksheet = workbook.Worksheets[0];

I'm using the version 8.

Any how I got a solution : merging two grids into one grid and exporting that grid.

 

Thanks for your continuous reply Tony.

regards.

 

Ceenu,

I'm not sure why you're data is getting lost, unless there is a bug in the version you're using, or your scenario is different than the one I'm describing here.  I have verified that the concept and code I provdied will indeed produce the expected results.  Here is the code I'm using -

Infragistics.Excel.Workbook workbook = new Infragistics.Excel.Workbook();

workbook.Worksheets.Add("Sheet1");

this.UltraWebGridExcelExporter1.Export(this.UltraWebGrid1, workbook);

this.UltraWebGridExcelExporter1.Export(this.UltraWebGrid1, workbook,10,0 );

workbook.ActiveWorksheet = workbook.Worksheets[0];

The code above produces an Excel document with the grid data exported two times (I had 10 rows in my grid). 

I see notes about a bug BR09194 which may be related to the issue you're describing, but it was fixed approximately 3 years ago in the following versions:

6.1.20061.26 CLR 1.x / 2.0, 5.3.20053.1079 CLR 1.x / 2.0, 5.2.20052.1063, 5.1.20051.1092

Hope this helps,

-Tony

 

I'm doing the same.

but grid one is getting exported. then I'm setting the row & column numbers.

and exporting the second grid. resulting is the second grid only can be visible where other is getting erased.

you just please go through the following.

The Export method is overloaded, with one of the overloads allowing you to specify the workbook and the start row/end row.  You can use the code snippet above, but for the second Export, rather than adding a new Worksheet and changing the ActiveWorksheet, simply use the overloaded Export method where you supply the start row and column for the export.