5 ms·

This looks sleek and well-made! However, this is a pretty crowded space. Spreadsheet Converter (https://www.spreadsheetconverter.com https://www.spreadsheetconv

This looks sleek and well-made! However, this is a pretty crowded space. Spreadsheet Converter (https://www.spreadsheetconverter.com https://www.spreadsheetconverter.com) and Spreadsheet Web (https://www.spreadsheetweb.com https://www.spreadsheetweb.com) are directly comparable and have been around for years. (Like Publisheet, Spreadsheet Converter offers an Excel add-in.) Then there are lots of web app builders, including Calculoid (https://www.calculoid.com https://www.calculoid.com), Calconic (https://www.calconic.com https://www.calconic.com), uCalc Pro (https://ucalc.pro https://ucalc.pro) and Calcapp (https://www.calcapp.net/lp/website-calculators/ https://www.calcapp.net/lp/website-calculators/), that require more work to get from an Excel sheet to a web app, but get the job done with an end result that doesn't look like a spreadsheet. How does Publisheet improve on the competition? (Full disclosure: I'm a co-founder of Calcapp.)

samstave 7y ago
Ooohhhhhh i really like this info. Here is what i want, i want a cleaner way to parse a pdf into an xls or csv and be able to edit it on mobile .... Have any good references?
- 867-5309 7y ago
  you will probably need to hire someone to do that
- udayrddy 7y ago
  except the last part of "edit it on mobile", you can achieve it with https://extracttable.com https://extracttable.com Feel free to direct any questions to brain@extracttable.com
  - samstave 7y ago
    Is it brain or Brian?
    - udayrddy 7y ago
      brain On it, Sam.
  - samstave 7y ago
    Ive emailed you, let’s talk
  - sflanagan 7y ago
    Neat! Is your code open-source? Would you like help going mobile-friendly?
- mmatants 7y ago
  At least for parsing PDF into table I had decent success with Tabula.
netfl0 7y ago
Your website JavaScript was ruining my browser history. I had more then 10 entries and could not go “back”. Just a friendly heads-up.
- davidpolberger 7y ago
  Thanks, I see this behavior too. Interestingly enough, there's nothing on the page itself that can cause this behavior, this is all due to the sample calculator app embedded in an iframe element. We use the HTML5 History API to ensure that we can go "back" in an app which is run as a standalone app on Android when the system back button is pressed -- and there really isn't another way to go about it. (Not having the system back button go back would lead to a pretty terrible user experience when calculators are run as standalone apps.) However, we'll want to disable this behavior whenever apps are embedded in web pages -- I'll have a look at this later tonight. Again, thanks for reporting the bug!
- davidpolberger 7y ago
  This issue should now be fixed. Thanks again for reporting it!
tiagoalves 7y ago
When I started Publisheet, the idea was that it would allow users to create static, web-based reports from their spreadsheets, including textual information that would be written as Markdown (with a WYSIWYG editor) directly in one or more cells. I thought that it would be an easy way to create complete financial reports, for instance. The landing page's images still reflect that. But as soon as it launched, I noticed that no one was using it for text-heavy reports. People just wanted to publish their spreadsheets online, as is, with formula support. So, I started focusing on that and ended up in this crowded space, as you correctly state. I think that Publisheet's main selling point is that it's really simple to install and use. There's no .exe to install, there is no need to upload the Excel file in the browser, there is no form builder. Also, it works on Windows, Mac and in Excel Online. You basically click Publish and it's done. But I am aware that all the systems you listed are way more feature-complete than Publisheet and it is something we'll have to improve. By the way, congrats on Calcapp, it looks really polished!
- davidpolberger 7y ago
  That's an interesting pivot! We originally set out to enable healthcare apps to be created easily by doctors and nurses (we even had very complete unit test support at one point, which is important to get e-health apps through the certification process). It turned out, though, that financial calculators and the like made up a much larger part of the market, leading us to where we are today. It sounds like your journey has been similar, but with a different starting point. Best of luck with Publisheet, you're off to a good start!
- localhost 7y ago
  Interesting pivot; thanks for sharing that context. Did you get a chance to interview some of your customers to learn more about why the report-based workflow wasn't interesting to them? While spreadsheets can be used for narratives, they aren't exactly the best medium for them because of their multi-dimensional nature.
- airstrike 7y ago
  > including textual information that would be written as Markdown (with a WYSIWYG editor) directly in one or more cells. I thought that it would be an easy way to create complete financial reports, for instance. The landing page's images still reflect that. > But as soon as it launched, I noticed that no one was using it for text-heavy reports. I think the issue with that approach is that text-heavy reports don't perfectly overlap with the web. Speaking for basically all Wall St investment bankers out there, we spend our days generating reports from Excel into PowerPoint. If something existed for Excel + PowerPoint that worked similarly to RMarkdown + Rstudio > PDF, I think it would be a game changer, even if only used to generate a few of the more "automated" reports. There you go, free killer business idea for you ;-)
cm2187 7y ago
Are all these using a full excel calculation engine behind (like SpreadsheetGear or else)? I always thought that if I had lots of spare time, a good project would be to take a spreadsheet, specify the input cells and output cells, analyse the logic of the formulas in between, and generate automatically some code that replicates this calculation and can be compiled. That way you can preserve the logic in excel so a business user can own it, while getting all the performance and scalability of compiled code.
- sheetjs 7y ago
  Shameless plug: we (https://sheetjs.com/ https://sheetjs.com/) offer that as one of our paid builds. In conjunction with our JS parser https://github.com/SheetJS/js-xlsx https://github.com/SheetJS/js-xlsx , you can modify cell values / formulae and recalculate the workbook (or individual expressions) in the web browser or nodejs
- davidpolberger 7y ago
  The Calculoid people have publicly disclosed (https://github.com/calculoidapp/calculoidapp.github.io/wiki/Formula-Field https://github.com/calculoidapp/calculoidapp.github.io/wiki/...) they they're using this library for evaluating formulas: https://silentmatt.com/javascript-expression-evaluator/ https://silentmatt.com/javascript-expression-evaluator/ Through that library, they support a limited number of functions, which map more closely to the built-in Math object of JavaScript than to Excel. We (Calcapp) have a custom-written compiler, which our server uses as a library for checking formulas and producing JavaScript code. In 2016, we changed our formula syntax to be largely compatible with what Excel and other spreadsheets use (https://www.calcapp.net/blog/2016/06/02/formula-syntax.html https://www.calcapp.net/blog/2016/06/02/formula-syntax.html). We support 281 formula functions, most of them compatible with what spreadsheets offer (https://www.calcapp.net/learn/functions.html https://www.calcapp.net/learn/functions.html). We have around a thousand unit tests verifying that we get the same results as Excel. Thanks to our extensive function library, importing spreadsheets is often straight-forward (https://www.calcapp.net/blog/2017/06/14/convert.html https://www.calcapp.net/blog/2017/06/14/convert.html). (We don't do a good job of supporting table look-ups, though, and we will soon turn our focus towards solving that problem.) Our function library is released under the MIT license and is available on GitHub: https://github.com/davidpolberger/formulajs https://github.com/davidpolberger/formulajs It is a fork of an existing library (formulajs) and includes a fair number of bug fixes and improvements. At runtime, apps make use of a dependency graph generated by the compiler to ensure that calculations aren't run needlessly. As far as I'm aware, this is the same technique used by all spreadsheets. It would be straightforward to analyze a workbook and build a dependency graph to determine inputs and outputs. From there, an app could be generated. The only issue is inferring the user interface -- labels often appear to the left of the input and output cells, and while this could be used as a heuristic, it wouldn't be perfect. I've toyed with the idea of using machine learning to do a better job of inferring a user interface.
WhitneyLand 7y ago
Do any of these enable a drop dead simple web api to access the spreadsheet? For example, simple urls that could GET the data for a sheet, a row, selected area, etc. This could even be useful for non-developers. Last time I checked MS made made oauth part of accessing sheets in excel, which seems to add too much addiotnal complexity. It seems like a no auth option would be useful, and even for protected spreadsheets the experience could be much less complex.
- davidpolberger 7y ago
  I haven't tried these, but they claim to do what you want: https://sheety.co https://sheety.co https://sheetsu.com https://sheetsu.com https://sheetdb.io https://sheetdb.io https://sheetlabs.com/ https://sheetlabs.com/
- deleted 7y ago
  [deleted]
WrtCdEvrydy 7y ago
I wonder if there is a self hosted version of any of this stuff...
- davidpolberger 7y ago
  We (Calcapp) offer self-hosting as part of our corporate plan.

samstave 7y ago

Ooohhhhhh i really like this info. Here is what i want, i want a cleaner way to parse a pdf into an xls or csv and be able to edit it on mobile .... Have any good references?

867-5309 7y ago
you will probably need to hire someone to do that
udayrddy 7y ago
except the last part of "edit it on mobile", you can achieve it with https://extracttable.com https://extracttable.com Feel free to direct any questions to brain@extracttable.com
- samstave 7y ago
  Is it brain or Brian?
  - udayrddy 7y ago
    brain On it, Sam.
- samstave 7y ago
  Ive emailed you, let’s talk
- sflanagan 7y ago
  Neat! Is your code open-source? Would you like help going mobile-friendly?
mmatants 7y ago
At least for parsing PDF into table I had decent success with Tabula.

netfl0 7y ago

Your website JavaScript was ruining my browser history. I had more then 10 entries and could not go “back”. Just a friendly heads-up.

davidpolberger 7y ago
Thanks, I see this behavior too. Interestingly enough, there's nothing on the page itself that can cause this behavior, this is all due to the sample calculator app embedded in an iframe element. We use the HTML5 History API to ensure that we can go "back" in an app which is run as a standalone app on Android when the system back button is pressed -- and there really isn't another way to go about it. (Not having the system back button go back would lead to a pretty terrible user experience when calculators are run as standalone apps.) However, we'll want to disable this behavior whenever apps are embedded in web pages -- I'll have a look at this later tonight. Again, thanks for reporting the bug!
davidpolberger 7y ago
This issue should now be fixed. Thanks again for reporting it!

tiagoalves 7y ago

When I started Publisheet, the idea was that it would allow users to create static, web-based reports from their spreadsheets, including textual information that would be written as Markdown (with a WYSIWYG editor) directly in one or more cells. I thought that it would be an easy way to create complete financial reports, for instance. The landing page's images still reflect that. But as soon as it launched, I noticed that no one was using it for text-heavy reports. People just wanted to publish their spreadsheets online, as is, with formula support. So, I started focusing on that and ended up in this crowded space, as you correctly state. I think that Publisheet's main selling point is that it's really simple to install and use. There's no .exe to install, there is no need to upload the Excel file in the browser, there is no form builder. Also, it works on Windows, Mac and in Excel Online. You basically click Publish and it's done. But I am aware that all the systems you listed are way more feature-complete than Publisheet and it is something we'll have to improve. By the way, congrats on Calcapp, it looks really polished!

davidpolberger 7y ago
That's an interesting pivot! We originally set out to enable healthcare apps to be created easily by doctors and nurses (we even had very complete unit test support at one point, which is important to get e-health apps through the certification process). It turned out, though, that financial calculators and the like made up a much larger part of the market, leading us to where we are today. It sounds like your journey has been similar, but with a different starting point. Best of luck with Publisheet, you're off to a good start!
localhost 7y ago
Interesting pivot; thanks for sharing that context. Did you get a chance to interview some of your customers to learn more about why the report-based workflow wasn't interesting to them? While spreadsheets can be used for narratives, they aren't exactly the best medium for them because of their multi-dimensional nature.
airstrike 7y ago
> including textual information that would be written as Markdown (with a WYSIWYG editor) directly in one or more cells. I thought that it would be an easy way to create complete financial reports, for instance. The landing page's images still reflect that. > But as soon as it launched, I noticed that no one was using it for text-heavy reports. I think the issue with that approach is that text-heavy reports don't perfectly overlap with the web. Speaking for basically all Wall St investment bankers out there, we spend our days generating reports from Excel into PowerPoint. If something existed for Excel + PowerPoint that worked similarly to RMarkdown + Rstudio > PDF, I think it would be a game changer, even if only used to generate a few of the more "automated" reports. There you go, free killer business idea for you ;-)

cm2187 7y ago

Are all these using a full excel calculation engine behind (like SpreadsheetGear or else)? I always thought that if I had lots of spare time, a good project would be to take a spreadsheet, specify the input cells and output cells, analyse the logic of the formulas in between, and generate automatically some code that replicates this calculation and can be compiled. That way you can preserve the logic in excel so a business user can own it, while getting all the performance and scalability of compiled code.

sheetjs 7y ago
Shameless plug: we (https://sheetjs.com/ https://sheetjs.com/) offer that as one of our paid builds. In conjunction with our JS parser https://github.com/SheetJS/js-xlsx https://github.com/SheetJS/js-xlsx , you can modify cell values / formulae and recalculate the workbook (or individual expressions) in the web browser or nodejs
davidpolberger 7y ago
The Calculoid people have publicly disclosed (https://github.com/calculoidapp/calculoidapp.github.io/wiki/Formula-Field https://github.com/calculoidapp/calculoidapp.github.io/wiki/...) they they're using this library for evaluating formulas: https://silentmatt.com/javascript-expression-evaluator/ https://silentmatt.com/javascript-expression-evaluator/ Through that library, they support a limited number of functions, which map more closely to the built-in Math object of JavaScript than to Excel. We (Calcapp) have a custom-written compiler, which our server uses as a library for checking formulas and producing JavaScript code. In 2016, we changed our formula syntax to be largely compatible with what Excel and other spreadsheets use (https://www.calcapp.net/blog/2016/06/02/formula-syntax.html https://www.calcapp.net/blog/2016/06/02/formula-syntax.html). We support 281 formula functions, most of them compatible with what spreadsheets offer (https://www.calcapp.net/learn/functions.html https://www.calcapp.net/learn/functions.html). We have around a thousand unit tests verifying that we get the same results as Excel. Thanks to our extensive function library, importing spreadsheets is often straight-forward (https://www.calcapp.net/blog/2017/06/14/convert.html https://www.calcapp.net/blog/2017/06/14/convert.html). (We don't do a good job of supporting table look-ups, though, and we will soon turn our focus towards solving that problem.) Our function library is released under the MIT license and is available on GitHub: https://github.com/davidpolberger/formulajs https://github.com/davidpolberger/formulajs It is a fork of an existing library (formulajs) and includes a fair number of bug fixes and improvements. At runtime, apps make use of a dependency graph generated by the compiler to ensure that calculations aren't run needlessly. As far as I'm aware, this is the same technique used by all spreadsheets. It would be straightforward to analyze a workbook and build a dependency graph to determine inputs and outputs. From there, an app could be generated. The only issue is inferring the user interface -- labels often appear to the left of the input and output cells, and while this could be used as a heuristic, it wouldn't be perfect. I've toyed with the idea of using machine learning to do a better job of inferring a user interface.

WhitneyLand 7y ago

Do any of these enable a drop dead simple web api to access the spreadsheet? For example, simple urls that could GET the data for a sheet, a row, selected area, etc. This could even be useful for non-developers. Last time I checked MS made made oauth part of accessing sheets in excel, which seems to add too much addiotnal complexity. It seems like a no auth option would be useful, and even for protected spreadsheets the experience could be much less complex.

davidpolberger 7y ago
I haven't tried these, but they claim to do what you want: https://sheety.co https://sheety.co https://sheetsu.com https://sheetsu.com https://sheetdb.io https://sheetdb.io https://sheetlabs.com/ https://sheetlabs.com/
deleted 7y ago
[deleted]

WrtCdEvrydy 7y ago

I wonder if there is a self hosted version of any of this stuff...

davidpolberger 7y ago
We (Calcapp) offer self-hosting as part of our corporate plan.