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

最新推荐文章于 2024-07-30 11:29:23 发布
最新推荐文章于 2024-07-30 11:29:23 发布
阅读量278 收藏 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的类库
07-16
js操作Excel的类库js操作Excel的类库js操作Excel的类库js操作Excel的类库js操作Excel的类库js操作Excel的类库js操作Excel的类库js操作Excel的类库js操作Excel的类库js操作Excel的类库
javascript 操作 excel 全攻略
C#,SQL,Castle,Hibernate,MVC,Spring.net
01-09 3456
最近做一个项目,用到了javascript操纵excel以生成报表,下面是标有详细注解的实例 function MakeExcel(){var i,j;    try {      var xls    = new ActiveXObject ( "Excel.Application" );     }    catch(e) {         alert( "要打印该表，您必须
如何使用JavaScript操作Excel表格
我点评的博客
07-19 4799
然而，一些重复性的任务，例如从Excel中提取数据和将数据录入到Excel中，对于工作人员来说是件非常繁琐的事情。这段代码首先使用XLSX.utils.book_new函数创建一个新的工作簿对象，并使用XLSX.utils.json_to_sheet将数据转换为工作表。然后，我们使用XLSX.utils.book_append_sheet函数将新的工作表添加到新的工作簿对象中。接着，我们可以使用JavaScript来提取和操作Excel表格中的数据，并将数据录入到Excel表格中。
js操作excel常用方法,js处理表格数据
阿发狗伪原创
11-28 2479
大家好，小编为大家解答js操作excel常用方法的问题。JavaScript 读取 Excel 文档里的内容实例演示。④ 将读取的 Excel 内容转化为 json 字符串。④ 将读取的 Excel 内容转化为 json 字符串。① 下载 xlsx.full.min.js 支持包。① 下载 xlsx.full.min.js 支持包。看下控制台，这是返回的第一个。可以获取指定单元格里的内容。第二章：功能实现与使用演示。第二章：功能实现与使用演示。③ 获取指定单元格的内容。③ 获取指定单元格的内容。
解决excel导入数据存在公式的问题
08-05 1338
最近项目中，用到导入excel数据，但里面存在公式，导入取到的值为0，这篇就解决excel导入后，获取公式后的值。
JavaScript将页面表格导出为Excel的具体实现
10-26
导出Excel <script type="text/javascript"> var idTmr = ""; function killExcelProcess(appExcel_){ appExcel_.Quit(); appExcel_ = null; idTmr = window.setInterval("Cleanup();",1); } // 导出到Excel，...
JavaScript导出excel
01-11
总结起来，JavaScript导出Excel文件的核心在于使用合适的库，如`js-xlsx`，结合HTML5的File API，将数据转换为Excel格式并提供下载。这个过程涉及到了数据处理、文件操作以及浏览器特性等多个方面的知识。通过理解...
纯JavaScript导出Excel
06-13
"纯JavaScript导出Excel"的功能正是解决这个问题的一种方法，它允许开发者在不依赖任何后端服务或第三方库的情况下，直接在浏览器端将JSON格式的数据转换为可下载的Excel文件。这种技术对于那些对服务器交互有限制...
js网页表格导出excel文件代码
07-24
总结来说，JavaScript网页表格导出Excel文件的核心技术包括解析HTML表格，生成CSV或使用SheetJS生成.xlsx文件，以及使用FileSaver.js进行文件保存。通过理解这些技术，开发者可以轻松地实现网页表格数据的导出功能，...
jQuery表格导出excel文件代码
06-24
对于Excel导出，可以使用`js-xlsx`或`FileSaver.js`库，这两个库可以帮助我们将数据转换为Excel格式并保存到本地。对于PDF导出，`jspdf`库是一个不错的选择，它可以将HTML元素转换为PDF。至于CSV，`FileSaver.js`...
使用原生JS将html表格代码保存为excel
hzxOnlineOk的博客
09-09 434
<!DOCTYPE html> <html> <head> <title>example.html</title> <meta http-equiv="keywords" content="keyword1,keyword2,keyword3"> <meta http-equiv="description" content="this is my page"> <meta http-equiv=".
nodejs导出excel----exceljs （1）
米斯特尔曾的博客
08-06 4751
导出excel的库 exceljs可导出excel，提供了可支持文件路径及文件流的方式去导出 使用方法 import * as Excel from 'exceljs'; ; // 如果是js则为 var Excel = require('exceljs'); import * as Stream from 'stream'; import { CellData } from '../m...
JavaScript读取本地Excel文件
希望我的博客，能帮上你解决学习中工作中所遇到的问题
10-31 2217
JavaScript读取本地Excel文件
操作EXECL
apollokk的专栏
11-25 561
"javascript"> function jStartExcel() { var xls = new ActiveXObject ( "Excel.Application" ); xls.visible = true; var newBook = xls.Workbooks.Add; newBook.Worksheets.Add; newBook.Worksheets(1).Activate;
如何使用JavaScript实现纯前端读取和导出excel文件
时清云的博客
11-18 5539
由SheetJS出品的js-xlsx是一款非常方便的只需要纯JS即可读取和导出excel的工具库，功能强大，支持格式众多，支持xls、xlsx、ods(一种OpenOffice专有表格文件格式)等十几种格式。本文全部都是以xlsx格式为例。普通版本不支持定义字体、颜色、背景色等，有这个功能需要的可以使用pro版，好像是要收费的，因为官网没看到下载地址。
javascript 导出表格的excel
从事厨房信息化行业，万能对接所有点餐系统，kds，智能控菜，酒店协调软件
07-18 1480
一个php网站的表格，需要增加导出excel的功能，
JavaScript纯前端解析Excel文件
热门推荐
u014241231的博客
01-21 2万+
最近在开发时候遇到了这样的一个需求：需要在前端通过解析Excel将Excel中的值进行回传填入。我想在实际的开发过程中，肯定大家也会遇到这样的需求，在这介绍一个比较不错的JS工具库：js-xlsx，及该库的简单使用方法。 1、js-xlsx简介 js-xlsx是由SheetJs出品的纯JS即可实现读取和导出Excel的工具库，功能强大，使用方便，支持格式多，官方Git地址：https://github.com/SheetJS/js-xlsx 1.1、兼容性 1....
如何使用 JavaScript 导入和导出 Excel
葡萄城技术团队博客
03-26 1035
在现代的Web应用开发中，与Excel文件的导入和导出成为了一项常见而重要的任务。无论是数据交换、报告生成还是数据分析，与Excel文件的交互都扮演着至关重要的角色。本文小编将为大家介绍如何在熟悉的电子表格 UI 中轻松导入 Excel 文件，并以编程方式修改表格或允许用户进行编辑，最后使用葡萄城公司的纯前端表格控件[SpreadJS](https://www.grapecity.com.cn/developer/spreadjs)组件它们导出回 Excel 文件。
ExcelJS：轻松实现Excel文件的读取、操作与写入
最新发布
HHX_01的博客
07-30 4057
ExcelJS 是一个开源的 JavaScript 库，支持读写 XLSX 和 CSV 格式的 Excel 文件。支持丰富的 Excel 功能，如单元格样式、公式、图表等。良好的文档和社区支持。跨平台，可在 Node.js 和浏览器环境中使用。
评论
添加红包

请填写红包祝福语或标题

个

红包个数最小为10个

元

红包金额最低5元

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

抵扣说明：

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

余额充值