EPPLUS adding comment results error opening excel file

Question

I would like to add comments at one cell, So.. I did:

... 
ExcelPackage package = new ExcelPackage(new MemoryStream());
var ws = package.WorkBook.WorkSheet[1];
ws.Cells[1, 1].AddComment("Lot Price: $12,000", "");
... 
package.SaveAs(new FileInfo("fileout.xlsx"));
package.Dispose();

When try open the resulted "fileout.xlsx", it showed a dialog box saying to recover as much as possible... Then the recovered fileout.xlsx displays errors:

"Removed Part: /xl/comments1.xml part with XML error. (Comments) Load error. Line 5, column 0. Removed Part: /xl/comments5.xml part with XML error. (Comments) Load error. Line 5, column 24."

It appears that EPPlus produced a wrong format xml when there are comments. I would like to share my solutions for this problem:

I just added a NON-BLANK header line for the comments, such as "REF" here:

ws.Cells[1, 1].AddComment("Lot Price: $12,000", "REF");

I hope someone might be helped by this.

Thank you, this has helped me too. You should post your solution as an answer and accept that, if you can. — Alex Mazzariol
– Alex Mazzariol, Commented Mar 21, 2017 at 16:39

Pan · Accepted Answer · 2017-07-29 21:18:23Z

8

Some one suggested to post it as answer. Here it is:

The problem disappears if like this: I just added a NON-BLANK header line for the comments, such as "REF" here:

ws.Cells[1, 1].AddComment("Lot Price: $12,000", "REF");

I hope someone might be helped by this.

answered Jul 29, 2017 at 21:18

Pan

1712 silver badges6 bronze badges

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

Comments

Xin · Accepted Answer · 2020-06-24 05:06:57Z

1

I see the same problem.for my instance,I use function AddComent with empty value in second parameter. at first ,my code like this:

ExcelRange range = newsheet.SelectedRange[1, 1];
newExcel.SetBGColor(range, Color.Red);
range.AddComment("no data", "");

then I change the last code like this:

range.AddComment("no data", "some body");

It works

answered Jun 24, 2020 at 5:06

Xin

794 bronze badges

Comments

labilbe · Accepted Answer · 2023-09-27 10:53:32Z

1

You can add a space " " it works too.

answered Sep 27, 2023 at 10:53

labilbe

3,5552 gold badges31 silver badges36 bronze badges

Collectives™ on Stack Overflow

EPPLUS adding comment results error opening excel file

3 Answers 3

Comments

Comments

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

3 Answers 3

Comments

Comments

Comments

Your Answer

Sign up or log in

Post as a guest

Related