使用开源项目as3xlsUTF8.swc。下载地址:打开链接
private var sheet:Sheet = new Sheet();
/**
* 导出到Excel
*/
protected function exportToExcel(e:MouseEvent):void
{
//在前台生成Excel
var excelFile:ExcelFile = new ExcelFile();
var arr:Array = iGrid.selectedItems as Array;
excelFile.sheets.addItem(generateSheet1());
for(var i:int=0; i<arr.length;++i)
{
var obj:Object = arr[i];
var j:int = 0;
for(var key:String in obj)
{
excelFile.sheets.addItem(generateSheet(i,j+8,obj[key]));
++j;
}
}
var arrBytes:ByteArray = excelFile.saveToByteArray();
var file:FileReference = new FileReference();
try{
file.save(arrBytes,"我的日报明细.xls");
}catch(e:Error)
{
Alert.show("导出失败,详情如下: "+e.toString(),"系统提示");
}
}
/**
* 生产Excel Sheet表
*/
protected function generateSheet(i:int,j:int,o:Object):Sheet
{
if(!sheet){
sheet = new Sheet();
sheet.resize(10,10);
}
sheet.setCell(i,j,String(o));
return sheet;
}