Hey all,
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[0].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
//workbook.Open(path);
Cells cells = workbook.Worksheets[0].Cells;
// Reads Comments
string commentInA1 = "";
Comments comments = workbook.Worksheets[0].Comments;
if (comments["T8"] != null)
commentInA1 = comments["T8"].Note;
else
commentInA1 = "NONE";