Click here to Skip to main content
Click here to Skip to main content

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

About the Author

ksgopal
Web Developer
United Kingdom United Kingdom
No Biography provided

Comments and Discussions

 
GeneralExport to excel through user control Pinmemberpreetej30-Jul-08 19:38 
GeneralExport to Dataset PinmemberBarbaMariolino14-May-08 3:45 
Questionis it possible to use it withot the gui ? PinmemberMember 15181679-May-08 2:52 
AnswerRe: is it possible to use it withot the gui ? PinmemberCikaPero4-Sep-11 21:22 
Questionhow to view /access the exported dataset Pinmemberk.philip4-Oct-07 21:09 
AnswerRe: how to view /access the exported dataset Pinmemberk.philip4-Oct-07 21:15 
Questionhow to set datatype of imported Excel sheet Pinmemberjaganil1-Aug-07 2:01 
NewsUpdate to read csv and tab delimited files Pinmemberthe bill11-May-07 23:42 
GeneralRe: Update to read csv and tab delimited files PinmemberPeter Nevill18-Jul-07 19:58 
QuestionCode sometimes Wont get the OLEDB Schema PinmemberSimple but Effective15-Aug-06 0:55 
Questionhow to import Excel file data in c# PinmemberJayGosavi7-Aug-06 21:41 
AnswerRe: how to import Excel file data in c# Pinmemberalex.almeida4-Apr-07 10:21 
AnswerHi to all Pinmemberanuragji2001018-Jul-11 22:06 
GeneralAlternative way PinmemberJan Gex19-Dec-05 5:46 
GeneralNice Very Very Usefull Pinmembervivekthangaswamy7-Jul-05 23:29 
QuestionHow can I use dataset to Excel? PinmemberPeter Sze29-Dec-04 16:13 
AnswerRe: How can I use dataset to Excel? PinsussAnonymous15-Jun-05 22:54 
Generaldo you have code in VB.net Pinmemberkoonlee27-Aug-04 1:56 
GeneralOnly 255 chars PinmemberAl. Ceausu5-Aug-04 18:26 
GeneralRe: Only 255 chars Pinmemberjasperp30-May-07 20:06 
Generalnumeric field values are not retrieved PinmemberDaberElay30-Jul-04 0:06 
GeneralRe: numeric field values are not retrieved PinmemberDaberElay31-Jul-04 5:56 
GeneralRe: numeric field values are not retrieved PinmemberVinay K. Ladwal21-Aug-06 3:57 
GeneralRe: numeric field values are not retrieved PinmemberDaberElay21-Aug-06 9:26 
QuestionRe: numeric field values are not retrieved PinmemberVinay K. Ladwal22-Aug-06 0:29 

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.140721.1 | Last Updated 28 Nov 2003
Article Copyright 2003 by ksgopal
Everything else Copyright © CodeProject, 1999-2014
Terms of Service
Layout: fixed | fluid