Business Central telemetry – Exploring telemetry in Excel and using a template file

Two posts in a row. I’ve just shared a post on how to give access to an user that belongs to a different Azure Active Directory to somehow workaround the limitation of only being able to setup one Application Insights in the same environment. At LS Retail (an Aptos Company) I’ve been using telemetry to […]

Excel Buffer – Detect Excel’s Language

Dynamics NAV allows you to “easily” export information to an Excel file, via code, using the Excel Buffer table. To export a cell value as a formula, you may add and use the following function to your object: LOCAL EnterFormula(RowNo : Integer;ColumnNo : Integer;CellValue : Text[250];Bold : Boolean;UnderLine : Boolean;NumberFormat : Text[30]) ExcelBuf.INIT; ExcelBuf.VALIDATE(“Row No.”,RowNo); […]