robbiejs

Thank you for writing this. It resonates with me at this moment in my life! :-)

Thanks for your comment!

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 am working on Spreadsheet Preview, embed and preview Excel files in any website/web app. Just like PDF.js for pdf files. Check it out at https://spreadsheetpreview.com

Beautiful!

This looks really cool! Congrats on launching! It would be nice to display an animated GIF along with the sprite examples

Hello Hacker News!

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

Cool game! Reminds me of the untitled Goose Game, bullying citizens, is that a genre? It should definitely be a genre.

I am working on SpreadsheetPreview.com, a subscription service that gives you PNG previews of your uploaded spreadsheet (xlxs files).

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

I am working on a browser plugin that lets you edit Supabase database tables just like Excel, until it's ready. Then you switch to the main branch and the tables will be read only

Agree!

I am working on a platform called ikverdienbeter.nl (i deserve better) that educates people on recognizing healthy behaviour and healthy boundaries. I take snippets from popular tv, like dating shows, and mark the "red flags" on a timeline. For instance: "here at time 1:05 you see the woman gaslight the man. Gaslighting means [...]".

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.

Well not really obscure, but some want formulas, some want advanced filters, grouping/pivoting. Nothing that's not done before but you don't want to say yes to all these things as the product will lose its core identity and strength.

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 am working on DataGrid Toolkit. Based on my experiences building and selling (Excel like) data grids, people always look for your data grid, "but can it do this"? With DataGrid Toolkit, a developer can choose his own building blocks/modules and make a more Excel-like data grid, or make a more DataTables style traditional paginated table. The toolkit is headless and stateless by design and comes with different renderers. Canvas, html or some hybrid. It is written in Typescript and the data store is in Rust/Webassembly.

Very nice, nice set of constraints!

I think this website is beautiful in its simplicity

DataGridXL, an Excel-like data grid for JavaScript. The manual Excel-like step is not going anywere soon is my estimate. https://datagridxl.com

What a brilliant blog. Author puts a lot of love in it, that's clear! Thanks for sharing, read the whole thing. Made me feel kinda stupid for not using CSS Grid more... ;-)

Beautiful work

Cool project, it speaks to me! And I dig the emojis.

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 it! Thanks for sharing.

Hey OP,

Love the headline. Very confident ;-)

This is a very interesting article, thank you for the research!

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 :-)

What a beautiful website and what a fun read! Thanks for sharing!

Excellent work!

Like you said, there exists many chart libs out there already... Hope you find a way to sell and keep working on your product!

Neat idea!

DataGridXL is used by 10 million end users. It's tested on all kinds of devices and browser combinations.

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.

It's still true. You might be able to get decent performance on a Macbook 3000 (doubtful even) but anything less than that, nope. That's why many grid components use canvas rendering. It would have been a lot easier for all these grid devs to work with DOM nodes if they could.

Glide Grid is an amazing achievement I have to say!

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.

This is a big achievement, congrats! A lot of time must have been put into this I am sure. And you are also making a spreadsheet product AND a PDF (preview?) product? How do you combine it?

Noticed this too! Also, fun game!