Click here to Skip to main content
15,029,369 members
Everything / Productivity Apps and Services / Microsoft Office / Microsoft Excel

Microsoft Excel

MS-Excel

Great Reads

by Alex Pumpet
A simple program for comparing 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 William Hey
Classical number theories
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.

Latest Articles

by ITWeiHan
Excel (xlsx,csv) Micro-Helper to create or dynamic/type POCO mapping query, etc.
by W. García
VBA solution for CSV parsing problem
by Gustav Brock
Format amounts in VBA using the Indian number format for currency and amounts
by IvanFeng
With AutoExcel, you can quickly import and export Excel without hard coding, and embrace changes.

All Articles

Sort by Score

Microsoft Excel 

Please Sign up or sign in to vote.
20 Mar 2018
Alex Pumpet
A simple program for comparing table data from two sources - SQL databases, Excel, CSV or XML-files
Please Sign up or sign in to vote.
23 May 2018
yuvalsol
Create professional-looking Excels (Filters, Charts, Pivot Tables) with EPPlus
Please Sign up or sign in to vote.
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.
Please Sign up or sign in to vote.
29 Dec 2015
Bert O Neill
Query Hadoop using Microsoft oriented technologies (C#, SSIS, SQL Server, Excel etc.)
Please Sign up or sign in to vote.
25 Jun 2014
Shenwei Liu
Convert a generic list to an Excel byte array using Open XML SDK and dynamically create an Excel file for data distributions from an ASP.NET MVC website
Please Sign up or sign in to vote.
21 Jan 2015
Syed Umar Anis
ExcelXMLExport is a Microsoft Excel 2010 / 2013 Add-in that generates XML data from Excel sheet.
Please Sign up or sign in to vote.
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.
Please Sign up or sign in to vote.
12 Apr 2016
bradyguy
An end to end view of how to integrate Jira REST API's with Excel.
Please Sign up or sign in to vote.
30 Aug 2017
Geek2Simon
Use Excel worksheet's cells as pixels to render real image (for fun and experiment)
Please Sign up or sign in to vote.
21 Feb 2012
Christian Leutloff
Comparison of the Excel Object Library and the native C# library NPOI to extract information from .xls files.
Please Sign up or sign in to vote.
31 May 2016
William Hey
Semi-Prime Ordered Sequences (Part 2) is the follow-on to “Exploring Computational Number Theory (Part 1)” and describes a process for ordering the semi-prime base sequences.
Please Sign up or sign in to vote.
26 Aug 2017
Erik Drent
Simple POCO mapper for EPPlus
Please Sign up or sign in to vote.
25 Nov 2017
Daniel Carvalho Liedke
Project to generate Excel Spreadsheet from DataSet with auto size (AutoFit) columns, auto-filter, alternating light blue background color with Open XML using ASP.NET MVC
Please Sign up or sign in to vote.
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.
Please Sign up or sign in to vote.
16 Apr 2013
Muhammed Anseer K K
Creating a metro style application with WCF
Please Sign up or sign in to vote.
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.
Please Sign up or sign in to vote.
5 Jun 2014
Shenwei Liu
C# class that populates a generic list with data retrieved from Excel data file
Please Sign up or sign in to vote.
11 May 2015
markgwatts
Converting Sudoku Solver from Excel to C#
Please Sign up or sign in to vote.
29 Jun 2010
Izhar Lotem
Filter and export to Excel ListView data using MVVM standards.
Please Sign up or sign in to vote.
20 Feb 2019
JL Doty
App to monitor a system's sensors, with added features
Please Sign up or sign in to vote.
6 May 2018
Sam__Khan
Automated Craigslist parsing with Selenium using Node.js
Please Sign up or sign in to vote.
30 Jul 2019
Lee P Richardson
Fighting File Downloads and Dinosaurs with NSwag via ASP.NET Boilerplate
Please Sign up or sign in to vote.
2 Jul 2016
Six Hat Solutions
Easily Send Emails From Your Microsoft Applications Using VBA and the SendGrid API
Please Sign up or sign in to vote.
28 Oct 2019
stc.reseller
Helpful tips in labeling Office files or how to make Office file changes statistically visible, in one single step
Please Sign up or sign in to vote.
1 Jan 2016
HadyAllam
Use Microsoft Excel to generate TFS reports and Create/Modify Work Items
Please Sign up or sign in to vote.
1 Nov 2018
Bahrudin Hrnjica
Export options in ANNdotNET
Please Sign up or sign in to vote.
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
Please Sign up or sign in to vote.
21 Jun 2016
Dave “DWC” Curry
This tutorial will show you a good starting point for a WPF style framework which aims to make creating and maintaining Excel-worksheet-forms easier.
Please Sign up or sign in to vote.
1 Feb 2021
Gustav Brock
Format amounts in VBA using the Indian number format for currency and amounts
Please Sign up or sign in to vote.
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
Please Sign up or sign in to vote.
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
Please Sign up or sign in to vote.
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
Please Sign up or sign in to vote.
17 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.
Please Sign up or sign in to vote.
30 Dec 2019
Ri Xu
This post shows you how to import and export Excel XLSX in Go language.
Please Sign up or sign in to vote.
21 Mar 2018
moneema14
Describes a generic approach which extracts object list of a given type from spreadsheet
2 Sep 2011
ComponentOne
A video that demonstrates OLAP for LightSwitch
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.
Please Sign up or sign in to vote.
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.
Please Sign up or sign in to vote.
16 Jan 2018
Pragmateek
Using an Access, MySQL, PostgreSQL or SQLite Database from VBA
Please Sign up or sign in to vote.
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
Please Sign up or sign in to vote.
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
Please Sign up or sign in to vote.
30 Mar 2016
koolprasadd
Read write Excel file without interop using OLEDB in C#
Please Sign up or sign in to vote.
20 Sep 2011
Santx - Santosh
A simple description of LP and instructions to use Excel Solver for solving problems
Please Sign up or sign in to vote.
18 Sep 2018
Randy C Finch
A search for efficient algorithms to find Ruth-Aaron pairs
Please Sign up or sign in to vote.
22 May 2012
hevesir
A simple way to create your own Google map from several locations.
Please Sign up or sign in to vote.
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.
Please Sign up or sign in to vote.
1 Mar 2020
NewPast
Indent code, add line numbers, err handling, Add number to words and more, Expose a .NET library to Microsoft Word, Excel, Power Point macros writers and Access VBA code
Please Sign up or sign in to vote.
25 Jan 2011
Alexey Merson
This article demonstrates how to get the Excel Range object from the Clipboard using the CF_LINKSOURCE Clipboard format.
Please Sign up or sign in to vote.
9 May 2017
Muhammad_Faraz
Take HTML structure of a table & export to a genuine Excel file - Sever side processing
Please Sign up or sign in to vote.
12 Sep 2017
The Zakies
question answer chatbot using natural language parsing and web scrapping
Please Sign up or sign in to vote.
25 Nov 2016
JamesFaix
.NET library to access to any running instance of Excel.
Please Sign up or sign in to vote.
12 Aug 2019
Mohammed Dawood Ansari
"How to export the List into an Excel file" in a generic way using NPOI with .NET/.NET Core WEB API
Please Sign up or sign in to vote.
5 May 2016
Alex Chirokov
This article shows how to implement Sudoku solver in Excel using C# and Excel-DNA
Please Sign up or sign in to vote.
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.
Please Sign up or sign in to vote.
17 Aug 2016
Michael Ecklin
Very often, Excel spreadsheets are using to transfer data between applications. CSV files are also used for the same purposes.
Please Sign up or sign in to vote.
2 Aug 2010
rajeshitpro
Excel XML Writer /Reader - Enables to generate Excel XML with hidden columns and lookups
Please Sign up or sign in to vote.
20 Jul 2015
DriveByCoder
XLL Auto-Generation - An Example of a Metadata Driven Tool
Please Sign up or sign in to vote.
3 May 2016
Alex Chirokov
Adding interpolation functions to the Excel using C# and Excel-DNA
Please Sign up or sign in to vote.
25 Jun 2017
Roshan Choudhary
Creating ExcelSheet with dropdown containing pre populated dropdown data of its own excelsheet.
Please Sign up or sign in to vote.
3 Jun 2013
StewBob
This article gives a method for using Excel VBA to convert discrete data points into a histogram.
Please Sign up or sign in to vote.
3 Jul 2012
Muammar©
Dynamic data retrieval from Oracle database to Excel sheet based on a parameter from Excel cell value
Please Sign up or sign in to vote.
7 Mar 2012
Yiannis Spyridakis
This articles describes the implementation of functors (of sorts) for VBA using C++ ATL.
Please Sign up or sign in to vote.
15 Jan 2012
Al Moje
Upload Excel Spreadsheet File to Server, then Display Record(s) in Gridview
Please Sign up or sign in to vote.
25 Jul 2017
Jose Segarra
A front-end library to create Excel files, including formatting and styling cells
Please Sign up or sign in to vote.
14 Nov 2014
Senthil Sambandam
Huge data transfer to Excel in a fast and efficient manner
Please Sign up or sign in to vote.
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.
Please Sign up or sign in to vote.
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.
Please Sign up or sign in to vote.
13 Jan 2021
IvanFeng
With AutoExcel, you can quickly import and export Excel without hard coding, and embrace changes.
Please Sign up or sign in to vote.
20 Jun 2012
Antonio Lopez R
Create an Excel file from data table without Excel using Report Viewer control.
Please Sign up or sign in to vote.
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.
Please Sign up or sign in to vote.
26 Jan 2015
Alexandros Pappas
This article proposes a way to do book-keeping for home use.
Please Sign up or sign in to vote.
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.
Please Sign up or sign in to vote.
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.
Please Sign up or sign in to vote.
2 Nov 2019
stc.reseller
How to stay secure by using Excel formulas instead of writing VBA code?
Please Sign up or sign in to vote.
14 Jun 2018
paolo guccini
How to use the Microsoft Interop/Automation to implement parallel research of a Microsoft Office file password.
Please Sign up or sign in to vote.
17 Apr 2019
WasiUllah Khan
Automated Pakwheels parsing with Selenium and Python
Please Sign up or sign in to vote.
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)