SpreadJS 14
GC.Spread.Sheets Namespace / Worksheet type / setCsv Method
The start row.
The start column.
The delimited text.
The row delimiter.
The column delimiter.
In This Topic
    setCsv Method
    In This Topic
    Sets delimited text (CSV) in the sheet.
    Syntax
    var instance = new GC.Spread.Sheets.Worksheet(name);
    var value; // Type: any
    value = instance.setCsv(row, column, text, rowDelimiter, columnDelimiter);
    function setCsv( 
       row : number,
       column : number,
       text : string,
       rowDelimiter : string,
       columnDelimiter : string
    ) : any;

    Parameters

    row
    The start row.
    column
    The start column.
    text
    The delimited text.
    rowDelimiter
    The row delimiter.
    columnDelimiter
    The column delimiter.
    Example
    This example opens a CSV file.
    var 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");
    var d = new Date();
    d.setFullYear(2006, 8, 1);
    sheet1.setValue(0, 1, d);
    d.setFullYear(2006, 8, 2);
    sheet1.setValue(1, 1, d);
    d.setFullYear(2006, 8, 3);
    sheet1.setValue(2, 1, d);
    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", ",");
        alert(CSVString);
    });
    
    $("#button2").click(function () {
        //Load the saved csv file on the second sheet.
        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"/>
    See Also