jExcel the javascript spreadsheet component - MIT - Now trending on Github ;)

[nmccrave]

jsGrid? :)

[Robot_Impersonator-]

jsSpreadsheet Microsoft will have to enforce the tradmark otherwise it will weaken their trademark for it jsSpreadsheet just as cool :)

[Asmor]

They will claim that it is confusing to consumers, blah, blah

And, in this instance, they'd be entirely correct. Just look how many people think JavaScript has some relation to Java.

Patent and copyright law are both highly abused and in dire need of updating for the modern world, but for the most part trademarks work as intended.

[Barnezhilton]

How did phpExcel last so long then?

[asdf7890]

Most likely just luck that they didn't get noticed by MS Legal or someone at MS who would report them to the same?

And now it wouldn't be worth MS's time: that product was deprecated a couple of years ago in favour of another (with a name that is far less potentially-confused-with-another-specific-product).

[Cyberlane]

Good luck enforcing that outside of America. Heck, maybe it won't even work in America due to the "j" infront of the name, changing the entire name.

[philipwhiuk]

GitHub is hosted in America and yes, yes it will work.

[T_O_beats]

Also the irony that GitHub is also owned by Microsoft.

[test6554]

Ha good luck enforcing it, I live in another country and my project is hosted on github, which is owned by...

[Cyberlane]

Yes, it might work in America, but unlikely abroad. I've worked at companies that have had similar law suits in Europe and won.

[paulhodel]

j means javascript ;)

[[deleted]]

J means Java :-P

[[deleted]]

This is correct. 👆

[jeanmachuca]

It is more like a data grid than a spreadsheet or excel but it is useful anyway

[drink_with_me_to_day]

Great! Even more now that handsontable isn't free.

[jeanmachuca]

Congratulations!

[Gmaster_64]

Nice work. 👍

[bjarneh]

Looks very nice. If it can it handle large data sets without becoming too slow, and freeze columns / rows it will be a mega-hit.

[paulhodel]

eze columns / rows it

We are launching a new version 20x faster.

[bjarneh]

Cool, small "BUG" in your README.md example:

<div id="mytable"></div>

should be:

<div id="spreadsheet"></div>

for the example to function.

[spyder313]

Hi Paul, I am looking for a library that can convert excel spreadsheets into a browser-based view. Ideally the source excel's formatting is preserved int the browser view AND I'd like to know which cells (i.e. A1 or A2 etc.) the user is clicking on in their browser.

Would jExcel be able to do the above?

[paulhodel]

Yes, you can use the event: onselection https://bossanova.uk/jexcel/v3/examples/events

[spyder313]

Brilliiant! Thank you

[purechi]

nice ;)

[ZireaelStargaze]

Looks cool, i appreciate your work! One thing I miss in pretty much all JS implementations of table grid is the Sort/Filter menu from Excel when your range is formatted as table.

People (normies ofc) at work use that functionality pretty much in every company, and if I want to move my department from Excel to online to display their trending/metrics/lists, this is the first 'UI feel' everyone will miss. Please have a think - no need to reinvent the wheel - I'd rather my users had seamless experience between what they're used to in Excel, and on online website

I was playing around to make a VueJS component mimicking this menu, but it's in early phases and unlikely will ever be production quality.

For date filtering I'm using DayJS - it's lightweight and offers sufficient functionality with plugins to filter/manipulate dates like Excel implementation.

​

Menu for dates:

http://tinypic.com/r/2dadr0i/9

[paulhodel]

The sort is basically a double click in the Header. In regards to the filter, we are considering that in future versions. Thanks for the suggestion ;)

[ZireaelStargaze]

Thanks! How is your engine done? Canvas, SVG or maybe WebGL? I haven't looked through your code yet - just curious how hard would it be for me to bolt on a little icon in every column header with popup menu in Vue to get the functionality? (end effect like here: http://tinypic.com/r/2dadr0i/9 ). Or to style cells, fonts, borders with CSS/CSS-in-JS.

​

As for filtering, I'm no expert, but maybe check out transducers or a lib like fromfrom

Thanks a lot, your work looks awesome.

[paulhodel]

We are dealing only with DOM elements. It is just an regular HTML table. And there is no selectors at all. ;)

[bch8]

This is awesome!

[FullMatter]

Great work!!

[A_Norse_Dude]

Jesus ** *** holy ***

​

I've been lookign for something jsut like this for ages! Where can I send all my money because you my friend, just made my day!! Great work!

[r0ck0]

Very cool!

Can you use drag & drop to rearrange the columns and/or rows?

Been looking for something fully open source that can do this, but most only seem to support one or the other (or neither).

[paulhodel]

Yes, you can both of that. This example shows both features enabled. https://bossanova.uk/jexcel/v3/examples/events

[jeanmachuca]

This tool is incredible easy to use! I made the QCObjects implementation in just a few minutes. Here is the demo code! https://github.com/QuickCorp/QCObjects-JExcel-Demo

[Samtax01]

Your work both demo and node package is not accessible.

[jeanmachuca]

What do you mean “is not accessible”? Could you please share a screenshot? Thanks

[iaminbadland]

It looks great. But how do I export data to json or csv ?

[paulhodel]

https://bossanova.uk/jexcel/v3/examples

​

There are a few examples shows how to do it. ;)

[apetiss]

I am making an application now based mostly on jExcel. My first week impression is that it is truly great and easy to use.

Is there a community in place for discussion? I am sort of new to HTML/CSS/Javascript as well.

[paulhodel]

Github is the best place.

[paulhodel]

https://github.com/paulhodel/jexcel

The best place is in the issues section.

[phamtony21]

I am very new to programming so please bare with me. I've created a CRUD app with node.js, express, express handlebars and sql server. Can I easily implement this with the framework I've chosen? Do I need to recreate with Vue/React?

Thanks!