Simple Import from Excel file to Ax 2012 Table 1)first insert data in excel file with req fields and data. 2) create table in AOT with fields(data types) 3)write the code in job static void ImportFromExcel(Args _args) { SysExcelApplication application; SysExcelWorkbooks workbooks; SysExcelWorkbook workbook; SysExcelWorksheets worksheets; SysExcelWorksheet worksheet; SysExcelCells cells; COMVariantType type; DLSTesTable dlsTestTable; // write the table names FileName filename; Dialog dialog = new Dialog(); DialogField dialogField; DialogField _file; int row =1; int col; Name name; Address address; int idnumber; ; //Prompt to import excel dialog = new Dialog("Please select the file to load"); dialog.addText("Select file:"); _file = dialog.addField(ExtendedTypeStr("FilenameOpen")); dialog.run(); if (dialog....
Posts
Showing posts from June, 2018