javascript导出excel（可以导出表格线）

最新推荐文章于 2024-07-30 11:29:23 发布
最新推荐文章于 2024-07-30 11:29:23 发布
阅读量286 收藏 1
点赞数 1
分类专栏： 转载 javascript 文章标签： javascript ViewUI
版权声明：本文为博主原创文章，遵循 CC 4.0 BY-SA 版权协议，转载请附上原文出处链接和本声明。
本文链接：https://blog.csdn.net/sfSam/article/details/84465872
版权

<html>
    <head>
        <script language="javascript" type="text/javascript">
        </script>
        <script language="javascript" type="text/javascript">
            function MakeExcel(){
            var i,j;
                try {
                  var xls    = new ActiveXObject ( "Excel.Application" );
                 }
                catch(e) {
                     alert( "要打印该表，您必须安装Excel电子表格软件，同时浏览器须使用“ActiveX 控件”，您的浏览器须允许执行控件。 请点击【帮助】了解浏览器设置方法！");
                          return "";
                 }
           
                        xls.visible =true;  //设置excel为可见
           
                var xlBook = xls.Workbooks.Add;
                var xlsheet = xlBook.Worksheets(1);
                <!--合并-->
                  xlsheet.Range(xlsheet.Cells(1,1),xlsheet.Cells(1,7)).mergecells=true;
                  xlsheet.Range(xlsheet.Cells(1,1),xlsheet.Cells(1,7)).value="发卡记录";
                 //  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 = 25;
                <!--设置字体 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="黑体";
                <!--设置列宽 xlsheet.Columns(2)=14;-->
           
                xlsheet.Columns("A:D").ColumnWidth =18;
                 <!--设置显示字符而不是数字-->
                xlsheet.Columns(2).NumberFormatLocal="@";
                xlsheet.Columns(7).NumberFormatLocal="@";
           
           
                 //设置单元格内容自动换行 range.WrapText  =  true  ;
                 //设置单元格内容水平对齐方式 range.HorizontalAlignment  =  Excel.XlHAlign.xlHAlignCenter;//设置单元格内容竖直堆砌方式
                  //range.VerticalAlignment=Excel.XlVAlign.xlVAlignCenter
                //range.WrapText  =  true;  xlsheet.Rows(3).WrapText=true  自动换行
              
                //设置标题栏
           
                 xlsheet.Cells(2,1).Value="卡号";
                 xlsheet.Cells(2,2).Value="密码";
                 xlsheet.Cells(2,3).Value="计费方式";
                 xlsheet.Cells(2,4).Value="有效天数";
                 xlsheet.Cells(2,5).Value="金额";
                 xlsheet.Cells(2,6).Value="所属服务项目";
                   xlsheet.Cells(2,7).Value="发卡时间";
           
                 var oTable=document.all['fors:data'];
                 var rowNum=oTable.rows.length;
                 for(i=2;i<=rowNum;i++){
                 for (j=1;j<=7;j++){
            //html table类容写到excel
           
                   xlsheet.Cells(i+1,j).Value=oTable.rows(i-1).cells(j-1).innerHTML;
                        }
           
           
                }
                <!--   xlsheet.Range(xls.Cells(i+4,2),xls.Cells(rowNum,4)).Merge; -->
                // xlsheet.Range(xlsheet.Cells(i, 4), xlsheet.Cells(i-1, 6)).BorderAround , 4
                 // for(mn=1,mn<=6;mn++) .     xlsheet.Range(xlsheet.Cells(1, mn), xlsheet.Cells(i1, j)).Columns.AutoFit;
                  xlsheet.Columns.AutoFit;
                             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;//设置底边距
           
            
           
                  
                    xls.UserControl = true;  //很重要,不能省略,不然会出问题 意思是excel交由用户控制
                   xls=null;
                   xlBook=null;
                   xlsheet=null;
           
            }
           
            
           
           
        </script>
        <link href="css/styles3.css" rel="stylesheet" type="text/css"/>
        <title>ziyuanweihu</title>
    </head>
    <body>
        <form id="fors" method="post" action="/WebModule/admins/card/showcard.faces" enctype="application/x-www-form-urlencoded">
            <table border="0" cellpadding="0" cellspacing="0" width="100%">
                <tbody>
                    <tr>
                        <td class="middleLeft">
                        </td>
                        <td class="btstyle">
                            <table id="fors:sort" border="0" cellpadding="0" cellspacing="0" style="valign:center" width="100%">
                                <tbody>
                                    <tr>
                                        <td class="btstyle">
                                            <input type="button" name="fors:_id7" value="&#29983;&#25104;excel&#25991;&#20214;" οnclick="MakeExcel()"/><input type="submit" name="fors:_id8" value="&#36820;&#22238;" />
                                        </td>
                                    </tr>
                                </tbody>
                            </table>
                            <table id="fors:data" border="1" cellpadding="0" cellspacing="1" width="100%">
                                <thead>
                                    <tr>
                                        <th scope="col">
                                            <span id="fors:data:headerText1">&#21345;&#21495;</span>
                                        </th>
                                        <th scope="col">
                                            <span id="fors:data:headerText2">&#23494;&#30721;</span>
                                        </th>
                                        <th scope="col">
                                            <span id="fors:data:headerText3">&#35745;&#36153;&#26041;&#24335;</span>
                                        </th>
                                        <th scope="col">
                                            <span id="fors:data:headerText4">&#26377;&#25928;&#22825;&#25968;</span>
                                        </th>
                                        <th scope="col">
                                            &#37329;&#39069;
                                        </th>
                                        <th scope="col">
                                            <span id="fors:data:headerText6">&#25152;&#23646;&#26381;&#21153;&#39033;&#30446;</span>
                                        </th>
                                        <th scope="col">
                                            <span id="fors:data:headerText7">&#21457;&#21345;&#26102;&#38388;</span>
                                        </th>
                                    </tr>
                                </thead>
                                <tbody>
                                    <tr>
                                        <td>
                                            h000010010
                                        </td>
                                        <td>
                                            543860
                                        </td>
                                        <td>
                                            &#35745;&#28857;
                                        </td>
                                        <td>
                                        </td>
                                        <td>
                                            2.0
                                        </td>
                                        <td>
                                            &#27979;&#35797;&#39033;&#30446;
                                        </td>
                                        <td>
                                            2006-06-23 10:14:40.843
                                        </td>
                                    </tr>
                                    <tr>
                                        <td>
                                            h000010011
                                        </td>
                                        <td>
                                            683352
                                        </td>
                                        <td>
                                            &#35745;&#28857;
                                        </td>
                                        <td>
                                        </td>
                                        <td>
                                            2.0
                                        </td>
                                        <td>
                                            &#27979;&#35797;&#39033;&#30446;
                                        </td>
                                        <td>
                                            2006-06-23 10:14:40.843
                                        </td>
                                    </tr>
                                    <tr>
                                        <td>
                                            h000010012
                                        </td>
                                        <td>
                                            433215
                                        </td>
                                        <td>
                                            &#35745;&#28857;
                                        </td>
                                        <td>
                                        </td>
                                        <td>
                                            2.0
                                        </td>
                                        <td>
                                            &#27979;&#35797;&#39033;&#30446;
                                        </td>
                                        <td>
                                            2006-06-23 10:14:40.843
                                        </td>
                                    </tr>
                                    <tr>
                                        <td>
                                            h000010013
                                        </td>
                                        <td>
                                            393899
                                        </td>
                                        <td>
                                            &#35745;&#28857;
                                        </td>
                                        <td>
                                        </td>
                                        <td>
                                            2.0
                                        </td>
                                        <td>
                                            &#27979;&#35797;&#39033;&#30446;
                                        </td>
                                        <td>
                                            2006-06-23 10:14:40.843
                                        </td>
                                    </tr>
                                    <tr>
                                        <td>
                                            h000010014
                                        </td>
                                        <td>
                                            031736
                                        </td>
                                        <td>
                                            &#35745;&#28857;
                                        </td>
                                        <td>
                                        </td>
                                        <td>
                                            2.0
                                        </td>
                                        <td>
                                            &#27979;&#35797;&#39033;&#30446;
                                        </td>
                                        <td>
                                            2006-06-23 10:14:40.843
                                        </td>
                                    </tr>
                                    <tr>
                                        <td>
                                            h000010015
                                        </td>
                                        <td>
                                            188600
                                        </td>
                                        <td>
                                            &#35745;&#28857;
                                        </td>
                                        <td>
                                        </td>
                                        <td>
                                            2.0
                                        </td>
                                        <td>
                                            &#27979;&#35797;&#39033;&#30446;
                                        </td>
                                        <td>
                                            2006-06-23 10:14:40.843
                                        </td>
                                    </tr>
                                    <tr>
                                        <td>
                                            h000010016
                                        </td>
                                        <td>
                                            363407
                                        </td>
                                        <td>
                                            &#35745;&#28857;
                                        </td>
                                        <td>
                                        </td>
                                        <td>
                                            2.0
                                        </td>
                                        <td>
                                            &#27979;&#35797;&#39033;&#30446;
                                        </td>
                                        <td>
                                            2006-06-23 10:14:40.843
                                        </td>
                                    </tr>
                                    <tr>
                                        <td>
                                            h000010017
                                        </td>
                                        <td>
                                            175315
                                        </td>
                                        <td>
                                            &#35745;&#28857;
                                        </td>
                                        <td>
                                        </td>
                                        <td>
                                            2.0
                                        </td>
                                        <td>
                                            &#27979;&#35797;&#39033;&#30446;
                                        </td>
                                        <td>
                                            2006-06-23 10:14:40.843
                                        </td>
                                    </tr>
                                    <tr>
                                        <td>
                                            h000010018
                                        </td>
                                        <td>
                                            354437
                                        </td>
                                        <td>
                                            &#35745;&#28857;
                                        </td>
                                        <td>
                                        </td>
                                        <td>
                                            2.0
                                        </td>
                                        <td>
                                            &#27979;&#35797;&#39033;&#30446;
                                        </td>
                                        <td>
                                            2006-06-23 10:14:40.843
                                        </td>
                                    </tr>
                                    <tr>
                                        <td>
                                            h000010019
                                        </td>
                                        <td>
                                            234750
                                        </td>
                                        <td>
                                            &#35745;&#28857;
                                        </td>
                                        <td>
                                        </td>
                                        <td>
                                            2.0
                                        </td>
                                        <td>
                                            &#27979;&#35797;&#39033;&#30446;
                                        </td>
                                        <td>
                                            2006-06-23 10:14:40.843
                                        </td>
                                    </tr>
                                </tbody>
                            </table>
                        </td>
                        <td class="middleRight">
                        </td>
                    </tr>
                </tbody>
            </table>
   <input type="hidden" name="fors" value="fors" />
        </form>
    </body>
</html>

sfSam
关注
专栏目录
js操作excel
09-19
js操作excel
纯JavaScript导出Excel
06-13
"纯JavaScript导出Excel"的功能正是解决这个问题的一种方法，它允许开发者在不依赖任何后端服务或第三方库的情况下，直接在浏览器端将JSON格式的数据转换为可下载的Excel文件。这种技术对于那些对服务器交互有限制...
javascript 操作 excel 全攻略
C#,SQL,Castle,Hibernate,MVC,Spring.net
01-09 3487
最近做一个项目,用到了javascript操纵excel以生成报表,下面是标有详细注解的实例 function MakeExcel(){var i,j;    try {      var xls    = new ActiveXObject ( "Excel.Application" );     }    catch(e) {         alert( "要打印该表，您必须
JavaScript操作Excel
weixin_33937778的博客
12-29 409
&lt;html&gt;&lt;head&gt;&lt;script language="javascript" type="text/javascript"&gt;&lt;/script&gt;&lt;script language="javascript" type="text/javascript"&gt;function MakeExcel(
javascript操作excel知识点
batey520的专栏
10-30 253
使用JavaScript中的ActiveXObject填充并设置Excel格式 1创建 var XLObj = new ActiveXObject("Excel.Application" ); var xlBook = XLObj.Workbooks.Add; //新增工作簿 var ExcelSheet = xlBook.Worksheets(1); //创建工作表 2...
js对excel的操作
ljt122000的专栏
07-12 303
使用JavaScript中的ActiveXObject填充并设置Excel格式 var XLObj = new ActiveXObject("Excel.Application"); var xlBook = XLObj.Workbooks.Add; //新增工作簿 var ExcelSheet = xlBook.Wor...
JavaScript导出excel
01-11
总结起来，JavaScript导出Excel文件的核心在于使用合适的库，如`js-xlsx`，结合HTML5的File API，将数据转换为Excel格式并提供下载。这个过程涉及到了数据处理、文件操作以及浏览器特性等多个方面的知识。通过理解...
excellentexport:将JavaScript导出到Excel
05-11
JavaScript导出到Excel或CSV。 一个快速JavaScript库，用于从浏览器中HTML表创建导出到Excel / CSV。 无需服务器。 作为新版本3.0.0+的一部分，支持XLSX 。 缺点是该库为600+ KB。 如果只需要XLS或CSV ，请使用2...
JavaScript将页面表格导出为Excel的具体实现
10-26
导出Excel <script type="text/javascript"> var idTmr = ""; function killExcelProcess(appExcel_){ appExcel_.Quit(); appExcel_ = null; idTmr = window.setInterval("Cleanup();",1); } // 导出到Excel，...
Js操作Excel
04-11
Js操作Excel,更多功能自己改进!
javascript操作EXCEL
01-08
纯客户端操作Excel，如果是在访问服务器端的需要在客户端把服务器IP加入信任站点。使用JavaScript中的ActiveXObject填充并设置Excel格式
js 操作excel demo
12-04
js读取本地excel(2003)的demo
javascript 操作excel
fhzh520的专栏
01-25 2173
javascript操作excel代码如下： function HandleExcel(){ try { var xls = new ActiveXObject ( "Excel.Application" ); } catch(e) { alert( "您必须安装Excel电子表格软件，"); return
javascript操作excel
gcguchao的博客
09-18 293
javascript确实很强，在其中能够操作多种的文档，包括word，excel，读写xml，很多通常我们觉得要写在服务端的代码也能够利用javascript在客户端得到很好的实现 下面是自己利用javascript来操作excel文档的例子，希望对需要的人能够有所帮助！ try{ var oXL = new ActiveXObject("Excel.Application"); ...
JS操作excel文件
Glacier—john的博客
03-23 6819
操作excel文件
使用JavaScript中的ActiveXObject填充并设置Excel格式
xto的专栏
03-22 891
1创建 var XLObj = new ActiveXObject("Excel.Application" ); var xlBook = XLObj.Workbooks.Add; //新增工作簿 var ExcelSheet = xlBook.Worksheets(1); //创建工作表 2.保存表格 ExcelSheet.SaveAs("C://TEST.XLS" ); 3.使
ExcelJS：轻松实现Excel文件的读取、操作与写入
最新发布
HHX_01的博客
07-30 6335
ExcelJS 是一个开源的 JavaScript 库，支持读写 XLSX 和 CSV 格式的 Excel 文件。支持丰富的 Excel 功能，如单元格样式、公式、图表等。良好的文档和社区支持。跨平台，可在 Node.js 和浏览器环境中使用。
浏览器的盒子模型
javaSamBlog
09-05 423
三个盒子 假设现在有个容器，容器里面有些内容，虽然我们看不见，但是这些内容的外面是有一个盒子的，这个盒子就是content-box。 //zxx:这里的英文原文是：”The quick brown fox jumped over the lazy web developer. “，而实际上，这里的英文也不是最原始的，是作者从”The quick brown fox jumped ov...
JavaScript实现网页表格导出为Excel文件教程
通过以上知识点的综合运用，我们可以编写出一款功能完备的JavaScript网页表格导出Excel文件的代码。此代码将包含获取表格数据、使用第三方库处理数据格式、设置下载链接及触发下载等功能。最终，用户能够通过网页上...
评论
添加红包

请填写红包祝福语或标题

个

红包个数最小为10个

元

红包金额最低5元

当前余额3.43元 前往充值 >
需支付：10.00元
成就一亿技术人!
领取后你会自动成为博主和红包主的粉丝 规则
hope_wisdom
发出的红包
实付元
使用余额支付
点击重新获取
扫码支付
钱包余额 0

抵扣说明：

1.余额是钱包充值的虚拟货币，按照1:1的比例进行支付金额的抵扣。
2.余额无法直接购买下载，可以购买VIP、付费专栏及课程。

余额充值