Working with Spreadsheet Documents Leave feedback

Note

This feature is supported by version 18.2 or greater.

Note

The code uses some of the objects defined in The Business Layer.

GroupDocs.Assembly allows you to use data bands in table rows in Spreadsheet Documents. A table-row data band is a data band which body occupies single or multiple rows of a single document table. The body of such a band starts at the beginning of the first occupied row and ends at the end of the last occupied row as follows. The syntax for using data bands in spreadsheet document is as follows:

You can also use a table-row conditional block which body occupies single or multiple rows of a single document table. The body of such a block (as well as the body of its every template option) starts at the beginning of the first occupied row and ends at the end of the last occupied row as follows:

• Managers Data.xlsx

• Working with Table Row Data Bands.xlsx