SpreadJS 产品帮助手册
Page tree
Skip to end of metadata
Go to start of metadata

你可以导入或者导出逗号分隔符文件（csv）。

你可以指定是否导入未格式化的标题。

使用 getCsv 方法来将数据存为逗号分隔符文件。

使用 setCsv 方法来导入逗号分隔符文件。

使用 TextFileOpenFlags 来设置导入选项。

示例代码

以下代码可以保存或者读取 CSV 文件。

点击 button 1 来保存为 CSV 文件，点击 button 2 来载入一个 CSV 文件。

JavaScript
var sheet1;
window.onload = function() {
var spread = new GC.Spread.Sheets.Workbook(document.getElementById('ss'), {sheetCount: 1});
       
sheet1 = spread.getSheet(0);
sheet1.setRowCount(3);
sheet1.setColumnCount(5);
sheet1.options.colHeaderAutoText = GC.Spread.Sheets.HeaderAutoText.blank;
sheet1.options.rowHeaderAutoText = GC.Spread.Sheets.HeaderAutoText.blank;
sheet1.setText(0, 0, "Row1", GC.Spread.Sheets.SheetArea.rowHeader);
sheet1.setText(1, 0, "Row2", GC.Spread.Sheets.SheetArea.rowHeader);
sheet1.setText(2, 0, "Row3", GC.Spread.Sheets.SheetArea.rowHeader);
sheet1.setText(0, 0, "Column1", GC.Spread.Sheets.SheetArea.colHeader);
sheet1.setText(0, 1, "Column2", GC.Spread.Sheets.SheetArea.colHeader);
sheet1.setText(0, 2, "Column3", GC.Spread.Sheets.SheetArea.colHeader);
sheet1.setText(0, 3, "Column4", GC.Spread.Sheets.SheetArea.colHeader);
sheet1.setText(0, 4, "Column5", GC.Spread.Sheets.SheetArea.colHeader);
sheet1.setText(0, 0, "SPREAD-1");
sheet1.setText(1, 0, "SPREAD-2");
sheet1.setText(2, 0, "SPREAD-3");
sheet1.setValue(0, 1, new Date().setFullYear(2006, 8, 1));
sheet1.setValue(1, 1, new Date().setFullYear(2006, 8, 2));
sheet1.setValue(2, 1, new Date().setFullYear(2006, 8, 3));
sheet1.setColumnWidth(1, 90);
sheet1.setValue(0, 2, 123.45);
sheet1.setValue(1, 2, 99.9999);
sheet1.setValue(2, 2, 100);
sheet1.setValue(0, 3, true);
sheet1.setValue(1, 3, false);
sheet1.setValue(2, 3, true);
sheet1.setValue(0, 4, "aaa");
sheet1.setValue(1, 4, "bbb");
sheet1.setValue(2, 4, "ccc");
           
$("#button1").click(function () {
    //Save all data on the first sheet in a csv format.
    window.CSVString = spread.getSheet(0).getCsv(0, 0, spread.getSheet(0).getRowCount(), spread.getSheet(0).getColumnCount(), "\r", ",");
});
$("#button2").click(function () {
    //Load the saved csv file on the second sheet.
    spread.addSheet(1, new GC.Spread.Sheets.Worksheet());
    spread.getSheet(1).setCsv(0, 0, window.CSVString, "\r", ",");
});
};

//Add button controls to page
<input type="button" id="button1" value="button1"/>
<input type="button" id="button2" value="button2"/>
  • No labels