Your users are probably used to Excel and how the filtering works, so why not mimic that style of filtering in your own applications? This tutorial shows how you can do it and includes the full source code.

A step-by-step tutorial on building an Excel 2007 VSTO add-in, using .Net, WPF and MVVM, the Ribbon and Custom Task Pane, to extend Office and create a friendly user interface to identify and highlight differences between two worksheets.

NPOI is a great open source project that enables us to create Excel spreadsheets in code using Microsoft .Net Framework. A reader of my blog commented on the post titled Creating Excel spreadsheets .XLS and .XLSX in C# about a problem he was having to get NPOI working with an Excel table bound to a ...

Every user of Microsoft Dynamics AX knows the possibility and the ease-of-use to copy-paste data from a Dynamics AX grid to a Microsoft Excel worksheet. However, as Dynamics AX developer, you can achieve the same through X++ code, with a lot of more possibilities. In this post, I show an example ...

Recently I had to implement some code to create an Excel spreadsheet/report using C#. The task was: given an Excel spreadsheet template - a .XLS file (with formulas, pivot tables, macros, etc) I had to fill some data in one of the sheets of the spreadsheet and send this modified spreadsheet back to...

Tool to create and access data from excel (*.xls and *.xlsx) as a collection of strongly typed objects

If you want to export some data into excel in ASP.Net without having Excel on your server a good way to do it is it use a GridView and ADO.Net to do this. There are a few little tricks/snags you can quickly hit, so I’m going to show a few I’ve found.

The example for writing the data to an array and sending it to a spreadsheet at http://support.microsoft.com/default.aspx?scid=kb;EN-US;306022 is great and where my thinking on this began. It was inadequate however to deal with datasets and the problems encountered in dynamic data.

While working with SharePoint VPC Image I got an error when I imported an Excel file for a custom list. The error says "This workbook has lost its VBA project, ActiveX controls and any other programmability-related features."

How to copy a formula to the whole column values in Excel

Anybody who has ever done any work with files, databases and so on, in C#, has had it drummed into them that they must be good citizens and always tidy up after themselves. Usually that means using using. But did you know that the using statement has uses that go far beyond resource cleanup?

See how to convert an excel graph with Paste2Xaml to a Silverlight application. To show the power of Silverlight we add a starup animation and a dynamicaly showing graph data on moving the mouse over graph's bars. The tutorial can be also used for WPF applications.

In this tutorial, learn how to import data from an Excel Spreadsheet to a Database by creating a tiered application architecture using Visual Studio's Typed DataSets and TableAdapters.

A free library which provides complete import, export of Excel Xml files with complete support for formatting, ranges, formulae etc.