ExcelIo

Purpose
To read an Excel file in way mimicking CommaIo.

The writeExp method is not implemented.

Download
XPO file for Axapta 3.0 and up.

zipped XPO file for Axapta 2012 and up.

How to use
Just use ExcelIo as a replacement for CommaIo.

static void ExcelIoTest(Args _args) {   ExcelIo io; #Excel dialogField dialogFilename; Dialog dialog = new Dialog("Excel Upload"); container con; ;   dialogFilename = dialog.addField(typeId(FilenameOpen)); dialog.filenameLookupTitle("Upload from Excel"); dialog.filenameLookupFilter(["@SYS28576",#XLSX, "@SYS28576",#XLS]); if (!dialog.run) return; io = new ExcelIo(dialogFilename.value, 'r'); setprefix("Excel Import"); while (io.status == IO_Status::Ok) {       con = io.read; info(con2str(con)); }   io.close; //To quit Excel }