如何使用excelJs样式导出文件的标题
我如何自定义样式，例如在excelJs中创建标题的边框，颜色，宽度等？
我可以设置工作表的行样式，但不能设置标题的样式
fDay = days[0].charAt(0)
sDay = days[1].charAt(0)
sheet.columns = [
{header: 'Num', key: 'id'},
{header: 'Nom prenom', key: 'name'},
{header: 'Date de naissance', key: 'birthday'},
{header: fDay+'1', key: fDay+'1', style: {border: 'thin'}},
{header: sDay+'1', key: sDay+'1'},
{header: fDay+'2', key: fDay+'2'},
{header: sDay+'2', key: sDay+'2'},
{header: fDay+'3', key: fDay+'3'},
{header: sDay+'3', key: sDay+'3'},
{header: fDay+'4', key: fDay+'4'},
{header: sDay+'4', key: sDay+'4'},
{header: fDay+'5', key: fDay+'5'},
{header: sDay+'5', key: sDay+'5'},
]
$.each(dataPlayers, (index, player)=>{
row = sheet.addRow({id: player.id, name: player.Prenom+' '+player.Nom, birthday: getShortDate(player.DateNaissance)})
row.eachCell(function(cell) {
cell.border = {
top: {style:'thin'},
left: {style:'thin'},
bottom: {style:'thin'},
right: {style:'thin'}
};
})
})
结果是这样
<< img src =“ ==” alt =“是excel文件”>]
我如何自定义在excelJs中创建标题的样式，如边框，颜色，宽度等？我可以设置工作表的行样式，但不能设置标题fDay = days [0] .charAt（0）sDay = days [1] .charAt（0）...
回答如下：所以，我发现的方法是创建所有行，然后迭代每行的每个单元格以在其上或自身的行上应用样式：
如何使用excelJs样式导出文件的标题
我如何自定义样式，例如在excelJs中创建标题的边框，颜色，宽度等？
我可以设置工作表的行样式，但不能设置标题的样式
fDay = days[0].charAt(0)
sDay = days[1].charAt(0)
sheet.columns = [
{header: 'Num', key: 'id'},
{header: 'Nom prenom', key: 'name'},
{header: 'Date de naissance', key: 'birthday'},
{header: fDay+'1', key: fDay+'1', style: {border: 'thin'}},
{header: sDay+'1', key: sDay+'1'},
{header: fDay+'2', key: fDay+'2'},
{header: sDay+'2', key: sDay+'2'},
{header: fDay+'3', key: fDay+'3'},
{header: sDay+'3', key: sDay+'3'},
{header: fDay+'4', key: fDay+'4'},
{header: sDay+'4', key: sDay+'4'},
{header: fDay+'5', key: fDay+'5'},
{header: sDay+'5', key: sDay+'5'},
]
$.each(dataPlayers, (index, player)=>{
row = sheet.addRow({id: player.id, name: player.Prenom+' '+player.Nom, birthday: getShortDate(player.DateNaissance)})
row.eachCell(function(cell) {
cell.border = {
top: {style:'thin'},
left: {style:'thin'},
bottom: {style:'thin'},
right: {style:'thin'}
};
})
})
结果是这样
<< img src =“ ==” alt =“是excel文件”>]
我如何自定义在excelJs中创建标题的样式，如边框，颜色，宽度等？我可以设置工作表的行样式，但不能设置标题fDay = days [0] .charAt（0）sDay = days [1] .charAt（0）...
回答如下：所以，我发现的方法是创建所有行，然后迭代每行的每个单元格以在其上或自身的行上应用样式：