Uploading large xlsx files stops the browser tab from working

Webix JS
1

I’m trying to download a large xlsx file using a spreadsheet, but the browser tab freezes. Is there a way to transfer work to web worker? You have the opportunity to work with webworkers in pivot (Web Workers for Building JavaScript Web Apps /), but is there no such option for the spreadsheet?

{
view: 'spreadsheet',
                    id: ID,
                    datatype: 'excel',
                    url: `binary->${fileEndpoint}`,
                    css: ''excelView",
                    width: spreadSheetWidth,
                    height: spreadSheetHeight,
                    toolbar: true,
                    bottombar: true,
                    liveEditor: true,
                    resizeCell: true,
}
2

Hello George8,

We had a similar discussion on this topic on our forum, you can read the answers there and I will duplicate the options mentioned there in Russian:

  1. You can try resetting your Excel styles that you import along with your data.
    For example, you can delete all styles when loading a file inside your spreadsheet: Code Snippet (alternatively, you can clear your styles in the Excel file itself: Deleting Unwanted Styles (Microsoft Excel)). The first option is the preferable solution.

  2. Another step to further optimize this process would be to remove the styles before the file is loaded, simply preventing them from being parsed. We can implement this by changing one of our cdns, which is responsible for importing/exporting our sheets, with a single line of code that disables styles parsing by default (we would set cellStyles to false).

  3. The main factor that reduces performance is the XLS parsing time. The best strategy would be to convert the XLS to CSV or to JSON on the server side before loading into spreadsheet.

You can also send us your example file for testing, this will help us better understand what exactly the problem is in your case and suggest the most rational solution for optimization.