SpreadJS Documentation
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.
Gets delimited text from a range.
Syntax
var instance = new GcSpread.Sheets.Sheet(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;

Parameters

row
The start row.
column
The start column.
rowCount
The row count.
columnCount
The column count.
rowDelimiter
The row delimiter that is appended to the end of the row.
columnDelimiter
The column delimiter that is appended to the end of the column.

Return Value

The text from the range with the specified delimiters.
Example
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.setRowCount(3);
    sheet1.setColumnCount(5);
    sheet1.setColumnHeaderAutoText(GcSpread.Sheets.HeaderAutoText.blank);
    sheet1.setRowHeaderAutoText(GcSpread.Sheets.HeaderAutoText.blank);
    sheet1.setText(0, 0, "Row1", GcSpread.Sheets.SheetArea.rowHeader);
    sheet1.setText(1, 0, "Row2", GcSpread.Sheets.SheetArea.rowHeader);
    sheet1.setText(2, 0, "Row3", GcSpread.Sheets.SheetArea.rowHeader);
    sheet1.setText(0, 0, "Column1", GcSpread.Sheets.SheetArea.colHeader);
    sheet1.setText(0, 1, "Column2", GcSpread.Sheets.SheetArea.colHeader);
    sheet1.setText(0, 2, "Column3", GcSpread.Sheets.SheetArea.colHeader);
    sheet1.setText(0, 3, "Column4", GcSpread.Sheets.SheetArea.colHeader);
    sheet1.setText(0, 4, "Column5", GcSpread.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.getSheet(1).setCsv(0, 0, window.CSVString, "\r", ",", GcSpread.Sheets.TextFileOpenFlags.None);
 });

//Add button controls to page
<input type="button" id="button1" value="button1"/>
<input type="button" id="button2" value="button2"/>
See Also

Reference

Sheet type
Importing and Exporting CSV Files

 

 


Copyright © GrapeCity, inc. All rights reserved.

Send comments on this topic.