MS-Excel

Great Reads

A Fast and Flexible Import and Export Tool for Excel

by IvanFeng

With AutoExcel, you can quickly import and export Excel without hard coding, and embrace changes.

A Handy-Dandy Little Class for Accessing Excel Worksheet Cells

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.

A Silverlight control to parse Excel data into a flat collection

by I.explore.code

A Simple List Class for VBA Projects

by Stefan Huy

For those who badly miss a .NET like List in VBA

Latest Articles

A Fast and Flexible Import and Export Tool for Excel

by IvanFeng

With AutoExcel, you can quickly import and export Excel without hard coding, and embrace changes.

A Handy-Dandy Little Class for Accessing Excel Worksheet Cells

by Brian C Hart

A Silverlight control to parse Excel data into a flat collection

by I.explore.code

A Simple List Class for VBA Projects

by Stefan Huy

For those who badly miss a .NET like List in VBA

All Articles

top

MS-Excel

A Fast and Flexible Import and Export Tool for Excel

by IvanFeng

With AutoExcel, you can quickly import and export Excel without hard coding, and embrace changes.

A Handy-Dandy Little Class for Accessing Excel Worksheet Cells

by Brian C Hart

A Silverlight control to parse Excel data into a flat collection

by I.explore.code

A Tiny Expression Evaluator

by Herre Kuijpers

A utility that allows you to enter simple and more complex mathematical formulas which will be evaluated and calculated on the spot

A Very Basic Recursive Binary Search Tree For Excel VBA

by 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)

Add a Turbocharged Data Grid to Your Angular Application

by Robert_Dyball

An article that explores how developers of enterprise web applications that need to display data in grids can use Wijmo FlexGrid, a mature, fully supported data grid.

Advanced Excels With EPPlus

by yuvalsol

Create professional-looking Excels (Filters, Charts, Pivot Tables) with EPPlus

App for CPU Temps, Fan Speeds, etc., Part II

by JL Doty

App to monitor a system's sensors, with added features

ASP.NET MVC - Generate Excel Spreadsheet from DataSet with Auto Size Columns, Auto-filter and Alternating Background Color

by Daniel 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

Automate multiple Excel instances

by JamesFaix

.NET library to access to any running instance of Excel.

Automated Document Conversion and Digital Transformation at Scale with ActivePDF DocConverter

by Jeremy Likness

DocConverter is so powerful that it can convert millions of documents per day while it automatically encrypts, signs, emails, and FTPs documents after they are processed.

Automating the Web with Selenium and Python

by WasiUllah Khan

Automated Pakwheels parsing with Selenium and Python

Brute Force Password Search by Interop/Automation

by paolo guccini

How to use the Microsoft Interop/Automation to implement parallel research of a Microsoft Office file password.

Bulk data Export to Excel from Datatable and Datagridview

by Senthil Sambandam

Huge data transfer to Excel in a fast and efficient manner

Calling Python code from Excel with ExcelPython

by Eric Reynolds

ExcelPython is a lightweight COM library which enables you to call Python code and manipulate Python objects from Excel VBA.

Comparator - Data Sources Comparer

by Alex Pumpet

A simple program for comparing table data from two sources - SQL databases, Excel, CSV or XML-files

Connect to TFS using Microsoft Excel

by HadyAllam

Use Microsoft Excel to generate TFS reports and Create/Modify Work Items

Converting discrete data points into a histogram using Excel VBA

by StewBob

This article gives a method for using Excel VBA to convert discrete data points into a histogram.

Converting Sudoku Solver from Excel to C#

by markgwatts

Converting Sudoku Solver from Excel to C#

Create an Excel file using Report Viewer control

by Antonio Lopez R

Create an Excel file from data table without Excel using Report Viewer control.

Create/Read/Edit Advance Excel 2007/2010 Report in C#.Net using EPPlus

by Debopam Pal

Export Advance Excel 2007 Report

Creating ExcelSheet with pre populated dropdown list using C# and OpenXML.

by Roshan Choudhary

Creating ExcelSheet with dropdown containing pre populated dropdown data of its own excelsheet.

Data Visualization for BI: How to Design Layouts for .NET Financial Reports

by Ethan Conner

With the Active Reports Server, you can have a multi-tenant environment where users from various departments, companies, or other specifications can log in, view their reports (and only their reports), export the data, or set up a distribution schedule for reports.

Deploying Office 2003 Solutions with Auto-update Functionality

by Barath Balachandran

A method to send future updates/upgrades of your Office 2003 solutions to your end user seamlessly without any user intervention.

Different Ways to Access Excel 2003 Workbooks using C#

by Christian Leutloff

Comparison of the Excel Object Library and the native C# library NPOI to extract information from .xls files.

Dynamically Creating Excel File from a Generic List for Email Attachment and Data Downloading

by 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

Enhanced ListView Operations Using MVVM

by Izhar Lotem

Filter and export to Excel ListView data using MVVM standards.

Excel Add-in for Exporting Data to XML

by Syed Umar Anis

ExcelXMLExport is a Microsoft Excel 2010 / 2013 Add-in that generates XML data from Excel sheet.

Excel Add-in Framework for Validating and Exporting Data

by 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.

Excel Files in JavaScript, the Simple Way

by Jose Segarra

A front-end library to create Excel files, including formatting and styling cells

Excel Pixelating Image Creator

by simonp_ca

Use Excel worksheet's cells as pixels to render real image (for fun and experiment)

Excel Solver and Linear Programming

by Santx - Santosh

A simple description of LP and instructions to use Excel Solver for solving problems

Excel XML Writer /Reader

by rajeshitpro

Excel XML Writer /Reader - Enables to generate Excel XML with hidden columns and lookups

Excel, Jira, Rest API end to end example

by bradyguy

An end to end view of how to integrate Jira REST API's with Excel.

Exploring Computational Number Theory (Part 1)

by William Hey

Classical number theories

Export GridView records to Excel

by 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

Export HTML Table Content to Excel - Server Side

by Muhammad_Faraz

Take HTML structure of a table & export to a genuine Excel file - Sever side processing

Export Image to Excel using c#

by 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

Export Options in ANNdotNET

by Bahrudin Hrnjica

Export options in ANNdotNET

Export to Excel using NPOI - C# and WEB API

by Mohammed Dawood Ansari

"How to export the List into an Excel file" in a generic way using NPOI with .NET/.NET Core WEB API

Exporting Data From DataGridView or Datatable to ExcelSheet Using HTML

by 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.

Extract .NET Object from Excel WorkSheet

by moneema14

Describes a generic approach which extracts object list of a given type from spreadsheet

Fighting File Downloads and Dinosaurs with NSwag (via ASP.NET Boilerplate)

by Lee P Richardson

Fighting File Downloads and Dinosaurs with NSwag via ASP.NET Boilerplate

Functors in VBA

by Yiannis Spyridakis

This articles describes the implementation of functors (of sorts) for VBA using C++ ATL.

Getting the Excel Range object from the Clipboard through the IStream interface

by Alexey Merson

This article demonstrates how to get the Excel Range object from the Clipboard using the CF_LINKSOURCE Clipboard format.

Hadoop For .Net & AngularJS Developers

by Bert O Neill

Query Hadoop using Microsoft oriented technologies (C#, SSIS, SQL Server, Excel etc.)

Home Book-keeping with Excel 2007

by Alexandros Pappas

This article proposes a way to do book-keeping for home use.

How Baseball Led to a Quest for Software Coding Optimization

by Randy C Finch

A search for efficient algorithms to find Ruth-Aaron pairs

How to create your own map on Google Maps

by hevesir

A simple way to create your own Google map from several locations.

How to Import and Export Excel XLSX in Go Language

by Ri Xu

This post shows you how to import and export Excel XLSX in Go language.

Importing Excel Data to a Generic List Using Open XML SDK and Object Model Mapping

by Shenwei Liu

C# class that populates a generic list with data retrieved from Excel data file

Indian Number Formatting of Currency in Microsoft Access and Excel

by Gustav Brock

Format amounts in VBA using the Indian number format for currency and amounts

Interpolation in Excel using Excel-DNA

by Alex Chirokov

Adding interpolation functions to the Excel using C# and Excel-DNA

Loading Excel data into a GridView

by 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

Online Spreadsheet, a low latency html5 websocket Cloud service (SaaS) in C# .net (as Google Sheets)

by 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.

Oracle data into Excel sheet

by Muammar©

Dynamic data retrieval from Oracle database to Excel sheet based on a parameter from Excel cell value

Ordermate

by Terence Wallace

Ordermate can be used as a basic example of utilizing the XMLSerializer class to automate the creation of invoice forms.

Read Write Excel file with OLEDB in C# (without Interop)

by koolprasad2003

Read write Excel file without interop using OLEDB in C#

Semi-Prime Ordered Sequences (Part 2)

by 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.

Set Excel cells value using cell name in C#

by 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.

Silverlight 4: Interoperability with Excel using the COM Object

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.

Simple Metro Style Application with WCF service and MS Excel Database

by Muhammed Anseer K K

Creating a metro style application with WCF

Simple POCO Mapper for EPPlus

by Erik Drent

A simple POCO mapper for EPPlus

Streaming realtime data to Excel

by gjvdkamp

This is a minimalistic example of how WCF, Rx and Excel-DNA can be used to stream realtime data to an Excel client.

Sudoku Solver in Excel using C# and Excel-DNA

by Alex Chirokov

This article shows how to implement Sudoku solver in Excel using C# and Excel-DNA

The Dew Review - Aspose.Cells for .NET

by 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.

The Six Hat Send Mail Class (Easily Send Email Using VBA)

by Six Hat Solutions

Easily Send Emails From Your Microsoft Applications Using VBA and the SendGrid API

This will not be in BI (Purchasing a BI tool, you do not get this)

by 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.

Time to Improve Your Excel Financial Models

by Mark_Nadelson

How can financial models built in Excel provide quicker and deeper insights by using Eikon Data API (DAPI), Python and xlwings to automate calculations?

Upload Excel Spreadsheet File to Server, then Display Record(s) in Gridview

by Al Moje

Upload Excel Spreadsheet File to Server, then Display Record(s) in Gridview

Using an Access, MySQL, PostgreSQL or SQLite Database from VBA

by Pragmateek

Using an Access, MySQL, PostgreSQL or SQLite Database from VBA

Using ASP.NET MVC and OpenXML api to stream Excel files.

by 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

Using C# .NET User Defined Functions (UDF) in Excel

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.

Using C# and Open XML SDK 2.0 for Microsoft Office to Create an Excel 2007 Document

by Danny Siew of Melbourne

Shows how to create an Excel 2007 document using C# and Open XML SDK 2.0 for Microsoft Office.

Using Excel 2019 Features in Aspose.Cells

by 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.

VBA or Complex formulas?

by stc.reseller

How to stay secure by using Excel formulas instead of writing VBA code?

Volume Serial Numbers (like for Windows Partitions) Applied to MS Office Files

by stc.reseller

Helpful tips in labeling Office files or how to make Office file changes statistically visible, in one single step

Web Browser Automation with Selenium using Node.js

by Sam__Khan

Automated Craigslist parsing with Selenium using Node.js

Work with Excel Documents on the Server

by Michael Ecklin

Very often, Excel spreadsheets are using to transfer data between applications. CSV files are also used for the same purposes.

Work with MS Excel and ADO.NET

by Rajendra Kondapalli

This article will guide the developers on how you can connect to excel files using ADO.NET and modify the sheets

Worksheet Forms using WPF style architecture

by 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.

XLL Auto-Generation - An Example of a Metadata Driven Tool

by DriveByCoder

XLL Auto-Generation - An Example of a Metadata Driven Tool