This is really neat - I read in SQL Server Magazine that a company called WestClinTech created a product that loads in tons of Excel functions into T-SQL. It's basically composed of SQLCLR functions that you load in, covering math, statistics, business functions and more. Very nice if your org uses Excel heavily - and who doesn't!

You must be logged in to post a comment.

PingBack from http://microsoft-sharepoint.simplynetdev.com/microsoft-excel-functions-for-sql-server/

Hi Buck,

I saw your post about WestClinTech providing Excel functions in SQL Server.

QueryCell is a product that I recently released, it kind of does the reverse, allows you to query excel data using SQL.

There is a short video introduction at http://www.querycell.com

I would be interested in any feedback you had, positive or negative.