Click here to Skip to main content
14,326,728 members

MS-Excel

Great Reads

by Alex Pumpet
A simple program for compare table data from two sources - SQL databases, Excel, CSV or XML-files.
by yuvalsol
Create professional-looking Excels (Filters, Charts, Pivot Tables) with EPPlus
by Kunal Chowdhury «IN»
Silverlight 4 has the feature to talk with Excel or any other application using the COM API. In this article, I will guide you to understand this feature step-by-step.
by Bert O Neill
Query Hadoop using Microsoft oriented technologies (C#, SSIS, SQL Server, Excel etc.)

Latest Articles

by essentialSQL
In this blog post, you will learn about stored procedures
by Lee P Richardson
Fighting File Downloads and Dinosaurs with NSwag via ASP.NET Boilerplate
by NewPast
Excel, Pure VBA Macro: Molecular Weight/Molecular Mass Calculator
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.. .

All Articles

Sort by Title

MS-Excel 

1 Dec 2010
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.
18 Aug 2011
Herre Kuijpers
A utility that allows you to enter simple and more complex mathematical formulas which will be evaluated and calculated on the spot
24 Feb 2019
WhiskeyBeforeWater
An unbalanced basic recursive Binary Search Tree for Excel VBA with functions (insert, search, delete, in order, pre-order, post-order, minimum, and maximum)
23 May 2018
yuvalsol
Create professional-looking Excels (Filters, Charts, Pivot Tables) with EPPlus
20 Feb 2019
JL Doty
App to monitor a system's sensors, with added features
14 Jun 2018
paolo guccini
How to use the Microsoft Interop/Automation to implement parallel research of a Microsoft Office file password.
14 Nov 2014
Senthil Sambandam
Huge data transfer to Excel in a fast and efficient manner
3 Sep 2013
Eric Reynolds
ExcelPython is a lightweight COM library which enables you to call Python code and manipulate Python objects from Excel VBA.
20 Mar 2018
Alex Pumpet
A simple program for compare table data from two sources - SQL databases, Excel, CSV or XML-files.
3 Jun 2013
StewBob
This article gives a method for using Excel VBA to convert discrete data points into a histogram.
11 May 2015
markgwatts
Converting Sudoku Solver from Excel to C#
20 Jun 2012
Antonio Lopez R
Create an Excel file from data table without Excel using Report Viewer control.
6 May 2010
Barath Balachandran
A method to send future updates/upgrades of your Office 2003 solutions to your end user seamlessly without any user intervention.
21 Feb 2012
Christian Leutloff
Comparison of the Excel Object Library and the native C# library NPOI to extract information from .xls files.
25 Jun 2014
Shenwei Liu
Converting a generic list to an Excel byte array using Open XML SDK and dynamically creating an Excel file for data distributions from an ASP.NET MVC website.
29 Jun 2010
Izhar Lotem
Filter and export to Excel ListView data using MVVM standards.
21 Jan 2015
Syed Umar Anis
ExcelXMLExport is a Microsoft Excel 2010 / 2013 Add-in that generates XML data from Excel sheet.
17 Aug 2012
Clifford Nelson
A framework for scanning a worksheet for headers, reading and validating data, providing feedback to the user, and displaying the data in a form with the results.
25 Jul 2017
Jose Segarra
A front-end library to create Excel files, including formatting and styling cells
10 Jun 2019
NewPast
Excel, Pure VBA Macro: Molecular Weight/Molecular Mass Calculator
30 Aug 2017
Geek2Simon
Use Excel worksheet's cells as pixels to render real image (for fun and experiment)
20 Sep 2011
Santx - Santosh
A simple description of LP and instructions to use Excel Solver for solving problems
2 Aug 2010
rajeshitpro
Excel XML Writer /Reader - Enables to generate Excel XML with hidden columns and lookups
12 Apr 2016
bradyguy
An end to end view of how to integrate Jira REST API's with Excel.
11 Oct 2013
ASP.NET Community
In this Article we are going to read and understand how in a web application we can export a gridview data into Excel file. As many times in real
11 Oct 2013
ASP.NET Community
 Here am trying to show how we can export an image to excel file.References Used: Microsoft.Office.Interop.Excel;Link for downloading the dlls
1 Nov 2018
Bahrudin Hrnjica
Export options in ANNdotNET
21 Dec 2011
Arif-Imran
Exporting data to Excel is an every day requirement for many solution providers. This article shows how to migrate your data to Excel using simple HTML.
22 Mar 2018
moneema14
Describes a generic approach which extracts object list of a given type from spreadsheet
30 Jul 2019
Lee P Richardson
Fighting File Downloads and Dinosaurs with NSwag via ASP.NET Boilerplate
7 Mar 2012
Yiannis Spyridakis
This articles describes the implementation of functors (of sorts) for VBA using C++ ATL.
25 Jan 2011
Alexey Merson
This article demonstrates how to get the Excel Range object from the Clipboard using the CF_LINKSOURCE Clipboard format.
30 Dec 2015
Bert O Neill
Query Hadoop using Microsoft oriented technologies (C#, SSIS, SQL Server, Excel etc.)
26 Jan 2015
Alexandros Pappas
This article proposes a way to do book-keeping for home use.
19 Sep 2018
Randy C Finch
A search for efficient algorithms to find Ruth-Aaron pairs
22 May 2012
hevesir
A simple way to create your own Google map from several locations.
5 Jun 2014
Shenwei Liu
Presenting and explaining an Open XML SDK Library based ExcelReader class for importing Excel data to a generic list through the object model mapping.
11 Oct 2013
ASP.NET Community
Hello All,Here I am posting code, which will read through a Excel Document. This code will traverse through all sheets of Excel spread sheet, No
2 Sep 2011
ComponentOne
A video that demonstrates OLAP for LightSwitch
16 Aug 2015
Bharath K A
Build your own cloud spreadsheet (like Microsoft Excel, google sheets) that exposes shreadsheet workbook via web browser. Users can create excel like spreadsheets using web browser save it, share it, put formulas to compute data in the sheet etc.
3 Jul 2012
Muammar©
Dynamic data retrieval from Oracle database to Excel sheet based on a parameter from Excel cell value
20 Nov 2013
Terence Wallace
Ordermate can be used as a basic example of utilizing the XMLSerializer class to automate the creation of invoice forms.
23 Jul 2013
Christian Del Bianco
Automate the process of set value to Excel cells, assigning a cell name that matches the query result column name, leaving the end user the possibility to change the layout template.
31 May 2010
Kunal Chowdhury «IN»
Silverlight 4 has the feature to talk with Excel or any other application using the COM API. In this article, I will guide you to understand this feature step-by-step.
16 Apr 2013
Muhammed Anseer K K
Creating a metro style application with WCF
26 Aug 2017
Erik Drent
Simple POCO mapper for EPPlus
2 Sep 2014
gjvdkamp
This is a minimalistic example of how WCF, Rx and Excel-DNA can be used to stream realtime data to an Excel client.
26 Sep 2014
Alvin Ashcraft
Last June, I reviewed the Aspose.Email for .NET component and demonstrated how to work with email messages in PST files or via IMAP. Well, I am back again for a look at another Aspose package. This one is Aspose.Cells for .NET.
3 Jul 2016
Six Hat Solutions
Easily Send Emails From Your Microsoft Applications Using VBA and the SendGrid API
18 Apr 2016
Alex_2979
A lot of modern Business Intelligence solutions offer to transfer work of analysts to developers or rise technical level of business analysts, make them closer to developers. Instead of it, I advise to consider a solution, which takes information from Database and gives it to business analysts.
16 Jan 2012
Al Moje
Upload Excel Spreadsheet File to Server, then Display Record(s) in Gridview
17 Jan 2018
Pragmateek
Using an Access, MySQL, PostgreSQL or SQLite Database from VBA
11 Oct 2013
ASP.NET Community
I’ve been heads down for the last several weeks Scrumming and it has been a while since I’ve updated my blog so I figured if I was going to keep your
13 Jun 2013
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.
30 Jul 2010
Danny Siew of Melbourne
Shows how to create an Excel 2007 document using C# and Open XML SDK 2.0 for Microsoft Office.
25 Mar 2013
Rajendra Kondapalli
This article will guide the developers on how you can connect to excel files using ADO.NET and modify the sheets
21 Jul 2015
DriveByCoder
XLL Auto-Generation - An Example of a Metadata Driven Tool