ClosedXML Template not setting data into excel sheet

Question

I am trying to put data into cells using closedxml and according to their site we have to set parameters like this on the cells {{TestName}} but it won't work for me.

This is my code and I am not sure where I am going wrong.

const string outputFile = @"\\Reports\Output\Test.xlsx";
var template = new XLTemplate(@"\\Reports\Test.xlsx");

var test = new models.Test();
test.id = 1;
test.TestName = "ASDF";
test.TestScore = "303";

template.AddVariable(test) //also tried doing it like this.


template.AddVariable("TestScore", "232");
template.AddVariable("TestName", "TESTNAME");
template.SaveAs(outputFile);
Process.Start(new ProcessStartInfo(outputFile) { UseShellExecute = true });

And my excel template looks like this.

Kristofer · Accepted Answer · 2021-10-05 20:15:51Z

3

Solved it!

Just add template.Generate(); after adding the variables into the template.

answered Oct 5, 2021 at 20:15

Kristofer

82711 silver badges28 bronze badges

Sign up to request clarification or add additional context in comments.

2 Comments

blueelite Over a year ago

do have a repo example about it ?

Kristofer Over a year ago

no just add the template.Generate() before saving the file & it should add the variables

Collectives™ on Stack Overflow

ClosedXML Template not setting data into excel sheet

1 Answer 1

2 Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

2 Comments

Your Answer

Sign up or log in

Post as a guest

Related