How to read Excel comment and import into NAV table?

(0) Share

Report

Posted on by LouisaLukHKG

Dear Experts,

Do anyone have idea on how to get Excel comment from Excel sheets so that I can import those text into NAV tables? Is it possible to do through Microsoft.Dynamics.Nav.OpenXml? Or, should I use Microsoft.Office.Interop.Excel.Worksheet.'Microsoft.Office.Interop.Excel?

Thanks for any comment!

Louisa

*This post is locked for comments

All responses (3)

Answers (0)

mmv 11,467 on at

Like (0)

Report

RE: How to read Excel comment and import into NAV table?

Hi Louisa,

Could you verify the solution?

Best Regards,

MMV
Suggested answer

Suresh Kulla 44,614 on at

Like (1)

Report
RE: How to read Excel comment and import into NAV table?

To read comments you may have to use Microsoft.Office.Interop.Excel and convert the below code into C/AL

var application = new Excel.Application(); var workbook = application.Workbooks.Open(@"C:\test with comments.xlsx"); Excel.Worksheet worksheet = workbook.Sheets[1]; Excel.Range range = worksheet.Cells[1, 1]; //Here is your comment as a string var myComment = range.Comment.Text();
Suggested answer

Mohana Yadav 60,155 Super User 2025 Season 1 on at

Like (0)

Report

RE: How to read Excel comment and import into NAV table?

Please check Report 81 - import budget from Excel and Excel Buffer table (370), they know how to read the data from excel