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

Difference between revisions of "ExcelIo"

From Axaptapedia
Jump to: navigation, search
(New page: ==Purpose== To read an Excel file in way mimicking CommaIo. The writeExp method is not implemented. ==Download== [http://www.axaptapedia.com/Image:Class_ExcelIo.xpo XPO file for Axapta ...)
 
Line 5: Line 5:
  
 
==Download==
 
==Download==
[http://www.axaptapedia.com/Image:Class_ExcelIo.xpo XPO file for Axapta 3.0 and up]
+
[[Image:Class_ExcelIo.xpo]] XPO file for Axapta 3.0 and up
[[Image:Class_ExcelIo.xpo]]
+
  
 +
==How to use==
 +
Just use ExcelIo as a replacement for CommaIo
 +
 +
<xpp>
 +
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));
 +
    }
 +
}
 +
</xpp>
  
 
[[Category:Development tools]]
 
[[Category:Development tools]]

Revision as of 09:25, 28 July 2011

Purpose

To read an Excel file in way mimicking CommaIo.

The writeExp method is not implemented.

Download

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

How to use

Just use ExcelIo as a replacement for CommaIo

<xpp> 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));
   }

} </xpp>