复制代码 代码如下:
exceloperation = function(){
this.oxl = null;
this.owb = null;
this.osheet = null;
this.xlsrowcount = 0; //总记录数
this.excelfilename = null;
this.currentrow = 2; //当前行
/**
* 得到excel表格中的总记录数
*/
this.getrowcount = function(){
//osheet.range(c1).sort(osheet.columns(c),xlascending);
var rowscount = this.osheet.usedrange.cells.rows.count;
return rowscount;
}
/**
* 按指定的列进行排序
* @param column 列名，如c
*/
this.sort = function(column){
var xlascending = 1;
var xlyes = 1;
var xlsortrows=1;
var xlpinyin= 1;
var xlsortnormal =1;
this.osheet.usedrange.sort(this.osheet.columns(column),
xlascending,null,null,null,null,null,xlyes,null,null,
xlsortrows,xlpinyin,xlsortnormal,null,null);
}
/**
* 打开一个excel
*/
this.openexcel = function(filename){
this.filename = filename;
if(this.filename){
try{
this.oxl = new activexobject(excel.application);
this.owb = this.oxl.workbooks.open(filename);
//e:\\join.xls
this.owb.worksheets(1).select();
this.osheet = this.owb.activesheet;
this.xlsrowcount = this.getrowcount();
}catch(e){
if(this.oxl)
this.closeexcel();
ext.msg.show({
title : '错误提示',
msg : '请检查您的系统以下几方面的设置：1,'+
'是否正确安装了office中的excel；2,正确设
置您的ie浏览器('+
'工具->internet选项->安全->internet->自定
义级别->'+
'启用“对没有标记为安全的activex控件...”
);3,数据文件是否被删除',
buttons : ext.msg.ok,
icon : ext.msg.error
});
return false;
}
}else{
ext.msg.show({
title : '错误提示',
msg : '请选择要导入的源数据文件!',
buttons : ext.msg.ok,
icon : ext.msg.error
});
return false;
}
return this.osheet;
}
/**
* 读取指定单元格的数据，
*/
this.readdata = function(row,col){
var data = this.osheet.cells(row,col).value;
if(typeof data == 'undefined')
return '';
else
return data;
}
/**
* 向指定单元格写入数据
*/
this.writedata = function(row,col,data){
this.osheet.cells(row,col) = data
}
/**
* 关闭excel
*/
this.closeexcel = function(){
this.oxl.displayalerts = false;
this.oxl.quit();
this.oxl = null;
this.owb=null;
this.osheet=null;
collectgarbage();
}
}