Javascript 或 Flash 导出至 CSVExcel

使用Javascript或Flash导出至CSV/Excel

javascript
var employees = [
  { name: "张三", age: 25, salary: 5000 },
  { name: "李四", age: 30, salary: 6000 },
  { name: "王五", age: 35, salary: 7000 }
];

javascript
function exportToCsv(filename, rows) {
  var csvContent = "data:text/csv;charset=utf-8,";
  rows.forEach(function(row) {
    var rowData = Object.values(row).join(",");
    csvContent += rowData + "\r\n";
  });
  var encodedUri = encodeURI(csvContent);
  var link = document.createElement("a");
  link.setAttribute("href", encodedUri);
  link.setAttribute("download", filename);
  document.body.appendChild(link);
  link.click();
}

javascript
exportToCsv("employees.csv", employees);

actionscript
import com.as3xls.xls.ExcelFile;
import com.as3xls.xls.Sheet;
var employees:Array = [
  ["姓名", "年龄", "工资"],
  ["张三", 25, 5000],
  ["李四", 30, 6000],
  ["王五", 35, 7000]
];
var excelFile:ExcelFile = new ExcelFile();
var sheet:Sheet = new Sheet();
sheet.resize(4, 3);
for (var i:int = 0; i < employees.length; i++) {
  for (var j:int = 0; j < employees[i].length; j++) {
    sheet.setCell(i, j, employees[i][j]);
  }
}
excelFile.sheets.addItem(sheet);
var bytes:ByteArray = excelFile.saveToByteArray();
var file:FileReference = new FileReference();
file.save(bytes, "employees.xls");