Click here to Skip to main content
14,663,965 members
Office » MS-Excel

MS-Excel

Great Reads

by 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.
by Bert O Neill
Query Hadoop using Microsoft oriented technologies (C#, SSIS, SQL Server, Excel etc.)
by Lee P Richardson
Fighting File Downloads and Dinosaurs with NSwag via ASP.NET Boilerplate
by Geek2Simon
Use Excel worksheet's cells as pixels to render real image (for fun and experiment)

Latest Articles

by Darren G441
Two functions to help manipulate Excel sheets with VBA by converting Column Header letters to 1 based numbers and back
by NewPast
Excel, Pure VBA Macro: Molecular Weight/Molecular Mass Calculator
by Ri Xu
Golang library for reading and writing Microsoft Excel™ (XLSX) files.
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.

All Articles

Sort by Score

MS-Excel 

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 Dec 2015
Bert O Neill
Query Hadoop using Microsoft oriented technologies (C#, SSIS, SQL Server, Excel etc.)
30 Jul 2019
Lee P Richardson
Fighting File Downloads and Dinosaurs with NSwag via ASP.NET Boilerplate
30 Aug 2017
Geek2Simon
Use Excel worksheet's cells as pixels to render real image (for fun and experiment)
2 Jul 2016
Six Hat Solutions
Easily Send Emails From Your Microsoft Applications Using VBA and the SendGrid API
11 May 2015
markgwatts
Converting Sudoku Solver from Excel to C#
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.
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
12 Apr 2016
bradyguy
An end to end view of how to integrate Jira REST API's with Excel.
29 Jun 2010
Izhar Lotem
Filter and export to Excel ListView data using MVVM standards.
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.
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.
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.
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.
21 Jan 2015
Syed Umar Anis
ExcelXMLExport is a Microsoft Excel 2010 / 2013 Add-in that generates XML data from Excel sheet.
21 Feb 2012
Christian Leutloff
Comparison of the Excel Object Library and the native C# library NPOI to extract information from .xls files.
26 Aug 2017
Erik Drent
Simple POCO mapper for EPPlus
1 Nov 2018
Bahrudin Hrnjica
Export options in ANNdotNET
16 Apr 2013
Muhammed Anseer K K
Creating a metro style application with WCF
23 May 2018
yuvalsol
Create professional-looking Excels (Filters, Charts, Pivot Tables) with EPPlus
20 Mar 2018
Alex Pumpet
A simple program for compare table data from two sources - SQL databases, Excel, CSV or XML-files.
20 Feb 2019
JL Doty
App to monitor a system's sensors, with added features
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.
16 Jan 2018
Pragmateek
Using an Access, MySQL, PostgreSQL or SQLite Database from VBA
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
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
18 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.
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.
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 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.
2 Aug 2010
rajeshitpro
Excel XML Writer /Reader - Enables to generate Excel XML with hidden columns and lookups
3 Jun 2013
StewBob
This article gives a method for using Excel VBA to convert discrete data points into a histogram.
14 Nov 2014
Senthil Sambandam
Huge data transfer to Excel in a fast and efficient manner
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.
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.
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 Jun 2012
Antonio Lopez R
Create an Excel file from data table without Excel using Report Viewer control.
26 Jan 2015
Alexandros Pappas
This article proposes a way to do book-keeping for home use.
25 Jul 2017
Jose Segarra
A front-end library to create Excel files, including formatting and styling cells
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.
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.
2 Nov 2019
stc.reseller
How to stay secure by using Excel formulas instead of writing VBA code?
14 Jun 2018
paolo guccini
How to use the Microsoft Interop/Automation to implement parallel research of a Microsoft Office file password.
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)
21 Mar 2018
moneema14
Describes a generic approach which extracts object list of a given type from spreadsheet
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
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
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
2 Sep 2011
ComponentOne
A video that demonstrates OLAP for LightSwitch
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.
13 Dec 2019
Dirk_Strauss
In this article, I’ll demonstrate how to use Aspose.Cells to create a spreadsheet that takes advantage of a few new Excel 2019 features.
7 Mar 2012
Yiannis Spyridakis
This articles describes the implementation of functors (of sorts) for VBA using C++ ATL.
20 Sep 2011
Santx - Santosh
A simple description of LP and instructions to use Excel Solver for solving problems
15 Jan 2012
Al Moje
Upload Excel Spreadsheet File to Server, then Display Record(s) in Gridview
3 Jul 2012
Muammar©
Dynamic data retrieval from Oracle database to Excel sheet based on a parameter from Excel cell value
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.
20 Jul 2015
DriveByCoder
XLL Auto-Generation - An Example of a Metadata Driven Tool