vue.js - Ag-grid excel export: Multiple hyperlinks in one cell - Stack Overflow

admin管理员组

文章数量:1325137

I am using vue with ag-grid table, the excel-export feature is not working for the usecase of having multiple links in one cell.

Here is the solution I have now:

const gridOptions = computed(
    (): GridOptions<IOpenQuestion> => ({
        defaultExcelExportParams: {
            autoConvertFormulas: true,
            processCellCallback: params => {
                const { column, value, node } = params;
                const { field, valueFormatter } = column.getColDef();

                if (field === 'documents' && Array.isArray(value) && value.length > 0) {
                    return `=CONCATENATE(${value.map(v => `HYPERLINK("${v?.link}", "${v?.filename}")`).join(', "\n", ')})`;
                }
                return valueFormatter ? valueFormatter({ ...params, data: node.data }) : value;
            },
        },
    }),
);

It currently works if I open the exported file with the Numbers app on mac but with excel it doesn't (only the labels are showing). Is there a way to fix this to have multi-line links within a cell?

本文标签： vuejsAggrid excel export Multiple hyperlinks in one cellStack Overflow