Skip to main content

Latest Articles: Excel

An Excel file Viewer in Silverlight 4
Entry Date: Jan 2010 site: Silverlight Show Rating:
keywords:Silverlight; Excel; Silverlight 3.0;
Article Description:
Let’s imagine a scenario in which you have a series of Excel files (.xlsx) on your computer but you don’t have any Microsoft Office installed. What can we do if we want to examine the content of these files?

How to read Excel 2007 (xlsx) content in Silverlight, great sample and article.

Click Here To Navigate to the Article

Reading/Writing to Excel 2007 from C# - Part I: Primer
Entry Date: Jan 2010 site: SADev Rating:
Article Description:
So the third way, the way I chose is the most raw method supported by the .NET Framework and has been supported since version 3.0. So what is a XLSX file? A XLSX file is actually just a ZIP file which contains a number of XML files in it.

Really good intro to XLSX parsing and processing inners.

Nice for Silverlight Developers, you can understand the core, grab SL CSharpZLib and start reading you xlsx excel files.

Click Here To Navigate to the Article

TFS and Excel – The Basics
Entry Date: Sep 2009 site: wordpress Rating:
keywords:Excel; TFS; Team Explorer;
Article Description:
Flicking through my blog stats on a Friday shows an interesting trend. On Friday my most common search term is generally “connecting to TFS in Excel”. This tells me 2 things – lots of reports are being written on a Friday, and there’s some demand for a starter guide for TFS and Excel integration!

Team Foundation Server for Managers... when your boss comes to your desk asking for adjusting work items... just ask him to install team explorer and show him the Excel Add-In, no more excuses :-).

Click Here To Navigate to the Article

Announcing the First CTP of Open XML SDK V2
Entry Date: Nov 2008 site: Blogs MSDN Rating:
keywords:Open XML; Office; .net framework 3.5; Excel;
Article Description:
Today, the development team for the Open XML SDK has announced that they have released the first Community Technology Preview (CTP) of version 2 of the Open XML SDK. Download it at There is a lot of very cool stuff in this release, including:
  • Strongly typed document object model (DOM).
  • Tool to compare two Open XML files.
  • Class explorer that helps you understand the markup and determine which classes to use in the strongly typed DOM.
  • Document reflector that can write a lot of your code for generating documents or content.

Open XML is a complex and weird format, you get all the full power of an office doc, but all the complexity as well. Building a doc or Excel Sheet from scratch it's a pain on the neck...

What if I tell that there is a tool that generated the needed .net code to build up an Excel or Word doc (just based on a template that you create on Word or Excel !), what if I tell you that this tool is free ? just available on the new Open XML SDK, the tool is called Document Reflector !!

A power combination is to use this reflector + functional programming (LINQ, Lambda Expressions, ...)

Click Here To Navigate to the Article

Reading and Writing Excel Spreadsheets Using ADO.NET C# DbProviderFactory
Entry Date: Oct 2008 site: David Hayden Rating:
keywords:Performance; ADO .net; Excel;
Article Description:

This week a client sent me an Excel Spreadsheet that needed to populate several tables in a SQL Server Database. To know me knows I hate data entry of any kind and there was no chance I was entering the Excel data in manually.

Thankfully, we don't have to. You can use the OleDb Managed Data Provider in the .NET Framework to read an Excel Spreadsheet using ADO.NET and C# just like you would with a database.


If you have to generate or read simple Excel content, ADO .net is a good choice, it can run on the server side and has a good performance.

Click Here To Navigate to the Article

How to format columns when exporting to excel in SSIS
Entry Date: Jan 2008 site: Cubido Rating:
keywords:SSIS; Office; Excel;
Article Description:

When exporting data to csv files, it is not possible to format columns when opening the csv file in excel without any macros or user actions. E.g. when you export the value 012 and open the file in Excel, the value will be displayed as 12. Even if you export the value as '012, "012" or "'012" the result after opening in Excel is not satisfying as the value is now shown as '012.


SSIS is a bit limited when generating Excel, you can just generate plain data.

This post explains you a trick to add formatting to your tabular reports, the tricks consists in format an Excel file and use it as template (Excel destination but not over a new file, write over an existing one). This solution won't work for all scenarios, and won't give you all the formatting that you expect, but at least it's something to try before going for a custom script task (XMLSS, Open XML, ...)

Click Here To Navigate to the Article

Convert XML to CSV, with XSL
Entry Date: Nov 2007 site: codeproject Rating:
keywords:XML; Office; XSL; HTML; Excel; CSV;
Article Description:
This VBScript will use the MSXML DLL from Microsoft to transform an XML file with XSL to a semi colon separated file, which can be easily imported in a host of other applications that are not completely XML aware yet.

How to convert XML into CSV using XSL.

It's written on vb script but you can reutilize the XSL template and use it on .net code.

Click Here To Navigate to the Article

How to XSLT CSV file revisited
Entry Date: Nov 2007 site: Tkachenko Rating:
keywords:XML; XSL; HTML; Excel;
Article Description:
Well, it's extremely well-chewed topic well-covered by many posters, but provided people keep asking it I feel I have to give a complete example of the most effective way (IMO) of solving this old recurring question - how to transform CSV or tab-delimited file using XSLT?
Good stuff

How to tranform your CSV (comma separated values) into e.g. HTML in two steps:

  • --> Use a free library to convert the CSV into XML in four lines of code (XMLCSVReader)
  • --> Apply an XSLT tranformation to that XML so you can get HTML, XAML, ...

Easy to use, you will get fast results.

Click Here To Navigate to the Article

Differences between using a workbook in Excel and Excel Services
Entry Date: Nov 2007 site: Office Ms Rating:
keywords:XML; Open XML; Office; HTML; Excel; DHTML;
Article Description:
Excel Services is primarily designed as a web-based, data-exploration and reporting system for Excel workbooks, and supports a subset of features in Microsoft Office Excel 2007. The following sections summarize which Office Excel 2007 features are supported and unsupported in Excel Services.

Excel services it's a quite powerful product, you get almost all excel (including charts) on a web browser, using a pure HTML solution (no ActiveX or strange stuff).

But is not 100 % Excel, it supports a subset of Open XML, this document highlights which features are supported by Excel Services and which not (e.g. Macros). Read it carefully before promising anything to your client ;-)

Click Here To Navigate to the Article

Package Explorer (Open XML)
Entry Date: Nov 2007 site: Codeplex Rating:
keywords:XML; Open XML; Office; Excel;
Article Description:

An extensive new version allowing full editing of packages, creating new packages and various other features.

An overview:

  • - Open existing Open XML packages
  • - Create new packages using templates
  • - Create new parts using templates
  • - Create relationships, internal and external
  • - View relationship part
  • - Create digital signatures and view them

OpenXML is quite powerful but complex, to start you will find a bunch of multipart files zipped

This free open source tool, is a must have to inspect OpenXML documents

Very useful to inspect/disect/analyze existing documents and to manipulate them (removing sections, ....). It will save you tons of ours of debugging trying to replicate the structure of an existing doc.

Click Here To Navigate to the Article

Read and write Open XML files (MS Office 2007) - Introduction
Entry Date: Nov 2007 site: Developer Fusion Rating:
keywords:XML; Open XML; Office; XSL; Excel;
Article Description:
This article will explain basics of Open XML file format and specifically XLSX format, the new format for Excel 2007. Presented is a demo application which writes / reads tabular data to / from XLSX files. Application is written in C# using Visual Studio 2005. Created XLSX files can be opened using Excel 2007 Beta (we used build 12.0.3820.1003).

Open XML short intro. Quite useful to get quickly an idea about what is Open XML about

In this article you will find a short intro to the format, and a WinForms demo that generates an Excel file.

About Open XML: Interesting combination of ZIP + XML + multipart files, to avoid the pitfalls of other XML formats (big size, images encoded as text, propietary format...), but... a bit complex to start with

Click Here To Navigate to the Article

Page (1) Of 3 Next Articles >>