LessThanDot Site Logo


A decade of helpful technical content

Less Than Dot is a community of passionate IT professionals and enthusiasts dedicated to sharing technical knowledge, experience, and assistance. Inside you will find reference materials, interesting technical discussions, and expert tips and commentary.

Browsing "excel"

Learn About SQL Server 2008 R2 Project Gemini And Project Madison By Watching These Videos

Channel 9 has two videos up about Project Gemini And Project Madison. These two videos will give you a good overview what Gemini and Madison are all about. Both videos are available in a variety of formats Introduction to SQL Server Project Madison The SQL Server team is working on a new project code-named “Madison”. […]


Messing around with Office 2010, I like what I see

I installed Office 2010 last night and already I am liking it a lot after using it for about 30 minutes. There are some time savers in this release that will come in handy. This will be just a short post and I will only cover Excel 2010 and Word 2010. The first new thing […]


Export HTML table to Excel with grid lines

A programmatic example of how to export an HTML file to excel while keeping grid lines visible. This solution does not require the use of a COM object.


PerformancePoint Server To Become PerformancePoint Services In SharePoint Server

PerformancePoint Server To Become PerformancePoint Services In SharePoint Server Microsoft is consolidating the scorecard, dashboard, and analytical capabilities from PerformancePoint Server into SharePoint Server as PerformancePoint Services, making these capabilities available to millions of SharePoint users around the world. See the announcement here: http://blogs.msdn.com/bi/archive/2009/01/23/microsoft-bi-strategy-update.aspx You can also watch a video of the announcement here: http://www.microsoft.com/winme/0901/35195/Guy_Weismantel_BI_Announcement_MBR.asx


Financial Functions for .NET released

Luca Bolognese has released a .NET library that provides the full set of financial functions from Excel. The main goal for the library is compatibility with Excel, by providing the same functions, with the same behavior. Note though that this is not a wrapper over the Excel library; the functions have been re-implemented in managed […]


OPENROWSET And Excel Problems

Create an excel sheet In the first 2 rows put some data, save the excel sheet as testing.xls on the c drive Execute the command below T-SQL1 2 SELECT * FROM OPENROWSET( ‘Microsoft.Jet.OLEDB.4.0’, ‘Excel 8.0;Database=C:testing.xls’,’SELECT * FROM [Sheet1$]’) SELECT * FROM OPENROWSET( ‘Microsoft.Jet.OLEDB.4.0’, ‘Excel 8.0;Database=C:testing.xls’,’SELECT * FROM [Sheet1$]’) You will see 1 row since the […]

« Previous Page