文件导入mdf文件

导入和导出CSV文件你可以导入或者导出逗号分隔符文件(csv).
你可以指定是否导入未格式化的标题.
使用方法来将数据存为逗号分隔符文件.
getCsv使用方法来导入逗号分隔符文件.
setCsv使用来设置导入选项.
TextFileOpenFlags示例代码以下代码可以保存或者读取CSV文件.
点击button1来保存为CSV文件,点击button2来载入一个CSV文件.
JavaScriptvarsheet1;window.
onload=function(){varspread=newGC.
Spread.
Sheets.
Workbook(document.
getElementById('ss'),{sheetCount:1});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");sheet1.
setValue(0,1,newDate().
setFullYear(2006,8,1));sheet1.
setValue(1,1,newDate().
setFullYear(2006,8,2));sheet1.
setValue(2,1,newDate().
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(){//Savealldataonthefirstsheetinacsvformat.
window.
CSVString=spread.
getSheet(0).
getCsv(0,0,spread.
getSheet(0).
getRowCount(),spread.
getSheet(0).
getColumnCount(),"\r",",");});$("#button2").
click(function(){//Loadthesavedcsvfileonthesecondsheet.
spread.
addSheet(1,newGC.
Spread.
Sheets.
Worksheet());spread.
getSheet(1).
setCsv(0,0,window.
CSVString,"\r",",");});};//Addbuttoncontrolstopage