Thank you for writing this. It resonates with me at this moment in my life! :-)
483 karma · joined September 26, 2019
It will handle 100,000s of cells without much issues: it has virtualized scrolling and rendering .
I have not tested it with large file sizes, like your 20mb or 50mb examples.
I would love to test the product with it. Is there a way you could send us an example of such a workbook, where data is anonimized?
You can send it to robbert@spreadsheetpreview.com
I have just launched SpreadsheetPreview, an embeddable Javascript/Typescript component that displays an Excel file (.xlsx) in any browser.
Benefits: No upload. No server. No Microsoft Office dependency.
You can see it here: https://spreadsheetpreview.com.
The component is based on DataGrid Toolkit, the toolkit that also powers upcoming DataGridXL v4, which is an editable data grid component with an Excel-like interface.
The component is free to use for non-commercial projects. Commercial use requires license.
Please try it out and let me know what you think!
Best,
Robbert
On the server it opens a headless browser, where it converts the XLXS format to OGF (Open Grid Format), which is then rendered by DataGrid Toolkit, the engine behind DataGridXL v4. It then takes a screenshot of this render and sends it back to the requester.
Try out a few renders at https://spreadsheetpreview.com
Using AI for auto subtitles and actor matching. Will build some auto deploy fragment to social media as well. I think these short fragments will do well op TikTok.
So I will release my new data grid component based on my own toolkit, and if people want tweaks or "add these features", I will demonstrate them the toolkit.
I like the chain able queries, like:
``` const cats = await manifest .from('cats') .where('breed = siamese') .andWhere('active = true') .andWhere('birthDate > 2020-01-01') .find() ```
What is it inspired by?
Love the headline. Very confident ;-)
I am very happy to work solo to prevent as much of these things as possible.
Everyone is using Typescript these days it seems instead of plain JavaScript but the 10 seconds + compile times and the extra layers in debugging make it a pain for me instead of a benefit. So I am using ES6 with Rollup. Rollup is great and my only dev dependency really. However great it is, if one day I could do without, I would :-)
Like you said, there exists many chart libs out there already... Hope you find a way to sell and keep working on your product!
Browsers can handle AND update really large DOMs, but they still choke on doing all of these actions (repaint, reflow) WHILE SCROLLING, which is a different game.
You can have a fast DOM without canvas, but it requires creative thinking. DataGridXL also renders millions of cells, but it does not use canvas as its main renderer (https://www.datagridxl.com/demos/one-million-cells).
The way it works: only columns are their own DOM nodes. For browsers it's just too much to ask to re-render let's say (20rows*10cols) 200 DOM nodes while keeping scrolling at 60fps.