Today I was asked to do what seemed like a fairly simple task: Take an Excel 2003 file, add a couple of columns of data and save to a new Excel file programattically. I haven't done any coding Excel for AGES so this i what I did. To read in the file and add the extra columm and data I did the...

By now you've probably seen a lot of the brouhaha over a bug in the newest version of Excel, 2007. Basically, multiplying 77.1*850, which should give you 65,535, was actually displaying 100,000.

Excel 2007 has an interesting (though embarrassing) multiplication bug that ought to give developers quite some food for thought for some of the things that they take for granted ...

A very common requirement to an ASP .net application is to be able of generating dynamic reports in Excel Format. Here you have a selection of articles that tells you which options you have, and which of them you may not use when generating excel files from your web application.

This article provides a nice simple introduction to creating Excel spreadsheets with multiple worksheets programmatically from VB.NET Simple straight-forward tutorial with full source code.

Benchmark performance and analysis in MS Excel.

Did you know that Excel 2007 files are zipped up? Rename the xlsx extension to zip or rar and open it up in WinRAR or WinZip

If you use the Enterprise Architect edition of Microsoft Visio for data modeling regularly, then there is a good chance that at some point you’ve wanted to export just the table names into Excel. This tutorial will show you how to accomplish this task using the reporting features of Visio.

Este es un pequeño manual de como conectarnos a Analysis Services 2005 desde Excel 2007. Esta nuevo Microsoft Office Excel 2007 es una poderosa herramienta de análisis que nos permite a nosotros poder conectarnos a diferentes fuentes de datos ...

A very easy, time saving method for cleaning up records using excel. Helps you get your data from a unusable format, into a format that a database can understand. Excel example file included. This is based off of my HOWTO: Bulid a store locator...

Cool overview of how to write Open XML files on the server. This makes it real easy to create Excel 2007 files WITHOUT Excel!

ExcelPackage provides server-side generation of Excel 2007 spreadsheets. It is a set of classes and wrappers around the .NET 3.0 System.IO.Packaging API and the new Office Open XML file format. It extracts away the complexity of dealing with the individual XML components making it real easy to creat...

This one is an Excel add-in written in C# that adds functions to Excel to analyze your trading and manage your portfolio. Notice that I'm not a professional trader or statistician, so the whole thing could be wrong, buggy or conceptually absurd. Probably it is all of the above.

Rob Conery shows how to create a quick page that allows users to upload an Excel file and display it in a Grid.