Login or Sign Up to become a member!
LessThanDot Site Logo

LessThanDot

A Technical Community for IT Professionals

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. Once you register for an account you will have immediate access to the forums and all past articles and commentaries.

Browsing "excel"

0

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”. […]

Read More...
0

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 […]

Read More...
22

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.

Read More...
0

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

Read More...
0

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 […]

Read More...
4

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 […]

Read More...
« Previous Page