Click here to Skip to main content
12,239,992 members (64,276 online)
Click here to Skip to main content
Add your own
alternative version

Stats

211.8K views
8.7K downloads
66 bookmarked
Posted

Export excel data to a Dataset

, 27 Nov 2003
Rate this:
Please Sign up or sign in to vote.
A usercontrol that exports from excel to a dataset without needing MS office to be installed.

Introduction

If you ever need to add functionality to your application to enable you to export an excel file as a Dataset, instead of coding it by yourself, use this control. Using this you can let the user select the column names of the datatable in the exported Dataset. You can also restrict the user to select column names from a list of specified column names.

Background

This control uses System.Data.OleDbClient namespace to connect to the excel file as a data store. It doesn't need MS Excel to be installed on the computer.

Using the code

  1. Copy Gopal.Data.Transform.dll to your application folder. Right click on the toolbox and select 'Add/Remove components' as shown below.

  2. Now select 'ExcelExportControl' from 'Gopal.Data.Transform' assembly and press 'OK' as shown below.

  3. The 'ExcelExportControl' has now been added to the toolbox and can be used.

  4. This control will now allow you to load an excel file. You can select the first row as the column names by checking the checkbox which says so.
  5. The first tabpage lets you preview all the sheets in the excel file.

  6. The second tabpage lets you select an output dataset name, datatable name and column names too.

The download package has the source code, assembly and a demo form using the assembly.

License

This article has no explicit license attached to it but may contain usage terms in the article text or the download files themselves. If in doubt please contact the author via the discussion board below.

A list of licenses authors might use can be found here

Share

About the Author

ksgopal
Web Developer
United Kingdom United Kingdom
No Biography provided

You may also be interested in...

Comments and Discussions

 
GeneralExport to excel through user control Pin
preetej30-Jul-08 20:38
memberpreetej30-Jul-08 20:38 

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.

| Advertise | Privacy | Terms of Use | Mobile
Web02 | 2.8.160426.1 | Last Updated 28 Nov 2003
Article Copyright 2003 by ksgopal
Everything else Copyright © CodeProject, 1999-2016
Layout: fixed | fluid