Axaptapedia is now maintained by AgileCadence For more information please click here.


From Axaptapedia
Revision as of 11:42, 8 January 2016 by JanKjeldsen (Talk | contribs)

(diff) ← Older revision | Latest revision (diff) | Newer revision → (diff)
Jump to: navigation, search


To read an Excel file in way mimicking CommaIo.

The writeExp method is not implemented.


File:Class ExcelIo.xpo XPO file for Axapta 3.0 and up.

File:Class 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;
   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 (!
   io = new ExcelIo(dialogFilename.value(), 'r');
   setprefix("Excel Import");
   while (io.status() == IO_Status::Ok)
       con =;
   io.close(); //To quit Excel