I am trying to implement dashboard where i need to have HTML 5 spreadsheet ,which will be dynamic in nature, into my webpage/dashboard, i was looking into Spreads and Handsontable.
I still need to decide which one i will go with... If some has already used any of these, can you please tell me what are the pros and cons and which one should i go with?
Thanks for your help in advance.
That's a broad question, hard to answer. You don't specify what it's for or any other constraints. You didn't tell us how the data is inputted, how it gets validated, how it gets transformed, etc...
In short though, Handsontable is more lightweight than Spreads and easier to modify. However, it's less 'pretty' and requires more setting up as it uses table tags rather than a canvas. Not to mention one is free and the other isn't.
That's all the help I can give with such limited information.
Let me begin by pointing out some of the obvious differences between HandsOnTable and SpreadJS.
Think about your support options.
SpreadJS is a paid product and you can purchase maintenance with the license that is good for a year. This includes live phone support if you need assistance with the control, something that HandsOnTable doesn't offer.
I also noticed so major differences in formulas. I encourage you to browse through the formulas offered by SpreadJS located here
SpreadJS Formula Demo
and plug those into the HandsOnTable sample here
HandsOnSample enter code here
and you will notice that HandsOn doesnt support basic formula functionality.
SpreadJS has a complement component, ExeclIO, that is a webservice ( only supported in IIS ) that handles Excel workbook conversions and sends the JSON ( ssjson ) back to the client and loaded into the excel sheet. I am not sure how well HandsOn handles Excel conversions and if it does, I don't think the client will be able to handle the load of converting some large workbooks.
If you want to list some more specifics I will be glad to answer.
