两个不同数据之间的空间。 [英] 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屋！