DevExpress Document server Access Excel worksheets

Method/Step

1 can refer to the following code:

Using Devexpress.spreadsheet;

// ...

Workbook workbook = new Workbook ();

Access a collection of worksheets.

Worksheetcollection worksheets = workbook. worksheets;

Access a worksheet by its index.

Worksheet Worksheet1 = Workbook. Worksheets[0];

Access a worksheet by its name.

Worksheet Worksheet2 = Workbook. The index of the worksheets["Sheet2"];2 worksheet is zero-based, which specifies the position of the worksheet within the collection. The name of the worksheet must be unique within the collection, and it will also be shown in the worksheet tab, which is the effect that the spreadsheet created with DevExpress Document server opens in Microsoft Excel.

Classification:

• Excel Tutorials