Citação de Kindrazki em 15 de fevereiro de 2017, 17:46

Leitura de Planilha Excel

Aba Script:
[code]
set run = ""+execScript.addDataList(bdo.util.DataListUtil.createDataList([ 'id', 'descricao', 'valor', 'data' ] as String[],
[ java.sql.Types.INTEGER, java.sql.Types.VARCHAR, java.sql.Types.DECIMAL, java.sql.Types.DATE ] as int[]), 'dataList1');

set run = new bdo.util.XLSXReader(execScript)
.open('$v{dirAppResources}/import/planilha-teste.xlsx')
.getSheet('Dados1')
.setCurrentRow(1)
.setDestDataList('dataList1')
.readToDataList([ 0, 1, 2, 3 ] as int[], [ 'id', 'descricao', 'valor', 'data' ] as String[])
.readCellToVar(0, 6, 'valInt')
.readCellToVar(0, 7, 'valDec')
.readCellToVar(0, 8, 'valDate')
.readCellToVar(0, 9, 'valDefault', '0')
.close();
[/code]

Aba Notificação:
$include{script-notif-cabecalho, "Leitura XLS", ""}include

Valor Inteiro: ~~~<br> -> $v{valInt};
Valor Decimal: ~~~<br> -> $v{valDec};
Valor Date: ~~~<br> -> $v{valDate};
Valor Default: ~~~<br> -> $v{valDefault};
<br>

@table -> Id. -> $c{id[a]} r;
Descrição -> $c{descricao[a]} l;
Valor -> $c{valor[a]"dec:###,###,##0.00"} r;
Data -> $c{data[a]"date:dd/MM/yyyy"} l;
table@

$include{script-notif-rodape}include

[/code]