Using NAV 2016 . I have created a processing report that pulls and calculate data based on Date filter from multiple tables and companies in NAV. The report sends the results to Excel using the Excel Buffer table. The user will build charts in the Worksheet created then he or she will periodically run the processing report to update the existing data in that Worksheet without having to recreate the charts every time. I need a way to Clear the data in the worksheet before sending the updating data. I see a code in the Excel Buffer table:
XlWrkSht.Range('A3:P40').ClearContents;
I'm not sure how to use the DotNet variables like XlWrkBk and XlWrkSht inorder to use the above line of code .
Can you please help?