Pivot Tab error Specified argument was out of the range of valid values about closedxml.report HOT 8 CLOSED

The named range of QLIST should not be B4:K5, but A4:K5. Check this should help.
Read the documentation here https://closedxml.github.io/ClosedXML.Report/docs/en/Flat-tables#Vertical-tables

Each range specifying the vertical table must have at least two columns and two rows. The leftmost column and the bottom row serve to configuration purposes and are treated the special way. After the report is built the service column is cleared, and the service row is deleted if it is empty.

from closedxml.report.

Thanks for your help.

i am attaching the template. i want the report format like that. is it possible

thanks in advance.
STUDENT_LIST.xlsx

from closedxml.report.

Try this

Cells A5 - <<pivot>>, B5 - <<data>><<count>>, F5 - <<column>>
As a result, ClosedXML.Report will create a pivot table on a new sheet.

from closedxml.report.

hi
Thanks for your suggestion.

getting the following error on template.SaveAs(filename)

Value cannot be null.\r\nParameter name: source

thanks

from closedxml.report.

Put your code in, I'll check it in the evening.

from closedxml.report.

Hi

Please find the code below.

`System.Data.DataTable oDt = oBL.rptClassSectionStudentList().Tables[0];

			template.AddVariable("QLIST", oDt);


			template.AddVariable("INST_NAME", oDt.Rows[0]["INST_NAME"]);
			template.AddVariable("CLASS_NAME", oDt.Rows[0]["CLASS_NAME"]);
			template.AddVariable("SECTION_NAME", oDt.Rows[0]["SECTION_NAME"]);
			template.AddVariable("ST_COUNT", oDt.Rows[0]["ST_COUNT"]);

			template.AddVariable("LOGIN_NAME", oDt.Rows[0]["LOGIN_NAME"]);

			template.Generate();
			template.SaveAs(fileName);

also the template is attached.

thanks in advance
STUDENT_LIST.xlsx

from closedxml.report.

Did you manage to solve the problem?

from closedxml.report.

Closed due to a long wait for an answer. If the issue is still relevant, reopen it.

from closedxml.report.