如何使用ALASQL(AngularJS)在Excel中为特定的列和行赋予边框 [英] How to give border to particular column and row in Excel with ALASQL (AngularJS)

问题描述

我想在特定的列和行中添加边框，是否可以添加边框. 这是我的代码，请检查一下.我没有任何添加边框的选项.

I want to add border in particular column and row is it possible to add in it . this is my code please check it . I didn't get any option to add border.

            columns: [
              {columnid:'email'},
              {columnid:'dob', title: 'Birthday', width:300},
              {columnid:'name'},
              {
                columnid:'name',
                title: 'Number of letters in name',
                width: '300px',
                cell: {
                  value: function(value){return value.length}
                }
              },
            ],
            row: {
              style: function(sheet,row,rowidx){
                return 'background:'+(rowidx%2?'red':'yellow');
              }
            },
            rows: {
              4:{cell:{style:'background:blue'}}
            },
            cells: {
              2:{
                2:{
                  style: 'font-size:45px;background:pink',
                  value: function(value){return value.substr(1,3);}
                }
              }
            }
        };

推荐答案

这是边界单元解决方案.您可以为列或行使用类似的逻辑.

Here is a border cell solution. You can similar logic for column or row.

cell: {
    style: function(event) {
        return (event==YOUR_INPUT?'border:1px black dotted; padding-left:5px; padding-right:5px':'');
    }
}

这篇关于如何使用ALASQL(AngularJS)在Excel中为特定的列和行赋予边框的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！