Click here to Skip to main content

Office Development

Great Reads

by Waleed Elkot
Reading text from any image using Microsoft Office 2007 OCR.
by bollwerkj
This article shows you how I got Excel to work using C++/CLI in a Windows Forms Application
by Santhosh Kumar Jayaraman
Export a DataTable to an Excel file and add format to the contents while writing the Excel file.
by Jose Maria Estrade
ExcelCommunicator allows to pass and retrieve data to/from Excel as datasource/calculation-engine

Latest Articles

by Adam Tibi
Exposing .NET functions to be consumed as Excel functions, otherwise known in Excel as "User Defined Functions" . Those .NET exposed functions can be easily used from Excel's cells. This article presents two ways to achieve this and the pros and cons of each.
by Pragmateek
[toc] Introduction Note to pedantic guys: yes Access is not a database engine, only the graphical front-end to Jet/ACE, but we’ll stand with this simplification. The sample application (Excel + VBA) and the SQL source code are available in this … Continue reading →
by StewBob
This article gives a method for using Excel VBA to convert discrete data points into a histogram.
by Pragmateek
Introduction In this article I’ll show you how to create a UDF library for Excel in C# from scratch. By “from scratch” I mean without using Visual Studio, only low-level tools : a simple text-editor like Notepad and the C# … Continue reading →

Discussions

by wumo_518 on Article "ExcelFormat Library"
by NewPast.Net on Article "VBA Error Handler"
by pankulchitrav on tip/trick "Export DataTable to Excel with...
by iSwoop on Article "VBA Error Handler"
by Jose Del Castillo on Article "ExcelFormat Library"

All Articles