js中excel的用法

最新推荐文章于 2024-06-15 09:17:48 发布

iteye_16348

最新推荐文章于 2024-06-15 09:17:48 发布

阅读量468

点赞数

分类专栏： javascript 文章标签： Excel JavaScript 浏览器 PHP Blog ViewUI

本文链接：https://blog.csdn.net/iteye_16348/article/details/81690498

版权

javascript 专栏收录该内容

63 篇文章 0 订阅

订阅专栏

[url=http://www.zhubajie.com/task/?welcome=1523583]有困难，找猪八戒[/url]
转载自：
[url]http://hi.baidu.com/lionfoo/blog/item/757e173321f19efd1a4cffbd.html[/url]
另外：查看这个资源也不错
[url]http://kuangbaoxu.iteye.com/blog/193311[/url]

-----------------------------
my addition:
1、设置日期年月日
oSheet.Cells(x,y).NumberFormat = 'yyyy-m-d';
[url]http://stackoverflow.com/questions/380100/how-to-customize-date-format-when-creating-excel-cells-through-javascript-active[/url]

2、设置单元格内容根据内容大小显示
XlSheet.columns.autofit;
[url]http://lists.evolt.org/pipermail/javascript/2006-November/011477.html[/url]
[url]http://www.webdeveloper.com/forum/showthread.php?t=187527[/url]

-------------------------------

事例1

<SCRIPT LANGUAGE='JavaScript'>  
<!--  
var xlCenter=-4108;
var xlbottom=-4107;
var xlRight=-4152;
var oSheet;
var oActiveSheet;
var oApplication;
try { //初始化Excel对象
    oApplication     = new ActiveXObject ( 'Excel.Application' );
    }catch(e){
alert('您必须安装Excel电子表格软件，同时浏览器须使用“ActiveX 控件”！');
return '';
}       
oApplication.visible = true;       
var xlBook = oApplication.Workbooks.Add;
oActiveSheet = xlBook.Worksheets(1);
oActiveSheet.Rows('1:1').RowHeight = 30;//设置行高
oActiveSheet.Columns('A:A').ColumnWidth = 8;//设置列宽
oActiveSheet.Cells(4,1).FormulaR1C1='日   期'; //设置单元格的内容第4行第1列
oActiveSheet.Range('A2:G2').Select();//单元格选择
//另外一种高级的选择方法
oActiveSheet.Range(oActiveSheet.cells(5,3),oActiveSheet.Cells(6,4)).Select;
oApplication.Selection.Font.Size=15;//设置文字格式
oApplication.Selection.Font.bold= true
oApplication.Selection.Font.Name='宋体';
oApplication.Selection.Merge();//合并选取的单元格
//设置选取单元格的垂直对齐和水平对齐
oApplication.Selection.HorizontalAlignment = xlCenter;
oApplication.Selection.VerticalAlignment = xlCenter;
//注意，对selection的操作都适用于cells
oApplication.Selection.WrapText=true;//设置自动换行
//-->
</SCRIPT>

事例2 使用js操作本地或远程的excel

<html><head><title>Excel Test</title>
<script language="javascript">
function readEx() {
var ExcelSheet ;
var wb;
try {
   ExcelSheet      = new ActiveXObject("Excel.Application");
   alert(ExcelSheet .Version);
   wb = ExcelSheet.Workbooks.open("http://10.1.1.143:8080/canon_sample/data/test.xls");
   var objsheet =   wb.Worksheets("Sheet1");
   var v = objsheet.cells(1,1);
   alert("cells(1,1) = " + v);
   ExcelSheet.Save();
// read end   使EXCEL窗口可见
   ExcelSheet.Visible = true;
} catch(e) {
if (ExcelSheet != undefined){
   alert('Error happened : ' + e);
   ExcelSheet.Quit();
}
   return '';
}
}
function writeEx() {
var ExcelSheet ;
var wb;
try {
   ExcelSheet      = new ActiveXObject("Excel.Application");
   ExcelSheet.Visible = true;
   ExcelSheet.Workbooks.Add();
   ExcelSheet.ActiveSheet.Cells(1,1).Value = "This is column A, row 1";
   ExcelSheet.SaveAs("c:\\TEST.XLS");
   ExcelSheet.Quit();
}
catch(e) {
     if (ExcelSheet != undefined){
   alert('Error happened : ' + e);
   ExcelSheet.Quit();
}
   return '';
}
}
</script>
</head>
<body>
<b>
Excel Test
</b>
<br><br>
<input type="button" onclick="readEx();" value=" Read "/>
<input type="button" onclick="writeEx();" value=" Write "/>
</body>
</html>

事例3

xlsheet.Range( xlsheet.Cells(1,1),xlsheet.Cells(rowNum+1,7)).HorizontalAlignment =-4108;//居中
xlsheet.Range( xlsheet.Cells(1,1),xlsheet.Cells(1,7)).VerticalAlignment =-4108;
xlsheet.Range( xlsheet.Cells(2,1),xlsheet.Cells(rowNum+1,7)).Font.Size=10;
xlsheet.Range( xlsheet.Cells(2,1),xlsheet.Cells(rowNum+1,7)).Borders(3).Weight = 2; //设置左边距
xlsheet.Range( xlsheet.Cells(2,1),xlsheet.Cells(rowNum+1,7)).Borders(4).Weight = 2;//设置右边距
xlsheet.Range( xlsheet.Cells(2,1),xlsheet.Cells(rowNum+1,7)).Borders(1).Weight = 2;//设置顶边距
xlsheet.Range( xlsheet.Cells(2,1),xlsheet.Cells(rowNum+1,7)).Borders(2).Weight = 2;//设置底边距
//设置单元格内容自动换行 range.WrapText   =   true   ;
//设置单元格内容水平对齐方式
range.HorizontalAlignment   =   Excel.XlHAlign.xlHAlignCenter;
//设置单元格内容竖直堆砌方式
   range.VerticalAlignment=Excel.XlVAlign.xlVAlignCenter
   ange.WrapText   =   true;
   xlsheet.Rows(3).WrapText=true   自动换行
   xlsheet.Range(xlsheet.Cells(1,1),xlsheet.Cells(1,6)).Interior.ColorIndex=5;//设置底色为蓝色
   xlsheet.Range(xlsheet.Cells(1,1),xlsheet.Cells(1,6)).Font.ColorIndex=4;//设置字体色         
xlsheet.Rows(1). Interior .ColorIndex = 5 ;//设置底色为蓝色   设置背景色 Rows(1).Font.ColorIndex=4  
   <!--设置行高-->xlsheet.Rows(1).RowHeight = 30;
<!--设置字体 ws.Range(ws.Cells(i0+1,j0), ws.Cells(i0+1,j1)).Font.Size = 13 -->
   xlsheet.Rows(1).Font.Size=14;
// <!--设置字体 设置选定区的字体   xlsheet.Range(xlsheet.Cells(i0,j0), ws.Cells(i0,j0)).Font.Name = "黑体" -->
xlsheet.Rows(1).Font.Name="Verdana";
<!--设置列宽 xlsheet.Columns(2)=14;-->
xlsheet.Columns("A:D").ColumnWidth =18;
xls.UserControl = true;   //很重要,不能省略,不然会出问题 意思是excel交由用户控制

事例4

//拷贝
var elTable = document.getElementById("data_table");
var oRangeRef = document.body.createTextRange();
oRangeRef.moveToElementText( elTable );
oRangeRef.execCommand( "Copy" );

//粘贴
try{
var appExcel = new ActiveXObject( "Excel.Application" );
appExcel.Visible = true;
appExcel.Workbooks.Add().Worksheets.Item(1).Paste();
//appExcel = null;
}catch(e){
alert("使用此功能必须在浏览器中设置:Internet选项->安全->将本站加入“受信任的站点”。");
}

[url=http://www.zhubajie.com/task/?welcome=1523583]有困难，找猪八戒[/url]

iteye_16348

关注

0
点赞
踩
0

收藏

觉得还不错? 一键收藏
0
评论
js中excel的用法

[url=http://www.zhubajie.com/task/?welcome=1523583]有困难，找猪八戒[/url]转载自：[url]http://hi.baidu.com/lionfoo/blog/item/757e173321f19efd1a4cffbd.html[/url]另外：查看这个资源也不错[url]http://kuangbaoxu.iteye.com/...
复制链接

扫一扫

专栏目录