SpreadJS 14
GC.Spread.Sheets Namespace / Worksheet type / getCsv Method
The start row.
The start column.
The row count.
The column count.
The row delimiter that is appended to the end of the row.
The column delimiter that is appended to the end of the column.
In This Topic
    getCsv Method
    In This Topic
    Gets delimited text from a range.
    var instance = new GC.Spread.Sheets.Worksheet(name);
    var value; // Type: string
    value = instance.getCsv(row, column, rowCount, columnCount, rowDelimiter, columnDelimiter);
    function getCsv( 
       row : number,
       column : number,
       rowCount : number,
       columnCount : number,
       rowDelimiter : string,
       columnDelimiter : string
    ) : string;


    The start row.
    The start column.
    The row count.
    The column count.
    The row delimiter that is appended to the end of the row.
    The column delimiter that is appended to the end of the column.

    Return Value

    The text from the range with the specified delimiters.
    This example adds data to a sheet, then saves it to a CSV file, then loads it in the second sheet.
    var sheet1 = spread.getSheet(0);
    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", ",");
    $("#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