Want to export more than 100 Columns and 400k Rows #2855

New Issue

skyrbs · 2023-01-15T15:40:57Z

skyrbs commented

2023-01-15 15:40:57 +00:00

First-time contributor

Hi Team,

I am trying to export the json data into xlsx file format. Below is one code

const worksheet: XLSX.WorkSheet = XLSX.utils.json_to_sheet(json); // At this step my page angular getting blank / unresponsive

    const workbook: XLSX.WorkBook = { Sheets: { 'data': worksheet }, SheetNames: ['file'] };
    
    const excelBuffer: any = XLSX.write(workbook, { bookType: 'xlsx', type: 'buffer', bookSST:true,  });
    
    this.saveAsExcelFile(excelBuffer, excelFileName);

I was only able to generate 65k row with this columns counts. i have uploaded the example file format for 1 rows and 106 columns

Thanks in advance for your help.

Hi Team, I am trying to export the json data into xlsx file format. Below is one code ``` const worksheet: XLSX.WorkSheet = XLSX.utils.json_to_sheet(json); // At this step my page angular getting blank / unresponsive const workbook: XLSX.WorkBook = { Sheets: { 'data': worksheet }, SheetNames: ['file'] }; const excelBuffer: any = XLSX.write(workbook, { bookType: 'xlsx', type: 'buffer', bookSST:true, }); this.saveAsExcelFile(excelBuffer, excelFileName); ``` I was only able to generate 65k row with this columns counts. i have uploaded the example file format for 1 rows and 106 columns Thanks in advance for your help.

SampleDAta.xlsx

11 KiB

sheetjs commented

2023-01-16 08:19:15 +00:00

~40M rows will take a while but it should work.

Try dense mode:

const worksheet: XLSX.WorkSheet = XLSX.utils.json_to_sheet(json, {dense: true});

~40M rows will take a while but it should work. Try dense mode: ```js const worksheet: XLSX.WorkSheet = XLSX.utils.json_to_sheet(json, {dense: true}); ```

skyrbs commented

2023-01-16 09:19:57 +00:00

First-time contributor

Hi Team,

adding dense is giving compile error(screenshot attached). I am using version "xlsx": "^0.18.5"

I have converted aoa_to_sheet also giving dense error(screenshot attached). Without dense only working till 65K rows and 132 Columns

const wb = XLSX.utils.book_new();
    const outputData = json.map( Object.values );
    console.log("Total No of Columns ", Object.keys(json[0]));
    outputData.unshift(Object.keys(json[0]));
    const ws = XLSX.utils.aoa_to_sheet (outputData, { dense:true});
    XLSX.utils.book_append_sheet(wb, ws);
    console.log("File Downloading Started ");
    XLSX.writeFile(wb, excelFileName + EXCEL_EXTENSION,{compression:true, bookType: 'xlsx', type: 'array', bookSST:true});

Hi Team, adding dense is giving compile error(screenshot attached). I am using version "xlsx": "^0.18.5" I have converted aoa_to_sheet also giving dense error(screenshot attached). Without dense only working till 65K rows and 132 Columns ``` const wb = XLSX.utils.book_new(); const outputData = json.map( Object.values ); console.log("Total No of Columns ", Object.keys(json[0])); outputData.unshift(Object.keys(json[0])); const ws = XLSX.utils.aoa_to_sheet (outputData, { dense:true}); XLSX.utils.book_append_sheet(wb, ws); console.log("File Downloading Started "); XLSX.writeFile(wb, excelFileName + EXCEL_EXTENSION,{compression:true, bookType: 'xlsx', type: 'array', bookSST:true}); ```

Screenshot 2023-01-16 at 2.45.09 PM.png

279 KiB