Can we stream write (json to xlsx) in sheet js? #3248

New Issue

Chetan11-dev · 2024-11-06T14:29:11Z

Chetan11-dev commented

2024-11-06 14:29:11 +00:00

I want to express my heartfelt gratitude for the incredible work you do with SheetJS. Your tool has been a lifesaver, making it so much easier to create Excel files. Thank you for your dedication and effort.

I have a question, I didn't find an example that demonstrates how to create an .xlsx file from a stream of JavaScript objects. I wanted to know:

Is it possible to do this?
If so, how can it be done?

I want to express my heartfelt gratitude for the incredible work you do with SheetJS. Your tool has been a lifesaver, making it so much easier to create Excel files. Thank you for your dedication and effort. I have a question, I didn't find an example that demonstrates how to create an `.xlsx` file from a stream of JavaScript objects. I wanted to know: - Is it possible to do this? - If so, how can it be done?

sheetjs commented

2024-11-06 14:45:52 +00:00

Not currently. #3120 follow this issue.

Not currently. https://git.sheetjs.com/sheetjs/sheetjs/issues/3120 follow this issue.

sheetjs closed this issue

2024-11-06 14:45:53 +00:00

Chetan11-dev commented

2024-11-07 13:31:56 +00:00

Do you know of any other library that does support it (nodejs)?
What I am trying to do is to stream write objects (millions of items) to an xlsx file like this

xlsxwriter = createXlsxStreamWriter('book.xlsx')
await streamReadFile((item)=>{
    // stream write a js object
    await xlsxwriter.write(item)
})

xlsxwriter.end()

Do you know of any other library that does support it (nodejs)? What I am trying to do is to stream write objects (millions of items) to an xlsx file like this ```js xlsxwriter = createXlsxStreamWriter('book.xlsx') await streamReadFile((item)=>{ // stream write a js object await xlsxwriter.write(item) }) xlsxwriter.end() ```

Chetan11-dev reopened this issue

2024-11-07 13:31:56 +00:00

Sign in to join this conversation.