I noticed that when using the LoadData() method to read a document that the comments in the worksheet are not loaded into the workbook.Worksheet.Comments object.
However when using the .Open() method they are.
My logic is being run from within a webservice so I cannot use the Open() method.. I am converting a byte into a MemoryStream and then using the LoadData() method.
I need to also be able to read comments in the excel file. Are there any fixes or work arounds for this?
Thanks in advance....
string path = @"C:\test.xls";
Workbook workbook = new Workbook();
workbook.LoadData(path); // LoadData does not include Comments data
Cells cells = workbook.Worksheets.Cells;
// Reads Comments
string commentInA1 = "";
Comments comments = workbook.Worksheets.Comments;
if (comments["T8"] != null)
commentInA1 = comments["T8"].Note;
commentInA1 = "NONE";