Posts

Showing posts from June, 2018
Image
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....