Excel表格没有边框！ ！ ！ [英] Excel sheet with no borders! ! !
本文介绍了Excel表格没有边框！ ！ ！的处理方法，对大家解决问题具有一定的参考价值，需要的朋友们下面随着小编来一起学习吧！
问题描述
我尝试使用以下代码在Chrome中运行良好，但问题是下载的excel表没有cellborders
I tried the below code working fine in Chrome but the problem is the downloaded excel sheet not having cellborders
var currentID = ($(this).attr('id'));
//getting values of current time for generating the file name
var dt = new Date();
var day = dt.getDate();
var month = dt.getMonth() + 1;
var year = dt.getFullYear();
var hour = dt.getHours();
var mins = dt.getMinutes();
var postfix = day + "." + month + "." + year + "_" + hour + "." + mins;
//creating a temporary HTML link element (they support setting file names)
var a = document.createElement('a');
//getting data from our div that contains the HTML table
var data_type = 'data:application/vnd.ms-excel';
var table_div = null;
if (currentID == "aRenewal_Queue") {
table_div = document.getElementById('divRenewal_Queue');
a.download = 'RenewalQuotes' + postfix + '.xls';
}
else if (currentID == "aRenewal_Bind") {
table_div = document.getElementById('divRenewal_Bind');
a.download = 'RenewalBinds' + postfix + '.xls';
}
else
{
table_div = document.getElementById('divLobWise_Queue');
a.download = 'LOBWISELEADS' + postfix + '.xls';
}
var table_html = table_div.outerHTML.replace(/ /g, '%20');
a.href = data_type + ', ' + table_html;
//setting the file name
//a.download = 'RenewalQuotes' + postfix + '.xls';
//triggering the function
a.click();
//just in case, prevent default behaviour
e.preventDefault();
请帮助在Excel中获取边框
提前致谢。
KArtik
我尝试了什么：
Please help to get borders in Excel
Thanks in advance.
KArtik
What I have tried:
var currentID = ($(this).attr('id'));
//getting values of current time for generating the file name
var dt = new Date();
var day = dt.getDate();
var month = dt.getMonth() + 1;
var year = dt.getFullYear();
var hour = dt.getHours();
var mins = dt.getMinutes();
var postfix = day + "." + month + "." + year + "_" + hour + "." + mins;
//creating a temporary HTML link element (they support setting file names)
var a = document.createElement('a');
//getting data from our div that contains the HTML table
var data_type = 'data:application/vnd.ms-excel';
var table_div = null;
if (currentID == "aRenewal_Queue") {
table_div = document.getElementById('divRenewal_Queue');
a.download = 'RenewalQuotes' + postfix + '.xls';
}
else if (currentID == "aRenewal_Bind") {
table_div = document.getElementById('divRenewal_Bind');
a.download = 'RenewalBinds' + postfix + '.xls';
}
else
{
table_div = document.getElementById('divLobWise_Queue');
a.download = 'LOBWISELEADS' + postfix + '.xls';
}
var table_html = table_div.outerHTML.replace(/ /g, '%20');
a.href = data_type + ', ' + table_html;
//setting the file name
//a.download = 'RenewalQuotes' + postfix + '.xls';
//triggering the function
a.click();
//just in case, prevent default behaviour
e.preventDefault();
推荐答案
（ this ）。attr（' id'））;
// 获取生成文件名的当前时间值
var dt = new Date（）;
var day = dt.getDate（）;
var month = dt.getMonth（）+ 1 ;
var year = dt.getFullYear（）;
var hour = dt.getHours（）;
var mins = dt.getMinutes（）;
var postfix = day + 。 +月+ 。 +年+ _ +小时+ 。 +分钟;
// 创建临时HTML链接元素（它们支持设置文件名）
var a = document.createElement（' a'< /跨度>）;
// 从包含HTML表格的div中获取数据
var data_type = ' data：application / vnd.ms-excel' ;
var table_div = null ;
if （currentID == aRenewal_Queue ）{
table_div = document.getElementById（' divRenewal_Queue'）;
a.download = ' RenewalQuotes' + postfix + ' 。xls';
}
else if （currentID == aRenewal_Bind）{
table_div = document.getElementById（ ' divRenewal_Bind'）;
a.download = ' RenewalBinds' + postfix + ' 。xls';
}
else
{
table_div = document.getElementById（' divLobWise_Queue'）;
a.download = ' LOBWISELEADS' + postfix + ' 。xls';
}
var table_html = table_div.outerHTML.replace（/ / g，' ％20'）;
a.href = data_type + ' ，' + table_html;
// 设置文件名
// a.download ='RenewalQuotes'+ postfix +'。xls';
// 触发函数
a.click（）;
// 以防万一，防止默认行为
e.preventDefault（） ;
(this).attr('id')); //getting values of current time for generating the file name var dt = new Date(); var day = dt.getDate(); var month = dt.getMonth() + 1; var year = dt.getFullYear(); var hour = dt.getHours(); var mins = dt.getMinutes(); var postfix = day + "." + month + "." + year + "_" + hour + "." + mins; //creating a temporary HTML link element (they support setting file names) var a = document.createElement('a'); //getting data from our div that contains the HTML table var data_type = 'data:application/vnd.ms-excel'; var table_div = null; if (currentID == "aRenewal_Queue") { table_div = document.getElementById('divRenewal_Queue'); a.download = 'RenewalQuotes' + postfix + '.xls'; } else if (currentID == "aRenewal_Bind") { table_div = document.getElementById('divRenewal_Bind'); a.download = 'RenewalBinds' + postfix + '.xls'; } else { table_div = document.getElementById('divLobWise_Queue'); a.download = 'LOBWISELEADS' + postfix + '.xls'; } var table_html = table_div.outerHTML.replace(/ /g, '%20'); a.href = data_type + ', ' + table_html; //setting the file name //a.download = 'RenewalQuotes' + postfix + '.xls'; //triggering the function a.click(); //just in case, prevent default behaviour e.preventDefault();
请帮助在Excel中获取边框
提前致谢。
KArtik
我尝试了什么：
Please help to get borders in Excel
Thanks in advance.
KArtik
What I have tried:
var currentID = (
（ this ）。attr（' id'））;
// 获取生成文件名的当前时间值
var dt = new Date（）;
var day = dt.getDate（）;
var month = dt.getMonth（）+ 1 ;
var year = dt.getFullYear（）;
var hour = dt.getHours（）;
var mins = dt.getMinutes（）;
var postfix = day + 。 +月+ 。 +年+ _ +小时+ 。 +分钟;
// 创建临时HTML链接元素（它们支持设置文件名）
var a = document.createElement（' a'< /跨度>）;
// 从包含HTML表格的div中获取数据
var data_type = ' data：application / vnd.ms-excel' ;
var table_div = null ;
if （currentID == aRenewal_Queue ）{
table_div = document.getElementById（' divRenewal_Queue'）;
a.download = ' RenewalQuotes' + postfix + ' 。xls';
}
else if （currentID == aRenewal_Bind）{
table_div = document.getElementById（ ' divRenewal_Bind'）;
a.download = ' RenewalBinds' + postfix + ' 。xls';
}
else
{
table_div = document.getElementById（' divLobWise_Queue'）;
a.download = ' LOBWISELEADS' + postfix + ' 。xls';
}
var table_html = table_div.outerHTML.replace（/ / g，' ％20'）;
a.href = data_type + ' ，' + table_html;
// 设置文件名
// a.download ='RenewalQuotes'+ postfix +'。xls';
// 触发函数
a.click（）;
// 以防万一，防止默认行为
e.preventDefault（） ;
(this).attr('id')); //getting values of current time for generating the file name var dt = new Date(); var day = dt.getDate(); var month = dt.getMonth() + 1; var year = dt.getFullYear(); var hour = dt.getHours(); var mins = dt.getMinutes(); var postfix = day + "." + month + "." + year + "_" + hour + "." + mins; //creating a temporary HTML link element (they support setting file names) var a = document.createElement('a'); //getting data from our div that contains the HTML table var data_type = 'data:application/vnd.ms-excel'; var table_div = null; if (currentID == "aRenewal_Queue") { table_div = document.getElementById('divRenewal_Queue'); a.download = 'RenewalQuotes' + postfix + '.xls'; } else if (currentID == "aRenewal_Bind") { table_div = document.getElementById('divRenewal_Bind'); a.download = 'RenewalBinds' + postfix + '.xls'; } else { table_div = document.getElementById('divLobWise_Queue'); a.download = 'LOBWISELEADS' + postfix + '.xls'; } var table_html = table_div.outerHTML.replace(/ /g, '%20'); a.href = data_type + ', ' + table_html; //setting the file name //a.download = 'RenewalQuotes' + postfix + '.xls'; //triggering the function a.click(); //just in case, prevent default behaviour e.preventDefault();
AFAIK 下载 [ ^ ]属性不支持IE
你应该试试这个使用JavaScript将HTML表格数据导出到Excel [ ^ ]
AFAIK download [^] attribute is not supported inIE
You shall try this Export HTML Table Data to Excel Using JavaScript[^]
这篇关于Excel表格没有边框！ ！ ！的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！
查看全文
