getCsv Method

Gets delimited text from a range.

Syntax

Javascript (Usage)
Javascript (Specification)

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.

Javascript

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"/>

Reference

Sheet type
Importing and Exporting CSV Files