1,931 questions
Hey I got that issue fixed and we need to add the DocumentFormat.OpenXml.dll to the bin folder and thanks for the help
how to fix System.IO.FileNotFoundException: 'Could not load file or assembly 'DocumentFormat.OpenXml, Version=2.19.0.0, Culture=neutral, PublicKeyToken=8fb06cb64d019a17' or one of its dependencies. The system cannot find the file specified.'
![](data:image/svg+xml, %3Csvg xmlns='http://www.w3.org/2000/svg' height='64' class='font-weight-bold' style='font: 600 30.11764705882353px "SegoeUI", Arial' width='64'%3E%3Ccircle fill='hsl(112.00000000000001, 13%, 20%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EDS%3C/text%3E%3C/svg%3E)
Dineshkumar.S
456
Reputation points
I tried to run a excel file in my application and it is showing me the error mentioned below
System.IO.FileNotFoundException: 'Could not load file or assembly 'DocumentFormat.OpenXml, Version=2.19.0.0, Culture=neutral, PublicKeyToken=8fb06cb64d019a17' or one of its dependencies. The system cannot find the file specified.'
code snipper where error throws:
bool isSuccess = CompareFormula(answerPath, out isCorrect, out strResult);
return Executer.Compare_Do(isSuccess,isCorrect, strResult, out result);
how to fix this and i have updated the openxml to latest version but after that also it shows the same error so do i need to add anything further can anyone suggest me some ideas? Thanks in advance
Developer technologies Windows Forms
Developer technologies .NET Other
4,103 questions
Developer technologies C#
11,570 questions
{count} votes
-
Jack J Jun 25,296 Reputation points2023-02-28T07:55:38.8533333+00:00 @Dineshkumar.S, Welcome to Microsoft Q&A, could you provide a completed code example? We could not reproduce your problem just with one line code.
-
Dineshkumar.S 456 Reputation points
2023-02-28T09:21:56.3733333+00:00 public override bool ExecuteAction(object value, out object result, IExecutor Executer) { result = null; try { string answerPath; string correctPath; if (!Executer.GetPaths(value, out answerPath, out correctPath)) { Logger.Do(EventLog.Error, "Exception at ExecuteAction of do compare presentation", "false returned from ActionExecutionClass.Compare.GetPaths"); return false; } bool isCorrect; string strResult; bool isSuccess = CompareFormula(answerPath, out isCorrect, out strResult); return Executer.Compare_Do(isSuccess,isCorrect, strResult, out result); } catch (Exception ex) { Logger.Do(EventLog.Error, "Exception at ExecuteAction of ", this.GetType().Name, ex.ToString()); return false; } -
Jack J Jun 25,296 Reputation points
2023-03-01T02:12:07.3833333+00:00 @Dineshkumar.S , thanks for the feedback, maybe I did not describe it clearly. Please provide the design of the CompareFormula method so that I could make a test.
-
Dineshkumar.S 456 Reputation points
2023-03-01T03:40:02.66+00:00 We need to compare the formula of a particular cell in an excel sheet with the formula of an another excel sheet this is the process
let me give the compare formula code for your reference.private bool CompareFormula(string answerPath, out bool isCorrect, out string strResult) { isCorrect = true; strResult = string.Empty; if (Params == null || Params.Count == 0 || Params[0].Value == null || Params[1].Value == null) return false; try { using (SpreadsheetDocument doc = SpreadsheetDocument.Open( answerPath, false)) { WorkbookPart workbookPart = doc.WorkbookPart; if (workbookPart != null) { var sheet = workbookPart .Workbook .Descendants<Sheet>() .Where(s => s.Name == Params[3].Value.ToString()) .FirstOrDefault(); var worksheetPart = (WorksheetPart)(workbookPart.GetPartById(sheet.Id)); var cell = worksheetPart .Worksheet .Descendants<Cell>() .Where(c => c.CellReference == Params[0].Value.ToString()) .FirstOrDefault(); var ansFormula = cell.CellFormula?.Text ?? ""; if (!Equals(ansFormula, Params[1].Value.ToString())) { isCorrect = false; strResult = "In cell " + Params[0].Value.ToString().ToUpper() + " you entered the formula: " + ansFormula + " but expected formula is: " + Params[1].Value.ToString().ToUpper(); } } } return true; } catch (Exception ex) { Logger.Do(EventLog.Error, "Exception at CompareCellFormula", ex.ToString()); return WinForms.ErrorMsgBox("evaluating your excel file."); } } static bool Equals(string formula1, string formula2) { var strings1 = GetStringMatches(formula1); var strings2 = GetStringMatches(formula2); if (strings1.Count != strings2.Count) return false; return strings1.Zip(strings2, (a, b) => new { a, b }).All(x => x.a.ToString() == x.b.ToString()) && Sanitize(formula1).Equals(Sanitize(formula2), StringComparison.CurrentCultureIgnoreCase); } static string Sanitize(string formula) { //should not trim whitespaces initially because ' =SUM(...' is not formula like '=SUM(...' return formula .TrimStart('=') .Replace(" ", "") .Replace("\t", "") .Replace(Environment.NewLine, ""); } static List<Match> GetStringMatches(string formula) { return Regex.Matches(formula, "\".*?\"").Cast<Match>().ToList(); } } -
Jack J Jun 25,296 Reputation points
2023-03-01T06:16:31.4766667+00:00 @Dineshkumar.S, thanks for the code providing, based on my test, I could use your
CompareFormulamethod to compare two Formulas successfully. According to your error, it seems that it is related to your dll reference. How do you add the DocumentFormat.OpenXml in your project? I add the nuget-package DocumentFormat.OpenXml in my project. BTW, what is your current project type? My tested project is an console app(.NET Framework 4.8). -
Dineshkumar.S 456 Reputation points
2023-03-01T06:39:49.0266667+00:00 I am unable to view the last comment can you please post it again
-
Dineshkumar.S 456 Reputation points
2023-03-01T06:48:09.3733333+00:00 My current project is windows forms (.net framework 4.8) and i have added the DocumentFormat.OpenXml in my project through the nuget package only but it is already available in my project but i just tried of updating it to the latest version but after that also i am having the same error
refer the screenshootsso is there anything i need to add or else any dependencies because dependencies also I have checked there is nothing add POV I suspect the following code creating an issue can please give me solution to solve this issue. Thanks in advance
using (SpreadsheetDocument doc = SpreadsheetDocument.Open( answerPath, false)) -
Jack J Jun 25,296 Reputation points
2023-03-01T07:27:17.6433333+00:00 @Dineshkumar.S, I also agree with you that the code you posted causes the exception. After checking, I find that you did not use the latest version of the package. If you updated the package to the latest, will the error still appear?
-
Dineshkumar.S 456 Reputation points
2023-03-01T07:36:02.7633333+00:00 yes after updating also the error still appears for me
Refer the screenshot -
Dineshkumar.S 456 Reputation points
2023-03-01T12:23:08.53+00:00 Any solution ??
-
Jack J Jun 25,296 Reputation points
2023-03-02T06:07:50.49+00:00 @Dineshkumar.S, based on my further research and test, I still could not reproduce your problem or find the solution. It may be an issue about the DocumentFormat.OpenXml. I recommend that you could submit an issue in their Github.
Sign in to comment