Linq reporting for Excel

Aspose.Cells Product Family
1

Dear Team

I am looking for feature like linq-reporting-engine for excel. We are using it for Docx but we need it also for XLSX. Does it support from Aspose library?

Thanks
Chandra

2

@aroc,

Aspose.Cells provides a feature called Smart Markers that is similar to the LINQ Reporting Engine in Aspose.Words, and it can be used to dynamically generate and populate Excel (XLSX) files based on data. You can create/design template Excel file (which includes smart markers/tags in different cells in the worksheet) accordingly or insert markers dynamically in code as well.

Please note, Smart Markers in Aspose.Cells are placeholders (or markers) placed in a template Excel file, and these markers get replaced with data during processing. The Smart Markers feature allows you to dynamically generate reports and populate Excel files by binding data to the markers, much like how you would use the LINQ Reporting Engine in Aspose.Words for DOCX files.

Smart Markers work by defining placeholders in the template, which are later replaced with actual data from a data source (such as a DataTable, List, JSON, custom objects or any other data structure).

3

Thank you for your fast reply. Is there way to use same sytax for linq docx for example <<[CompanyName]>> so user does not have to learn two types of syntax.

4

@aroc
We don’t use the sytax for linq docx.
Please try the following codes：

Aspose.Cells.WorkbookDesigner designer = new Aspose.Cells.WorkbookDesigner();
Cells cells = designer.Workbook.Worksheets[0].Cells;
cells["A1"].PutValue("&=$CompanyName");
designer.SetDataSource("CompanyName", "ABCD");
designer.Process();
designer.Workbook.Save(dir + "dest.xlsx");
5

@aroc,

Please note, Smart Markers is a distinctive feature offered by Aspose.Cells that has its own syntax and style, which means you cannot always execute the task in the way you want. So, you have to follow certain rules and formats when defining smart markers in Excel spreadsheets.