js导出格式化的excel 实例方法
时间:2024-04-10 16:17:15
function getTableDataByXML(inTable, inWindow) {
var rows = 0;
//alert("getTblData is " + inWindow);
var tblDocument = document;
if (!!inWindow && inWindow != "") {
if (!document.all(inWindow)) {
return null;
}
else {
tblDocument = eval(inWindow).document;
}
}
var inTbl = tblDocument.getElementById(inTable);
var outStr = "<?xml version=\"1.0\"?>\n";
outStr = outStr + "<?mso-application progid=\"Excel.Sheet\"?>\n";
outStr = outStr + "<Workbook xmlns=\"urn:schemas-microsoft-com:office:spreadsheet\"";
outStr = outStr + " xmlns:o=\"urn:schemas-microsoft-com:office:office\"";
outStr = outStr + " xmlns:x=\"urn:schemas-microsoft-com:office:excel\"";
outStr = outStr + " xmlns:ss=\"urn:schemas-microsoft-com:office:spreadsheet\">\n";
outStr = outStr + "<Worksheet ss:Name=\"Sheet1\">\n";
outStr = outStr + "<Table ss:ExpandedColumnCount=\"30\">\n";
var re = /^[0-9]+.?[0-9]*$/; //是否为数字
if (inTbl != null) {
for (var j = 0; j < inTbl.rows.length; j++) {
outStr += "<Row ss:AutoFitHeight=\"0\">\n";
for (var i = 0; i < inTbl.rows[j].cells.length; i++) {
if (i == 0 && rows > 0) {
outStr += "<Cell><Data ss:Type=\"String\"></Data></Cell>\n";
rows -= 1;
}
var cellValue = inTbl.rows[j].cells[i].innerText;
//小于12位数字用Number
if(re.test(cellValue) && (new String(cellValue)).length < 11){
outStr = outStr + "<Cell><Data ss:Type=\"Number\">" + cellValue + "</Data></Cell>\n";
}else{
outStr = outStr + "<Cell><Data ss:Type=\"String\">" + cellValue + "</Data></Cell>\n";
}
if (inTbl.rows[j].cells[i].colSpan > 1) {
for (var k = 0; k < inTbl.rows[j].cells[i].colSpan - 1; k++) {
outStr += " <Cell><Data ss:Type=\"String\"></Data></Cell>\n";
}
}
if (i == 0) {
if (rows == 0 && inTbl.rows[j].cells[i].rowSpan > 1) {
rows = inTbl.rows[j].cells[i].rowSpan - 1;
}
}
}
outStr += "</Row>\n";
}
}
else {
outStr = null;
alert("你要导出的表不存在!!");
return;
}
outStr = outStr + "</Table>\n</Worksheet>\n</Workbook>";
return outStr;
}
上述函数原本是导出txt文件的函数。把excel文件另存为一个xml文件,就可得到excel能识别什么内容格式的xml文件。
标签:导出,格式化,excel
0
投稿
猜你喜欢
MySql like模糊查询通配符使用详细介绍
2024-01-24 12:25:03
python空值判断方式(if xxx和if xxx is None的区别及说明)
2022-04-01 20:18:42
利用pandas将numpy数组导出生成excel的实例
2021-03-10 02:43:14
javascript+css实现俄罗斯方块小游戏
2024-04-23 09:28:06
利用Python实现Windows下的鼠标键盘模拟的实例代码
2023-06-22 04:37:31
Python爬虫爬取属于自己的地铁线路图
2021-09-10 11:46:23
python3.6中anaconda安装sklearn踩坑实录
2023-03-16 19:17:15
使用卷积神经网络(CNN)做人脸识别的示例代码
2023-12-31 06:25:05
PHPStudy下如何为Apache安装SSL证书的方法步骤
2023-11-14 18:57:09
echarts折线图流动特效的实现全过程(非平滑曲线)
2024-05-02 16:28:55
在python中logger setlevel没有生效的解决
2021-12-13 16:03:01
JavaScript实现点击出现子菜单效果
2024-04-19 10:45:56
Http与https对比详细介绍
2022-09-10 05:01:38
python 实现图像快速替换某种颜色
2021-07-20 03:16:13
MySQL JOIN关联查询的原理及优化
2024-01-28 13:13:49
详解使用PyInstaller将Pygame库编写的小游戏程序打包为exe文件
2023-11-10 13:20:31
一个比较实用的大数据量分页存储过程
2024-01-13 16:11:29
新年伊始,看各大网站新春LOGO
2009-01-01 19:35:00
Yii2中的场景(scenario)和验证规则(rule)详解
2024-04-28 09:43:50
Python约瑟夫生者死者小游戏实例讲解
2023-02-12 02:14:25