GrapeCity.Documents.Excel.Workbook.GenerateReport

GenerateReport Method

GenerateReport()

Processes the template and returns a new report workbook instance.

Unlike ProcessTemplate(), this method generates the report in a new IWorkbook so the current template workbook can be retained for further use.

Declaration

public IWorkbook GenerateReport()

Public Function GenerateReport() As IWorkbook

Returns

Type	Description
IWorkbook	A new IWorkbook instance that contains the generated report.

Implements

IWorkbook.GenerateReport()

Examples

worksheet.Range["A1"].Value = "Class: {{className}}";
workbook.AddDataSource("className", "Class 3");
IWorkbook report = workbook.GenerateReport();
object value = report.Worksheets[0].Range["A1"].Value;

GenerateReport(params IWorksheet[])

Processes the template and returns a new report workbook that includes only the specified worksheets.

Use this method to generate a new IWorkbook from the current template workbook while limiting report generation to the provided worksheets.

Declaration

public IWorkbook GenerateReport(params IWorksheet[] worksheets)

Public Function GenerateReport(ParamArray worksheets As IWorksheet()) As IWorkbook

Parameters

Type	Name	Description
IWorksheet[]	worksheets	The worksheets to process.

Returns

Type	Description
IWorkbook	A new IWorkbook object that contains the generated report.

Implements

IWorkbook.GenerateReport(params IWorksheet[])

Examples

worksheet.Range["A1"].Value = "{{name}}";
workbook.AddDataSource("name", "Quarterly Report");
IWorkbook report = workbook.GenerateReport(worksheet);
object value = report.Worksheets[0].Range["A1"].Value;