# 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
|