What the...?

Something bad happened

We're not sure what, but we have a few guesses.

Problem: Object reference not set to an instance of an object.
Ticket: 7864836
Server: Web04
How to import Excel XML spreadsheets without interop - CodeProject Click here to Skip to main content
11,715,022 members (75,052 online)
Click here to Skip to main content

How to import Excel XML spreadsheets without interop

, 28 Aug 2006 CPOL 39K 509 15
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.

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    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 | Terms of Use | Mobile
Web04 | 2.8.150901.1 | Last Updated 28 Aug 2006
Article Copyright 2006 by Ondra Spilka
Everything else Copyright © CodeProject, 1999-2015
Layout: fixed | fluid