SpreadJS Documentation
TextFileOpenFlags Enumeration
Specifies the import flags.
Members
MemberDescription
ImportFormulaImports formulas.
IncludeColumnHeaderIncludes column headers.
IncludeRowHeaderIncludes row headers.
NoneImports with no special options.
UnFormattedLeaves the data unformatted. The unformatted setting bypasses the IFormatter object in the CellStyleInfo object for the cell so the cell data is unformatted.
Example
This example uses the TextFileOpenFlags enumeration.
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"/>
Inheritance Hierarchy

Object
   GcSpread.Sheets.TextFileOpenFlags

See Also

Reference

GcSpread.Sheets Namespace
Importing and Exporting CSV Files

 

 


Copyright © GrapeCity, inc. All rights reserved.

Send comments on this topic.