Represents a web worksheet.

For a list of all members of this type, see WebWorksheet Members.

System.Object
   System.Web.UI.Control
      Aspose.Grid.Web.Data.WebWorksheet
         Aspose.Grid.Web.Worksheet

Thread Safety

Public static (Shared in Visual Basic) members of this type are safe for multithreaded operations. Instance members are not guaranteed to be thread-safe.

Example

[C#]
...
using System.Web.UI.WebControls;
...
...

WebWorksheets Worksheets = GridWeb1.WebWorksheets;
WebCells cells = Worksheets[0].Cells;

//Sets default row height
cells.StandardHeight = new Unit(16, UnitType.Point);
//Sets row height
cells.SetRowHeight(2, new Unit(20, UnitType.Point));

//Sets default colum width
cells.StandardWidth = new Unit(50, UnitType.Point);
//Sets column width
cells.SetColumnWidth(3, new Unit(80, UnitType.Point));

//Merge cells
cells.Merge(5, 4, 2, 2);

//Import data
DataSet1 ds1 = new DataSet1();

for (int i =0; i<16; i++)
{
    DataSet1.Table1Row row = ds1.Table1.NewTable1Row();
    row["c1"] = "hello1";
    row["c2"] = i;
    row["c3"] = "data";
    ds1.Table1.AddTable1Row(row);
}

GridWeb1.WebWorksheets.ImportDataView(ds1.Table1.DefaultView, null, null);

//Import from excel file
Worksheets.ImportExcelFile("c:\\file1.xls");

[Visual Basic]
Imports System.Web.UI.WebControls
...
...
 
Dim Worksheets As WebWorksheets =  GridWeb1.WebWorksheets 
Dim cells As WebCells =  Worksheets(0).Cells 
 
'Sets default row height
cells.StandardHeight = New Unit(16, UnitType.Point)
'Sets row height
cells.SetRowHeight(2,New Unit(20,UnitType.Point))
 
'Sets default colum width
cells.StandardWidth = New Unit(50, UnitType.Point)
'Sets column width
cells.SetColumnWidth(3,New Unit(80,UnitType.Point))
 
'Merge cells
cells.Merge(5, 4, 2, 2)
 
'Import data
Dim ds1 As DataSet1 =  New DataSet1() 
 
Dim i As Integer
For  i = 0 To 15
    Dim row As DataSet1.Table1Row =  ds1.Table1.NewTable1Row() 
    row("c1") = "hello1"
    row("c2") = i
    row("c3") = "data"
    ds1.Table1.AddTable1Row(row)
Next
 
GridWeb1.WebWorksheets.ImportDataView(ds1.Table1.DefaultView, Nothing, Nothing)
 
'Import from excel file
Worksheets.ImportExcelFile("c:\\file1.xls")

Requirements

Namespace: Aspose.Grid.Web.Data

Assembly: Aspose.Grid.Web (in Aspose.Grid.Web.dll)

See Also

WebWorksheet Members | Aspose.Grid.Web.Data Namespace