excel-formula - ui网格在导出excel单元格上显示超链接

Question

我想改变这个

var cell = {
            v: value,
            s: {alignment: {horizontal:"left"}}
        };

像这样在“值”上添加超链接公式

`{ formula:'HYPERLINK("' + mainhyperlinkurl + '","Download.Zip")' };`

在下面的 addcell 函数代码示例中

function addCell(range, value, row, col, ws, isHeader) {
        if (range.s.r > row) range.s.r = row;
        if (range.s.c > col) range.s.c = col;
        if (range.e.r < row) range.e.r = row;
        if (range.e.c < col) range.e.c = col;
        var cell = {
            v: value,
            s: {alignment: {horizontal:"left"}}
        };
        if (cell.v == null) cell.v = '-';
        var cell_ref = XLSX.utils.encode_cell({
            c: col,
            r: row
        });

        //if (typeof cell.v === 'number') cell.t = 'n';
        //if (!isNaN(cell.v)) cell.t = 'n'; 
        //else 
        if (typeof cell.v === 'boolean') cell.t = 'b';
        else if (cell.v instanceof Date) {
            cell.t = 'n';
            cell.z = XLSX.SSF._table[14];
            cell.v = datenum(cell.v);
        } else cell.t = 's';
        if(isHeader){
            cell.s = {
                font: {
                    bold:isHeader
                }
            };
        }
        ws[cell_ref] = cell;
    }

等待您的回复，谢谢。

标签： excel-formulaangular-ui-gridui-grid