Click here to Skip to main content
13,091,363 members (58,924 online)
Click here to Skip to main content
Add your own
alternative version


15 bookmarked
Posted 28 Aug 2006

How to import Excel XML spreadsheets without interop

, 28 Aug 2006
Rate this:
Please Sign up or sign in to vote.
Simple way to import XML Excel spreadsheets into a DataTable.


Did you ever need to import Excel spreadsheets? If you did, you know there're sometimes problems with interop assemblies deploying to desktops and so.

Office 2003 offers to store spreadsheets in XML. So store your spreadsheet as XML and try to import them. Just include ExcelReader.cs in your project and use the SPOTX namespace. Then you'll be able to add the imported DataTable as datasource to your grid, like in the included example.

using SPOTX;

namespace ExcelImportTest
    public partial class MainForm : Form
        public MainForm()

        private void importXMLSpreadsheetToolStripMenuItem_Click(object sender, 
                     EventArgs e)
            //select file in dialog and then fill DataSOurce of main grid 
            if (ctlOfn.ShowDialog() == DialogResult.OK)
                this.ctlGridImport.DataSource = 

The first row in the imported Excel file are column headers. The method was tested on contiguous spreadsheets only. The code is clear enough I think, so adapting for .NET 1.1 consists only in replacing the Dictionary by Hashtable. Also modifying import to return collections or to omit column headers seems easy.

Hope this will help somebody.


This article, along with any associated source code and files, is licensed under The Code Project Open License (CPOL)


About the Author

Ondra Spilka
Software Developer (Senior) eLinkx
Czech Republic Czech Republic
Currently senior developer at eLinkx, started with C\C++ in industry software companies. Mainly .NET GUI, OR and application server frameworks.
Hobbies - Astronomy (selfmade Dobson f/6 1200mm), HW (Atmel51, ARM), Sport (paragliding, footbal, tennis, skiing, skating ... definitely I like all sports).
My family is wide - with my wife we have 3 kids.

You may also be interested in...


Comments and Discussions

GeneralRun time error Pin
Bruce_Kashani2-Oct-08 5:22
memberBruce_Kashani2-Oct-08 5:22 
QuestionSimple Question Pin
dandi1830-Apr-07 12:53
memberdandi1830-Apr-07 12:53 
AnswerRe: Simple Question Pin
Ondra Spilka14-May-07 20:34
memberOndra Spilka14-May-07 20:34 
GeneralVB 1.1 and add values to cols Pin
Holpit12-Sep-06 23:23
memberHolpit12-Sep-06 23:23 
Questionhmm [modified] Pin
jw12328-Aug-06 4:17
memberjw12328-Aug-06 4:17 
AnswerRe: hmm Pin
Ondra Spilka28-Aug-06 19:25
memberOndra Spilka28-Aug-06 19:25 
Generalfv Pin
one_minute_man28-Aug-06 4:02
memberone_minute_man28-Aug-06 4:02 

General General    News News    Suggestion Suggestion    Question Question    Bug Bug    Answer Answer    Joke Joke    Praise Praise    Rant Rant    Admin Admin   

Use Ctrl+Left/Right to switch messages, Ctrl+Up/Down to switch threads, Ctrl+Shift+Left/Right to switch pages.

Permalink | Advertise | Privacy | Terms of Use | Mobile
Web01 | 2.8.170813.1 | Last Updated 28 Aug 2006
Article Copyright 2006 by Ondra Spilka
Everything else Copyright © CodeProject, 1999-2017
Layout: fixed | fluid