# In-Table List with Highlighted Rows in Spreadsheet Document {{< alert style="info" >}}In this article, we will use GroupDocs.Assembly to generate In-TableList with Highlighted Rows report in Spreadsheet Document format.{{< /alert >}}{{< alert style="info" >}}The code uses some of the objects defined in [The Business Laye](https://docs.groupdocs.com/assembly/java/the-business-layer/)r.{{< /alert >}} ## In-Table List with Highlighted Rows in Microsoft Excel Document ### Creating a In-Table List with Highlighted Rows Practising the following steps you can create In-Table List with Highlighted Rows Template in MS Excel 2013. 1. Add a new Workbook. 2. Select the range of cells that you want to include in the table. 3. On the Insert tab, in the Tables group, click Table. 4. Insert a 2x4 table. 5. Click the cell you want to highlight. 6. Click "Cell Styles" in Styles group. 7. Save the template. ### Reporting Requirement As a report developer, you are required to represent the following key requirements: * Report must show all the client names with price. * Show single client and his single contract price in a single row. * It must highlight the record with contract price more than or equal to 1000000. * It must show sum of the contract prices. * It must represent all the information in tabular form. * Report must be generated in the Spreadsheet Document. ### Adding Syntax to be evaluated by GroupDocs.Assembly Engine

 

Client

Contract Price

<<foreach [in getContracts()]>><<if [getPrice() >= 1000000]>><<[getClient().getName()]>>

<<[getPrice()]>>

<<else>><<[getClient().getName()]>>

<<[getPrice()]>><</if>><</foreach>>

Total:

<<[getContracts().sum(

  c => c.getPrice())]>>

 

 

### Download In-Table List with Highlighted Rows Template Please download the sample In-Table List with Highlighted Rows document we created in this article: * [In-Table List with Highlighted Rows.xlsx](https://github.com/groupdocs-assembly/GroupDocs.Assembly-for-Java/blob/master/Examples/GroupDocs.Assembly.Examples.Java/Data/Storage/Spreadsheet%20Templates/In-Table%20List%20with%20Highlighted%20Rows.xlsx?raw=true) ### Generating The Report {{< gist GroupDocsGists 46c41d0904f70c013c0427c89757d29e >}} ### ODS Template and Report in Apache OpenOffice In order to check compatibility of ODS between Microsoft Office 2010 and Apache OpenOffice 4.1.2, we performed below tests: * We opened the ODS template created through Microsoft Office 2010 in Apache OpenOffice 4.1.2. The template opened successfully in Apache OpenOffice without any issues or formatting losses. * We opened the ODS report generated through GroupDocs.Assembly in Apache OpenOffice 4.1.2. The report opened successfully in Apache OpenOffice without any issues or formatting losses.