ClosedXML.Report: Method not found

I installed ClosedXML.Report (version 0.2.6) [Dependencies ClosedXML version is 0.97.0) from the NuGet and write a simple program. When I run program, it’s OK. I also upgraded ClosedXML to the latest (version 0.100.3) and then when I run, I got this error message.

System.MissingMethodException HResult=0x80131513 Message=Method not found: ‘Void ClosedXML.Excel.IXLCell.set_Value(System.Object)’. Source=ClosedXML.Report StackTrace: at ClosedXML.Report.RangeInterpreter.ParseTags(IXLRange range, String rangeName) at ClosedXML.Report.RangeInterpreter.Evaluate(IXLRange range) at ClosedXML.Report.XLTemplate.Generate() at Program.<Main>$(String[] args) in D:\ConsoleApp\Program.cs:line 18

Here is the source.

var template = new XLTemplate(@"D:\Simple.xlsx");
var file = @"D:\Simple data.xlsx";
var cust = Customer.Default();

template.AddVariable(cust);
template.Generate();
template.SaveAs(file);
Process.Start(new ProcessStartInfo(file) { UseShellExecute = true });

I think, should be upgraded ClosedXML.Report to be working together with lasted update of ClosedXML.

About this issue

Original URL
State: closed
Created a year ago
Reactions: 6
Comments: 19 (6 by maintainers)

Commits related to this issue

#303 Updated dependencies — committed to vbondarev/ClosedXML.Report by vbondarev a year ago
#303: Bump to ClosedXML 0.100.3 (unit tests fail) — committed to vbondarev/ClosedXML.Report by vbondarev a year ago

Most upvoted comments

Versions 0.2.7 and 0.2.8 (referencing ClosedXML 0.100 and 0.101, respectively) have been released lately. The version 0.2.9 (referencing 0.102) is on its way.

Pankraty on Jul 27, 2023

I cloned the ClosedXML.Report source and then made some fixes. Now it’s working with ClosedXML version 0.100.3 (no more errors and output results correctly) but I am not sure all features of ClosedXML.Report is working or not.

mymintin on Mar 10, 2023

Hi @vbondarev , Any update above issue .Please try to add fix and release new build.

KIRANREDDY0228 on May 24, 2023

Hi @vbondarev , the above still getting. Please help us to fix above issue. please try release new version by adding the fix

KIRANREDDY0228 on May 21, 2023

Just want to add another vote for this. Thank you!!

spencerslade on May 5, 2023

Good day @vbondarev, are you planning to push the fix for it? We would like to upgrade to the latest ClosedXml version since there were a lot of performance fixes, but cannot due to this issue. It seems to be only working with ClosedXml 0.97.0 😦

Hi. Yes, I plan to end this PR. But I have a lot of work. I will try to complete this task this week.

vbondarev on Apr 18, 2023

@mymintin I will create a new pull request based on your code. If you don’t mind )

vbondarev on Mar 28, 2023

I did fork the Report repo, create a new branch, add & modify and pull request.

mymintin on Mar 14, 2023

Or, simply create a PR to this repo and I will release a new version, compatible with the latest ClosedXML. I would really appreciate your help.

Pankraty on Mar 11, 2023

I understand that it will eat up some of your time but will it be possible for you to fork the Report repo, create a branch and a PR with your changes to your fork?

swekeshav on Mar 10, 2023

I get the same issue with ClosedXML.Report (version 0.2.6) and ClosedXML version 0.100.3 .

HolgerKeller on Mar 1, 2023