Click here to Skip to main content
65,938 articles
CodeProject is changing. Read more.
Everything / productivity / Office / MS-Excel

MS-Excel

MS-Excel

Great Reads

by IvanFeng
With AutoExcel, you can quickly import and export Excel without hard coding, and embrace changes.
by Brian C Hart
A class that accepts a reference to an Excel.Worksheet and lets you use an overloaded subscript operator to cleanly and intuitively read/write the Value2 of Excel cells, and get the Excel.Range corresponding to a given cell.
by Stefan Huy
For those who badly miss a .NET like List in VBA

Latest Articles

by IvanFeng
With AutoExcel, you can quickly import and export Excel without hard coding, and embrace changes.
by Brian C Hart
A class that accepts a reference to an Excel.Worksheet and lets you use an overloaded subscript operator to cleanly and intuitively read/write the Value2 of Excel cells, and get the Excel.Range corresponding to a given cell.
by Stefan Huy
For those who badly miss a .NET like List in VBA

All Articles

Sort by Score

MS-Excel 

by Pragmateek
How to scope your global state changes with IDisposable and the using statement
by PavelFedulov
Converting Mind Map Plan into an Excel Table
by YawerIqbal
Last week in a meeting client explained requirement: “.. we receive emails in a mail box, and we manually create contacts in CRM using sender name and address for further processing, we want to automate this.. .
by Steve L. Powell
XLLs are significantly faster, and allow the developer to define the names/parameters of the functions.
by Pragmateek
Excel addins troubleshooting guide
by Pragmateek
Excel UDF library in C# from stratch
by Steve L. Powell
This is a guide to writing custom functions in Excel
by Haseeb A. Basil
How can PHP import Excel to MySQL using a PHP XLSX Reader and Excel XLSX converter
by Lukasz Szyrmer
Figuring out your velocity and how to increase it has much greater business value (bringing release dates in) rather than trying to specify and estimate everything up front to the utmost detail.
by essentialSQL
In this blog post, you will learn about stored procedures
by Michael Banzon
Localization in Excel.
by Sifiso W Ndlovu
How TFS work items can be multi-tagged using Microsoft Excel
by Rajesh.Sitaraman
Export custom list items to Excel in SharePoint 2010.
by alex turner
How to do string concatenation in Excel formulae
by mopicus
Ultra fast Excel export component for MVC4