anakic

Fala, Ivane:)

Back online now

Too bad about 8h of downtime in the middle of it trending, but yeah, can't complain too much about it:)

Would love to! There's a library called Math.NET that I wanted to look into, but never got around to it (plus, I forgot 99% of the math I learned in college so wouldn't know how to use it). Can you get in touch via email: antonio [at] querystorm.com?

Yeah:) Of course it happens while I'm asleep. Serves me right for loading the post with so many gifs... Back online now.

Oh man, limit happened while I was asleep. Thanks for the stopgap measure. Just got the bandwith limit removed with my hosting provider.

Hope you give it a go. I'd love to know how you get on with it if you do!

Would love to know how you get on with it. If you'd care to share, please to let me know.

Thanks for trying it and replying back here.

It looks like I was using a pre-release version of QueryStorm while I was writing the blog post. I just released that version so if you restart Excel you should get an "Update available" button in the QueryStorm ribbon in Excel.

Could you update and post back if that fixed the problem?

Another way of "fixing" it would be to replace the following line:

   (excel.Selection as Range).WriteTable(files, "myNewTable");

with this line:

   Write(files, "myNewTable");

The Write method is available globally (it's not a method that belongs to a class). This is a trick specific to C# scripts (would be illegal in regular C#).

The documentation does lack detail in some areas, which I basically cover by answering questions via email. I do need to invest time every so often to update and extend it.

I use Wix for the installer. Can't remember how I dealt with that particular issue, but ping me at antonio [at] querystorm.com in a day or two, if you're interested, and I'll have a look at how exactly I dealt with it.

I like that a gifs shows so much in very little space, but I take your point about it being distracting. Regular mp4 videos you can play/pause explicitly might be a better option for the future.

Unfortunately, no. Excel for Mac doesn't support either of the two technologies QueryStorm uses to talk to Excel (namely VSTO and ExcelDNA).

Might be possible to build something that would work across all plaforms using Blazor and the Monaco editor, but that would be another huge project.

Thanks! Wouldn't mind that outcome one bit. It's hard to get exposure and adoption for a platform like this without some serious muscle backing it. I suspect Microsoft has its sights set on the cloud, though, but still, it would be amazing if they adopted QueryStorm.

It's something to consider, for sure. Perhaps there's an easy win to be had there.

You mean add the workbook itself into the folder as binary file to include in source control? I haven't, but it might make sense, to keep the workbook in sync with the source code.