How can I export table to excel when I use ant-design-pro

[m26597]

The project I am developing is using the antd pro, I need to export the table component to excel .
How could I do this by the use of SheetJS? Could you help me in detail? Thanks.

[SheetJSDev]

Assuming you are referring to
https://ant.design/components/table/#header , you can export the generated table or you can export the source data.

To export the generated table, use table_to_sheet on the TABLE DOM element to generate a worksheet.

To export the source data, you can call json_to_sheet on the array of JS objects to generate a worksheet.

[m26597]

Thanks for your quick answer. I am going to export the generated table. How couleI use table_to_sheet on the TABLE DOM. I haven't found the component in antd or antd pro. Need I use :
import table_to_sheet from 'xlsx'? I am a little confused, help me, Please!

[SheetJSDev]

@m26597 not sure how your build process is structured, but http://sheetjs.com/demos/table is a vanilla JS example, and it basically boils down to:

var elt = document.getElementById('data-table');
var sheetname = "SheetName", filename = "export.xlsx";

var tbl = XLSX.utils.table_to_sheet(elt);
var wb = XLSX.utils.book_new();
XLSX.utils.book_append_sheet(wb, tbh, sheetname);
XLSX.writeFile(wb, filename);

You might be able to use the glob import import * as XLSX from 'xlsx'

[m26597]

Cool! Thank you. So helpful website,but if I only want to use the function of exporting table to excel, need I use the all xlsx or is there a new-hand introduce ? Besides, could you tell me how to get the table element like var elt = document.getElementById('data-table'); in antd?

[m26597]

Yes! What I want to do is the export to xlsx function in the link "http://sheetjs.com/demos/table.

[m26597]

Where could I see the source code ? Please give me a link, thank you

[SheetJSDev]

@m26597 that's a question better addressed to the ant developers. You need to get a reference to the generated TABLE.

P.S.: the source to the page is unminified. You can view source

[m26597]

I've read the source code through F12, so the last problem is "need I use the all xlsx or is there a new-hand introduce ? Besides, could you tell me how to get the table element like var elt = document.getElementById('data-table'); in antd?"

[m26597]

All right, I would try to realize the function. Anyway, Thank you very much.

[m26597]

I'm sorry, I have another issue, Is the exported excel a similar excel but actually a text or html just like a excel?

[dave-wind]

you can try to see
https://github.com/dave-wind/excel