Excel Buffer import: NAV removes leading zeroes of code fields

Business Central/NAV Developers Forum
6

Hi Erik,

I tested on standard Excel Buffer table, it imports successfully [:O] (“Cell Value as Text” contains 001, 002 …):

WITH lRec_ExcelBuffer DO BEGIN
lTxt_FileName := lCoU_ComDlg.OpenFile(‘Test’, ‘’, 2{=Excel}, ‘’, 0{=Open});
lTxt_SheetName := SelectSheetsName(lTxt_FileName);

IF (lTxt_FileName = ‘’) OR (lTxt_SheetName = ‘’) THEN
EXIT;

RESET;
DELETEALL;
OpenBook(lTxt_FileName, lTxt_SheetName);
ReadSheet();
END;
CU 50099 - Test Import from Excel.fob (3.09 KB)