Microsoft Excel Functions for SQL Server

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!

Comments (2)

  1. BuckWoody says:

    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

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

Skip to main content