两个不同数据之间的空间。 [英] space between two different Data.
本文介绍了两个不同数据之间的空间。的处理方法,对大家解决问题具有一定的参考价值,需要的朋友们下面随着小编来一起学习吧!
问题描述
大家好,
i有两个不同的表数据。
i想要在一个excel中显示两个表数据。
在excel中,将显示第一个表数据,在第二个表数据下面将显示。我需要在第一个表数据之后有一个空格。
我使用br标签,但它无法给出两个数据之间的空间。有人知道如何解决这个问题。
我试试这个
Hi Everyone,
i have two different table data.
i want to show both table data in one excel.
In excel first table data will get displayed ,below that second table data will get displayed.I need a space after first table data.
I use br tag but it cannot give the space between two data.Do anyone know how to solve this problem.
I try this
function getZeroErlangBBHCellGridHtml(dataCollection, filter) {
debugger;
var htmlResult = '';
var tableColumnHeaders, tableDataColumns = '';
var htmlTable = '';
tableColumnHeaders = "<tr><th>DATE</th><th>CIRCLE</th><th>TOTALCEELCOUNT</th><th>ZEROERLANGSCELLCOUNT</th><br></tr>";
tableDataColumns = "<tr><td>{0}</td><td>{1}</td><td>{2}</td><td>{3}</td><br></tr>";
htmlTable = htmlTable + "<div><table border=\"1\">";
htmlTable = htmlTable + tableColumnHeaders
$.each(dataCollection[0], function (index, nqi2G) {
debugger;
htmlTable = htmlTable + tableDataColumns.Stringformat(nqi2G.Date, nqi2G.Circle, nqi2G.TotalCeelCount, nqi2G.ZeroErlangsCellCount);
});
var tableColumnHeaders2, tableDataColumns2 = '';
var htmlTable2 = '';
tableColumnHeaders2 = "<tr><th><br>DATE</th><th>CIRCLE</th><th>CELLID</th></tr>";
tableDataColumns2 = "<tr><td>{0}</td><td>{1}</td><td>{2}</td></tr>";
htmlTable2 = htmlTable2 + "<br><div><table border=\"1\">";
htmlTable2 = htmlTable2 + tableColumnHeaders2
$.each(dataCollection[1], function (index, nqi2G) {
debugger;
htmlTable2 = htmlTable2 + tableDataColumns2.Stringformat(nqi2G.Date, nqi2G.Circle, nqi2G.CellId);
});
htmlResult = htmlTable + htmlTable2 + "</table></div>";
return htmlResult;
}
在此先感谢
Harshal
Thanks in Advance
Harshal
推荐答案
.each(dataCollection [0],function(index,nqi2G){
debugger;
htmlTable = htmlTable + tableDataColumns.Stringformat(nqi2G.Date,nqi2G.Circle,nqi2G。 TotalCeelCount,nqi2G.ZeroErlangsCellCount);
});
var tableColumnHeaders2,tableDataColumns2 ='';
var htmlTable2 ='';
tableColumnHeaders2 =< tr > < th > < br > DATE < span class =code-keyword>< / th > < th > CIRCLE < / th > < th > CELLID < / th > < / tr > ;
tableDataColumns2 =< tr > < td > {0} < / td > < td > { 1} < / td > < td > {2} < / td > < / tr > ;
htmlTable2 = htmlTable2 +< br > < div > < table border = \ 1 \ > ;
htmlTable2 = htmlTable2 + tableColumnHeaders2
.each(dataCollection[0], function (index, nqi2G) { debugger; htmlTable = htmlTable + tableDataColumns.Stringformat(nqi2G.Date, nqi2G.Circle, nqi2G.TotalCeelCount, nqi2G.ZeroErlangsCellCount); }); var tableColumnHeaders2, tableDataColumns2 = ''; var htmlTable2 = ''; tableColumnHeaders2 = "<tr><th><br>DATE</th><th>CIRCLE</th><th>CELLID</th></tr>"; tableDataColumns2 = "<tr><td>{0}</td><td>{1}</td><td>{2}</td></tr>"; htmlTable2 = htmlTable2 + "<br><div><table border=\"1\">"; htmlTable2 = htmlTable2 + tableColumnHeaders2
.each(dataCollection [1],function(index,nqi2G){
debugger;
htmlTable2 = htmlTable2 + tableDataColumns2 .Stringformat(nqi2G.Date,nqi2G.Circle,nqi2G.CellId);
});
htmlResult = htmlTable + htmlTable2 +< / table > < / div > 跨度>;
返回htmlResult;
}
.each(dataCollection[1], function (index, nqi2G) { debugger; htmlTable2 = htmlTable2 + tableDataColumns2.Stringformat(nqi2G.Date, nqi2G.Circle, nqi2G.CellId); }); htmlResult = htmlTable + htmlTable2 + "</table></div>"; return htmlResult; }
提前致谢
Harshal
Thanks in Advance
Harshal
我明白了。
i需要改变
I got it.
i need to change
htmlResult = htmlTable + htmlTable2 + "</table></div>";
谢谢。
Harshal
Thanks.
Harshal
这篇关于两个不同数据之间的空间。的文章就介绍到这了,希望我们推荐的答案对大家有所帮助,也希望大家多多支持IT屋!
查看全文