Click here to Skip to main content
Click here to Skip to main content
Go to top

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.

Introduction

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()
        {
            InitializeComponent();
        }

        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 = 
                          SPOTX.ExcelReader.ReadExcelXML(ctlOfn.FileName);
        }
    }
}

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.

License

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

Share

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.

Comments and Discussions

 
GeneralRun time error PinmemberBruce_Kashani2-Oct-08 5:22 
QuestionSimple Question Pinmemberdandi1830-Apr-07 12:53 
AnswerRe: Simple Question PinmemberOndra Spilka14-May-07 20:34 
GeneralVB 1.1 and add values to cols PinmemberHolpit12-Sep-06 23:23 
Questionhmm [modified] Pinmemberjw12328-Aug-06 4:17 
AnswerRe: hmm PinmemberOndra Spilka28-Aug-06 19:25 
Generalfv Pinmemberone_minute_man28-Aug-06 4:02 

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

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

| Advertise | Privacy | Mobile
Web03 | 2.8.140922.1 | Last Updated 28 Aug 2006
Article Copyright 2006 by Ondra Spilka
Everything else Copyright © CodeProject, 1999-2014
Terms of Service
Layout: fixed | fluid