javascript操作EXECL
来源:互联网 发布:淘宝api 获取商品信息 编辑:程序博客网 时间:2024/05/09 06:07
<script language="javascript">
function jStartExcel() {
var xls = new ActiveXObject ( "Excel.Application" );
xls.visible = true;
var newBook = xls.Workbooks.Add;
newBook.Worksheets.Add;
newBook.Worksheets(1).Activate;
xls.ActiveWorkBook.ActiveSheet.PageSetup.Orientation = 2;
xls.ActiveWorkBook.ActiveSheet.PageSetup.PaperSize = 5;
newBook.Worksheets(1).Columns("A").columnwidth=50;
newBook.Worksheets(1).Columns("A").WrapText = true;
newBook.Worksheets(1).Columns("B").columnwidth=50;
newBook.Worksheets(1).Columns("B").WrapText = true;
newBook.Worksheets(1).Range("A1:B1000").NumberFormat = "0";
newBook.Worksheets(1).Range("A1:B1000").HorizontalAlignment = -4131;
newBook.Worksheets(1).Cells(1,1).Interior.ColorIndex="15";
newBook.Worksheets(1).Cells(1,1).value="First Column, First Cell";
newBook.Worksheets(1).Cells(2,1).value="First Column, Second Cell";
newBook.Worksheets(1).Cells(1,2).value="Second Column, First Cell";
newBook.Worksheets(1).Cells(2,2).value="Second Column, Second Cell";
newBook.Worksheets(1).Name="My First WorkSheet";
}
</script>
function jStartExcel() {
var xls = new ActiveXObject ( "Excel.Application" );
xls.visible = true;
var newBook = xls.Workbooks.Add;
newBook.Worksheets.Add;
newBook.Worksheets(1).Activate;
xls.ActiveWorkBook.ActiveSheet.PageSetup.Orientation = 2;
xls.ActiveWorkBook.ActiveSheet.PageSetup.PaperSize = 5;
newBook.Worksheets(1).Columns("A").columnwidth=50;
newBook.Worksheets(1).Columns("A").WrapText = true;
newBook.Worksheets(1).Columns("B").columnwidth=50;
newBook.Worksheets(1).Columns("B").WrapText = true;
newBook.Worksheets(1).Range("A1:B1000").NumberFormat = "0";
newBook.Worksheets(1).Range("A1:B1000").HorizontalAlignment = -4131;
newBook.Worksheets(1).Cells(1,1).Interior.ColorIndex="15";
newBook.Worksheets(1).Cells(1,1).value="First Column, First Cell";
newBook.Worksheets(1).Cells(2,1).value="First Column, Second Cell";
newBook.Worksheets(1).Cells(1,2).value="Second Column, First Cell";
newBook.Worksheets(1).Cells(2,2).value="Second Column, Second Cell";
newBook.Worksheets(1).Name="My First WorkSheet";
}
</script>
- javascript操作EXECL
- 操作Execl
- 操作Execl
- 操作EXECL
- Execl 操作
- 使用javascript导如到EXECL
- jsp操作Execl分析
- JAVA--操作Execl
- jsp操作Execl分析
- VB.NET 操作execl
- asp对execl操作
- C#操作Execl
- 通过jxl操作execl
- VB 操作 Execl
- C#操作Execl
- Execl文件读写操作
- JAVA操作execl
- Execl相关操作
- 第16课
- 一条SQL删除所有表中数据
- 第15课多线程与网络编程
- 比较复杂的动态SQL语句功能一例[不太懂,好好研究一下]
- vc笔记第十四课(续)
- javascript操作EXECL
- 第14课 网络编程
- 如何使用with...as...构造SQL语句
- 自定义 DataGridViewColumn 类:DataGridViewComboBoxNewColumn
- 第13课 文档与串行化
- 第 12 课
- 数据库设计三大范式应用实例剖析
- 第九课 第十课 第十一课
- insertAdjacentHTML和 insertAdjacentText方法