anakic

19 ms·

151.
by anakic 11y ago
Yes, it will work on Office 2007, 2010, 2013 on both platforms (x86/x64)
152.
by anakic 11y ago
Point taken:) I have no idea where I got the "paint me xyz" from. Thanks for pointing it out, I changed it to "color me interested"
153.
by anakic 11y ago
Even basic SQL can make a lot of things easier in Excel, and SQL is not that complex so it might be doable. And the plugin is perfect for teaching SQL to someone, you can immediately see the effects of queries on data. Just sayin... :)
154.
by anakic 11y ago
Glad to hear your coworkers are excited!:) I'd love to support mac but unless excel 2016 includes VSTO, it won't be doable.
155.
by anakic 11y ago
Good question. Unfortunately no, not yet. It's not context sensitive, actually it's as dumb as a brick:) If you enter the name of a table followed by a dot, it will offer only the columns from the table. Other than that, it offers
156.
by anakic 11y ago
You are very welcome!:)
157.
by anakic 11y ago
It supports connecting to PostgreSQL and MSSQL currently. When you connect to an external engine it opens up a connection, and copies selected Excel tables as temp tables to the destination DB. This makes it easy to combine excel data with
158.
by anakic 11y ago
That's exactly the kind of response I was aiming for:) Thanks for saying that, it's amazing to read!
159.
by anakic 11y ago
Not much, the data will show up fine, by default ThingieQuery doesn't do anything magical with the workbook itself it just reads and if you want writes data to it. You can however explicitly embed a query into a workbook (it gets store
160.
by anakic 11y ago
Also, if you connect to an external database instead of using the built in SQLite engine, the dialect will be that of the database of course. It works a little differently in this mode though.
161.
by anakic 11y ago
Yeah, it uses SQLite under the hood. SQLite has a mechanism it calls "virtual tables" which I used to implement an adapter that lets it see Excel tables as database tables. I also implemented hash indexes in the adapter so joins a
162.
by anakic 11y ago
Sometimes you just want to manipulate data in your spreadsheed in place with the help of SQL but without having to go through the ceremony of importing and exporting to/from a database. For instance, with this plugin you can use regula
163.
by anakic 11y ago
You can, but it's clumsy. You can't target excel tables (only sheets and named ranges), no autocomplete and syntax highlighting. This addin also provides additional .NET funcitonality (e.g. regex match/replace, xpath, various
164.
by anakic 11y ago
Author here. I'm inclined to agree, the naming is poor, it didn't start out as a serious product, and I never changed the name. That said, you can at least use the trial licence (free for 30 days) and after that who knows, maybe I
165.
by anakic 12y ago
Thanks for the comment jcos. I'm not sure how to market to research labs, but I'll look into it:) As far as the cost, you can use it for free for 30 days so you can see how you like it, and if do, since you're a student, I&#x
166.
by anakic 12y ago
TY:)
167.
by anakic 12y ago
Thanks:) That was my intention when building it, empower the user considerably but maintain a minimal learning curve.
168.
Show HN: Fun with SQL inside Excel
6 points by anakic 12y ago|6 comments
169.
by anakic 12y ago
Thank you for the kind words, and I agree that it's pretty amazing:) Perhaps I should have posted text instead of a link, or a link to the tutorials (they're not on the website yet). It didn't get any attention for a couple o
170.
by anakic 12y ago
The SQL editor is a really cool open source library called AvalonEdit. It has it's own lexer (for syntax highlighting) and you just describe the terminals via regex and tell it what formatting to apply to each terminal. As for code com
171.
by anakic 12y ago
Yeah, that's a big one. Being able to use it in a REPL-esque manner without much ceremony is one nice thing. It also has other features you would expect from a SQL IDE: - syntax highlighting - code completion - partial query execution
172.
by anakic 12y ago
Hi baaron! I hear you, on both points. Point #1 - that's true, I never mention that the data needs to be in a table on the site, and it's a really good point which I will address ASAP. Point #2 - I didn't think many people w
173.
by anakic 12y ago
Oh wow, comments and upvotes, yay!:) The thread got no attention for two days, so I gave up and forgot about it, just saw the comments and the upvotes last night, nice.
174.
by anakic 12y ago
Hi all! So as a side project I developed a plugin that lets you do SQL inside Excel. It's called ThingieQuery (www.thingiequery.com). When you install ThingieQuery, you get a SQL IDE window inside Excel. It uses an embedded SQLite engi
175.
Show HN: I created an Excel plugin for using SQL inside Excel(thingiequery.com)
13 points by anakic 12y ago|10 comments