Genexus

Examples

In the following example we generate an excel document using POI.
&excel is ExcelDocument Type.

Note: Place the "UseAutomation" before the "Open" command line.

 Event "Excel"    &ExcelDocument.UseAutomation = 0     &ExcelDocument.Open(&File)       If &ExcelDocument.ErrCode <> 0         msg(&ExcelDocument.ErrDescription)     Else         &ExcelDocument.Clear()               &ExcelDocument.Cells(1,1).Text = 'Customers list'          &ExcelDocument.Cells(1,1).Bold = 1         &ExcelDocument.Cells(1,1).Color = 54         &ExcelDocument.Cells(1,1).Size = 10                  &ExcelDocument.Cells(3,1).Text = 'Customer Id'         &ExcelDocument.Cells(3,1).Italic = 1         &ExcelDocument.Cells(3,1).Bold = 1              &row = 4         &col = 1         For Each Line in Grid                      &ExcelDocument.Cells(&row,&col).Number = CustomerId                 &ExcelDocument.Cells(&row,&col).Color = 3                 &row += 1                           Endfor          &ExcelDocument.Save()      Endif EndEvent   

.NET

.NET generates only Excel files
See this SAC: http://www2.gxtechnical.com/portal/hgxpp001.aspx?15,4,61,O,S,0,,19780

    Apache/Jakarta POI: The necessary files can be downloaded from here

    ExcelLite DLL: The necessary file - GemBox.Spreadsheet.dll - is available from an installation of GemBox's spreadsheet software

NOTE: You need to copy the Jakarta DLL files or ExcelLite files to your kbase DATA00x\bin directory. 

Managing excel documents - common issues

Espero te sea de utilidad.

saludos, Armin