Microsoft Excel

Microsoft

MS-Access

Quick and dirty reporting solution using Excel

21 Apr 2011 by Oshtri Deka

SQL

reporting

Launching a VB.NET Class Library from an MS-Office Excel Ribbon

9 Nov 2015 by veen_rp

A simple, step by step tutorial to set up an MS-Office Excel Ribbon, launch your own .NET applications from Excel and interact with the spreadsheet values.

Excel - Displaying Your Top Row as the Column Header

22 May 2017 by Bassam Abdul-Baki

This allows you to display in Excel column names other than A, B, C or 1, 2, 3 (R1C1) format.

Windows

Office

Another DatagridView for Windows Forms

21 Dec 2018 by Member 3471983

Add Filter Sort and Theme to a datagridview

XML

Copying DataGridView Contents To Clipboard

9 Nov 2012 by miteleda

Copy DataGridView contents to clipboard regardless of current selection.

Create Excel file from DataTable

4 Sep 2014 by ASP.NET Community

Here is a simplified class to create Excel file from DataTable just Pass DataTable and Preferred location on server to generate. Call the

DataTable

file

Deleting Headers in an Excel Document using C#

18 Apr 2020 by Saket Pawar

How to delete headers/certain strings in rows from your Excel file

Exporting a List of any type to Excel

9 Mar 2010 by Dan Mos

A few months ago I posted a article about exporting and formatting a datagridview to Excel.Well what about exporting a List to Excel?Sure, some may wonder but what's the point? Cause it's very easy to havelike a hidden dataGridView and when exporting one could easily add something...

Tip: Perform a Merge and Center With Excel Automation

19 Dec 2010 by Brian C Hart

You know that little "Merge and Center" button in Microsoft Excel? Here's how to 'click' it in C# with Excel Interop (and this carries over to VB etc, too).

Loading Excel data into a GridView

7 Oct 2011 by genious Developer

FileStream stream = File.Open(filePath, FileMode.Open, FileAccess.Read);//1. Reading from a binary Excel file ('97-2003 format; *.xls)IExcelDataReader excelReader = ExcelReaderFactory.CreateBinaryReader(stream);//...//2. Reading from a OpenXml Excel file (2007 format;...

Gridview

Export whole page to Excel with infragistics in ASP.NET C#

24 Oct 2011 by rj45

Export whole page to Excel with infragistics

infragistics

Export to Excel from GridView in C#

21 Feb 2012 by Sarvesh Kumar Gupta

Export to Excel from GridView in C#

export

Import Export Wizard

16 Mar 2012 by Sachin Chandanshive

Read / Write data from CSV to Excel

Addin With Useful Macros & Easily Accessible From Custom Ribbon Tab

13 Aug 2012 by Sachin Chandanshive

Addin Containg Useful Macros & Easily Accessible From Ribbon Menu

Reading an Excel Sheet into a DataTable, generic method

8 Feb 2014 by OriginalGriff

Reading a sheet into a database isn't difficult - it's just I keep forgetting how... :sigh: So I abstracted this from my working code so I wouldn't lose it again.

Spread Sheet Integrated Progress Bar

19 Apr 2015 by Bernster

How to use Excel conditional formatting features to simulate a progress bar in an Excel worksheet

Windows

Implementing CTPs in Excel 2010 and 2013 with Excel-DNA

13 Dec 2015 by Philippe Herremans

This tip describes a VB.NET program to implement Custom task panes in Excel 2010 and 2013 using Excel-DNA to integrate .NET into Excel.

ExcelDNA Packing Tool Manifest Writer

23 Feb 2016 by JamesFaix

Automated build tool for ExcelDNA projects to add referenced libraries to packed ExcelDNA add-in

Excel Interop, Subscripts and Superscripts

17 Aug 2017 by Dennis Wu CA

A demo that generates a simple Excel spreadsheet with subscripts and superscripts

Parsing CSV Files Directly from VBA

8 Mar 2021 by W. García

VBA solution for CSV parsing problem

CSV

Parse out controls from your html page.

27 Oct 2011 by rj45

You can simplify this by doing the following:/// /// Render/// /// protected override void Render(HtmlTextWriter writer){ if (Session[ExcelExport] != null && bool.Parse(Session[ExcelExport].ToString())) { ...

HTML

Parse out controls from your html page.

6 Nov 2011 by Kabwla.Phone

Tip - Never use type equality because that does not support derived classes:if (item.GetType() == typeof(Image)) //this is bad, mkay.Instead use the following which does support derived classes:if (item is Image)The Microsoft prefered pattern (when you actually need the cast object)...

HTML

Pasting excel data into an asp.net gridview

21 Dec 2011 by rj45

Pasting excel data into an asp.net gridview

Gridview

Dynamically Configure Excel in Foreach Loop Container

3 May 2012 by BIUser_2011

Configure Excel dynamically in foreach loop container

How to load data from multiple Excel sheets to any destination in SSIS

31 May 2012 by Smitha_Kalakoduvath

Load data present in multiple Excel sheets to an Excel sheet or any other destination.

Interactive Analysis and Related Tools

27 Jun 2012 by stormpy

Interactive analysis is a cycle analysis procedure of assumption, validation, and adjustment to achieve the fuzzy computation goal.

A Simple Way to Export DataGridViews/Lists to Excel

1 Nov 2012 by Pasan Eeriyagama

This article focuses on a Very simple and Robust way to export Data to EXCEL

SQL table data to Excel and open Excel on client side

18 Jan 2013 by joe_j

Export SQL table data into Excel and open the excel file on the client side.

Insert a Chart in Excel through Matlab

30 Jan 2013 by Kiran Chandrashekhar

This tutorial gives you a complete overview on how to insert a Chart to an Excel file through Matlab

MatLab

Beginner's Guide to PowerPivot for Excel

16 Jul 2013 by KumarM.NET

This tip explains the features of PowerPivot, a Business Intelligence tool provided by Microsoft. This is integrated with Office 2010 and provides capabilities to represent the data in various formats to business users.

Show only visible values in RadGridView filter popup

7 Aug 2013 by Predrag Radic

Show only visible values in RadGridView filter popup.

VBA : encrypted / password protected PDF for MS Office

19 May 2015 by algor-AG

VBA : encrypted / password protected PDF for MS Office

Converting Column Numbers to Range Headers and Vice Versa

2 Sep 2020 by Darren G441

Two functions to help manipulate Excel sheets with VBA by converting Column Header letters to 1 based numbers and back

MS Excel: Get Column Letter By Index/Index By Letter (2003/2007)

15 Nov 2010 by Niyazi Yarar

Helps developer to get excel column letter or index

XML

Excel NetworkDays for C#

6 Oct 2011 by Go Cova

public static int GetFullWorkingDaysBetween(DateTime firstDate, DateTime lastDate, IEnumerable holidays){ if (firstDate > lastDate)// Swap the dates if firstDate > lastDate { DateTime tempDate = firstDate; firstDate = lastDate; lastDate =...

time

DateTime

Directly embedding .CSS ( or strip it out ) instead of href link (Excel export part 2)

24 Oct 2011 by rj45

Directly embedding .CSS ( or strip it out ) instead of href link (Excel export part 2)

Export whole page to Excel with infragistics in ASP.NET C#

6 Nov 2011 by Kabwla.Phone

Tip: Change your loop to the following to also support derived classes:foreach (var item in controlList ){ GridView asGridView = item as GridView; if (asGridView != null) { Utilities.RenderControlInExcel(asGridView, workBook); } DetailsView asDetailsView =...

infragistics

Microsoft Excel BIFF8 Viewer

18 Jan 2012 by Jepy

Replace the last 3 blocks of code with:String.Format("{0:x}", value)

Non-FormControl Checkbox in Excel with VBA

26 Jul 2012 by Kudredin

How to use a normal Excel cell within a worksheet as a checkbox

Excel 2013 Power Pivot Sorting

4 Apr 2013 by Anupama Agarwal

How to do power pivot sorting in Excel 2013

reporting

Embed Charts, not Images into Slides

11 Sep 2013 by Celstream

Embed Charts, not Images into Slides

Writing Excel UDFs and Macros in Python with ExcelPython

22 Aug 2014 by Eric Reynolds

Learn how to easily substitute VBA with Python as Excel's scripting language with a library called ExcelPython

Quick Solution of Type Conversion Excel To sqlBulkUpload

1 Mar 2015 by vivektiwari97701

Datatype conversion in query (Excel query) add null column for unavailable field in destination database

C#3.5

Microsoft Excel: How to Comment Cells

21 May 2015 by Alexey Shtykov

Convert column numbers to range letters and add comments

A Very Basic Singely Linked List for VBA

16 Mar 2019 by WhiskeyBeforeWater

A nodular Singely Linked List for VBA with some basic functions

C# How To Read .xlsx Excel File With 3 Lines of Code

29 Jul 2014 by dietmar paul schoder

Read rows and cells from an xlsx-file: quick, dirty, effective.

How to Convert Excel to CSV using Interop

19 Nov 2013 by Tadit Dash (ତଡିତ୍ କୁମାର ଦାଶ)

This simple Tip will give you the Trick to convert Excel file to CSV file using Interop Services.

A Simple List Class for VBA Projects

16 Dec 2013 by Stefan Huy

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

Statistical Outliers Detection: Worksheet Solution

23 Mar 2019 by DrABELL

Statistical Outliers detection in Microsoft Excel worksheet using Median() and array formula

statistics

mathematics

Export HTML table to Excel With CSS

5 Apr 2014 by Er. Puneet Goel

Here is a quick code for how you can export the HTML table to Excel with CSS of table.

Export very large data to Excel file

27 Sep 2013 by Hisham Saber

This code solves the problem when exporting very large data size to Excel file.

Parse out controls from your html page.

24 Oct 2011 by rj45

Parse out controls from your html page.

HTML

DataSet to Excel File Conversion using ExcelLibrary

15 Jan 2012 by Robby Tendean

ExcelLibrary implementation sample to convert DataSet to Excel file in VB.NET

Leveraging the Benefits of Open XML

30 Jun 2013 by KumarM.NET

Leveraging the benefits of Open XML

XML

Intelligent Workbook for Generating Basic DAX Formulas used for Time Series Analysis of Measures

22 Aug 2014 by FLouis38

Intelligent workbook for generating time series DAX

SQL

artificial-intelligence

pivot

Microsoft

How to Check Whether Excel is Installed in the System or Not

7 Nov 2013 by Tadit Dash (ତଡିତ୍ କୁମାର ଦାଶ)

Here we will explore the trick to verify whether Excel is installed in the client's system or not by C#.

Working with Excel Using C#

18 Dec 2013 by Nanda Kumar Chintam

Demonstration of Excel manipulations using C#

List All Tables and Columns in a Database

20 Jul 2013 by AspDotNetDev

This query will show you all tables and columns in a database, and it can be pasted into Excel for easy manipulation.

SQL

SQL-Server

Save a Telerik Grid to Excel with Filtering

20 May 2014 by Duncan Edwards Jones

How to save a Silverlight Telerik grid content to Excel

Silverlight

Telerik

Excel Handling Using .NET C#

2 Mar 2016 by ArindamSarkar

Tips and tricks to quickly find out how to manipulate Excel using .NET Managed Code

Releasing Excel after using Interop

23 Mar 2011 by Igor Merabishvili

A small tip how to release Excel object after using Interop

Read Excel using NPOI

5 Nov 2015 by cwfong

Get Excel cell values as string

How to Add a Pivot Table to a Spreadsheet Using Excel Interop and C#

27 Jul 2016 by B. Clay Shannon

The most straightforward way to add a Pivot Table to an Excel sheet based on data already on the sheet, using Excel Interop and C#

Read and Write Excel Documents Using OLEDB

3 Jan 2014 by adriancs

Sample code for reading and writing Excel documents using OLEDB.

OleDb

Opening an Excel File with Multiple Sheets in a Windows Form using EP Plus

8 Feb 2017 by Shivi Gupta Lucknow

Using EP plus, an Excel file is loaded onto a Windows Form with multiple sheets as buttons aligned horizontally below the gird, to give the look and feel of an Excel sheet.

Handling Excel Lists with Interop

29 Sep 2015 by HP2M

This tip covers handling two Excel lists using Interop.

Excel NetworkDays for C#

25 Mar 2011 by Jani Giannoudis

Calculate the number of whole working days between start and end with support of holidays and holiday-periods.

Migrating Legacy Microsoft Access Database to Excel (or any other database) - Complete Application and Code

time

DateTime

1 Jun 2020 by rohitsies

Helps migrate your Microsoft Access database to Excel

Convert XML File to Excel File

27 Nov 2017 by Altaf Ansari

Converting XML Data into DataTable and Exporting DataTable into Excel File

Import a CSV File Into an Excel Workbook Programmatically

19 Dec 2010 by Brian C Hart

Code to call Excel Interop to take a Comma-Separated-Values (.CSV) file and suck it into your Excel workbook programmatically, and then Auto-Fit the resultant columns.

Elementary Arithmetic Generator (Excel Template) for Kids Math Practice or Whoever is Bored and Wants Some "real" Challenge

Creating Dynamic Grid-view Worked Like Excel Sheet

19 May 2015 by Rojalin Sahoo

Creating dynamic grid-view worked like an Excel sheet

Generate Excel Chart from Data in .NET Applications

3 Dec 2013 by LazyCoder0

This tip describes how to generate Excel charts from data in .NET applications using Office Automation.

Data Driven Testing by Excel Named Region

1 Aug 2013 by Raja.Krishnasamy

Data Driven Testing in MSTest by using Excel as data source and Named Region as table name instead of sheet name

10 Sep 2018 by simonp_ca

An Excel template, which provides unlimited basic arithmetic worksheets (random question generator), and answer sheets as well. All printer friendly formatted. Good for kids math practice.

I am writing another data import from the file and again I have to do the same validation or.. I will use this!

14 Oct 2017 by Krzysiek Wiśniewski

Nice solution for easy load data from files with extensions: .csv, .xls, .xlsx

Export to Excel from GridView in C#

11 Feb 2012 by Sarvesh Kumar Gupta

Export to Excel from GridView in C#

export

DataSet to Excel File Conversion using ExcelLibrary

1 Feb 2012 by Robert Hutch

Hi,another alternative is this Excel C# / VB.NET component that has limited free version that can be used in commercial applications and unlimited professional version.Here is an Excel VB.NET code how to export DataSet to Excel:Dim ef = New ExcelFile()For Each dataTable As...

Export an Excel File using ClosedXML

20 Jun 2016 by Passion4Code

How to export and Excel file using ClosedXML

CSV

Copy Data Between Excel Sheets using VBA

17 May 2017 by Maciej Los

This is an alternative for "Copy Rows Within Excel Sheets via VBA"

ADO

Export DataGridView to Excel

22 Nov 2012 by Michael Rosqvist

How to export a DataGridView to Excel.

Read an Excel File through Matlab

29 Jan 2013 by Kiran Chandrashekhar

This tutorial gives you a complete overview on how to read from an Excel file through Matlab

MatLab

Operating on Excel Cells and Cell Ranges with C#

11 Nov 2015 by B. Clay Shannon

How to obtain a reference to a range of Excel cells for manipulation and then do so (operate on the range)

Excel Macro to Generate Database Insert Script

19 Jul 2019 by Anurag Gandhi

An Excel macro that generates SQL insert script that can be executed against database directly

Releasing Excel after using Interop

22 Mar 2011 by Klaus Luedenscheidt

Alternatively, you can kill the Excel instance. I have to maintain an application which makes heavy use of Excel. I have written a wrapper for the base functionality. In the Dispose() method of the wrapper, I use the following code to ensure Excel will be released:mExcelApp.Quit(); // My...

Read Excel in ASP.NET

6 Jan 2012 by chetan virkar

Read Excel in ASP.NET

Export any page to Excel automatically

24 Oct 2011 by rj45

Export any page to Excel automatically

Write to Excel Sheet through Matlab

28 Jan 2013 by Kiran Chandrashekhar

This tutorial gives you a complete overview on how to write to an Excel file through Matlab.

MatLab

Excel Molar Mass Calculator - Molecular Weight

8 Mar 2020 by NewPast

Excel, Pure VBA Macro: Molecular Weight/Molecular Mass Calculator

Microsoft Excel BIFF8 Viewer

16 Jan 2012 by Robby Tendean

A tool for viewing Microsoft Excel BIFF8 binary format

Export DataTable To File Using C#

5 Apr 2020 by DiponRoy

Create a file like Excel, CSV, txt, etc. from a DataTable object using C#

CSV

Export to Excel 2007 Format (.xlsx) with Proper Formatting

7 Jul 2014 by Vishal.KumarSingh

Export Data from a Entity DataSource / GridView / Datatable in ASP.NET to Excel 2007(.xlsx) format with proper formatting and no warning messages

Use COM Interop to Create an Excel in MVC

3 May 2017 by V5709

This tip will provide one of the ways of generating Excel files using Microsoft COM interop in MVC project.

MVC

COM

Create an Excel spreadsheet from Datatable

13 Jul 2016 by Jerry Burch

Quickly create a spreadsheet from Datatable using Interop and the Clipboard

Loading Excel data into a GridView

2 Jan 2010 by Aman Bhullar

Here I am posting code, which will read through a Excel Document. This code will traverse through all sheets of Excel spread sheet, No matter what name they will have.This uses OLEDB connection to read through excel sheets.using System.Data.OleDb;protected void Page_Load(object...