使用table_to_book方法导出并下载文件时，如何在excel文件中添加border样式？ #3076

New Issue

767746649zyy · 2024-02-18T09:37:16Z

767746649zyy commented

2024-02-18 09:37:16 +00:00

你好，当我使用table_to_book方法导出并下载文件时，table的border样式没有加进去。
代码:

<table border={1} id="excel">
        <tbody>
          <tr>
            <td>1</td>
            <td>2</td>
            <td>3</td>
          </tr>
          <tr>
            <td>1</td>
            <td>2</td>
            <td>3</td>
          </tr>
        </tbody>
      </table>

  const dom_element = document.getElementById("excel");
  const workbook = XLSX.utils.table_to_book(dom_element, {
      cellStyles: true,
    });
  XLSX.writeFileXLSX(
      workbook,
      `demo.xlsx`
    );

你好，当我使用table_to_book方法导出并下载文件时，table的border样式没有加进去。代码: ``` <table border={1} id="excel"> <tbody> <tr> <td>1</td> <td>2</td> <td>3</td> </tr> <tr> <td>1</td> <td>2</td> <td>3</td> </tr> </tbody> </table> ``` ``` const dom_element = document.getElementById("excel"); const workbook = XLSX.utils.table_to_book(dom_element, { cellStyles: true, }); XLSX.writeFileXLSX( workbook, `demo.xlsx` ); ```

sheetjs commented

2024-02-18 17:18:32 +00:00

Cell border styling requires SheetJS Pro. We hope to add styling to SheetJS CE but do not know the timeframe.

Cell border styling requires [SheetJS Pro](https://sheetjs.com/pro/). We hope to add styling to SheetJS CE but do not know the timeframe.

sheetjs closed this issue

2024-02-18 17:18:32 +00:00

Sign in to join this conversation.