Working with Spreadsheet Documents

Working with Spreadsheet Documents

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:

Client

Manager

Contract Price

<<foreach [

    c in ds

]>><<[c.Client]>>

<<[c.Manager]>>

<<[c.Price]>><</

foreach>>

Working with Table-Row Conditional Blocks

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:

 

 

 

<<if ...>> ...

...

...

...

...

...

<<elseif ...>> ...

...

...

...

...

...

<<else>> ...

...

...

...

...

...

...

...

... <</if>>

 

 

 


Download

Data Source Document

Template

The Code