Export excel data to a Dataset

ksgopal

Rate me:

4.48/5 (24 votes)

27 Nov 20031 min read

249.9K

9.6K

A usercontrol that exports from excel to a dataset without needing MS office to be installed.

gopal_data_transform.zip
- Gopal.Data.Transform
  - AssemblyInfo.cs
  - bin
    - Debug
    - Release
      - Gopal.Data.Transform.dll
  - CodeCommentReport
    - banner.htm
    - banner.jpg
    - CodeCommentReportError.htm
    - commentreport.css
    - darkcorner.jpg
    - Gopal.Data.Transform
      - CWP0.HTM
      - CWP10.HTM
      - CWP11.HTM
      - CWP12.HTM
      - CWP13.HTM
      - CWP14.HTM
      - CWP15.HTM
      - CWP16.HTM
      - CWP17.HTM
      - CWP18.HTM
      - CWP19.HTM
      - CWP2.HTM
      - CWP20.HTM
      - CWP21.HTM
      - CWP22.HTM
      - CWP23.HTM
      - CWP24.HTM
      - CWP25.HTM
      - CWP26.HTM
      - CWP27.HTM
      - CWP28.HTM
      - CWP29.HTM
      - CWP3.HTM
      - CWP30.HTM
      - CWP31.HTM
      - CWP32.HTM
      - CWP33.HTM
      - CWP34.HTM
      - CWP35.HTM
      - CWP37.HTM
      - CWP38.HTM
      - CWP39.HTM
      - CWP4.HTM
      - CWP40.HTM
      - CWP41.HTM
      - CWP42.HTM
      - CWP43.HTM
      - CWP44.HTM
      - CWP45.HTM
      - CWP46.HTM
      - CWP47.HTM
      - CWP48.HTM
      - CWP49.HTM
      - CWP5.HTM
      - CWP50.HTM
      - CWP51.HTM
      - CWP52.HTM
      - CWP53.HTM
      - CWP54.HTM
      - CWP55.HTM
      - CWP56.HTM
      - CWP57.HTM
      - CWP58.HTM
      - CWP59.HTM
      - CWP6.HTM
      - CWP60.HTM
      - CWP61.HTM
      - CWP62.HTM
      - CWP63.HTM
      - CWP64.HTM
      - CWP65.HTM
      - CWP66.HTM
      - CWP67.HTM
      - CWP68.HTM
      - CWP69.HTM
      - CWP7.HTM
      - CWP70.HTM
      - CWP71.HTM
      - CWP72.HTM
      - CWP73.HTM
      - CWP74.HTM
      - CWP75.HTM
      - CWP76.HTM
      - CWP77.HTM
      - CWP78.HTM
      - CWP79.HTM
      - CWP8.HTM
      - CWP80.HTM
      - CWP81.HTM
      - CWP82.HTM
      - CWP83.HTM
      - CWP84.HTM
      - CWP85.HTM
      - CWP86.HTM
      - CWP87.HTM
      - CWP88.HTM
      - CWP89.HTM
      - CWP9.HTM
      - CWP90.HTM
      - CWP91.HTM
      - CWP92.HTM
      - CWP93.HTM
      - Gopal.Data.Transform.HTM
    - gradleft.jpg
    - gradtop.jpg
    - graycorner.jpg
    - minus.jpg
    - plus.jpg
    - Solution_Gopal.Data.HTM
    - titletile.jpg
    - vt.js
  - ComboBoxDataGridColumn.cs
  - ExcelExportControl.bmp
  - ExcelExportControl.cs
  - ExcelExportControl.resx
  - Gopal.Data.sln
  - Gopal.Data.Transform.csproj
  - Gopal.Data.Transform.csproj.user
  - obj
    - Debug
      - temp
      - TempPE
    - Release
      - temp
      - TempPE
usageexample.zip
- UsageExample
  - App.ico
  - AssemblyInfo.cs
  - bin
    - Debug
    - Release
      - Gopal.Data.Transform.dll
      - UsageExample.exe
  - Form1.cs
  - Form1.resx
  - obj
    - Debug
      - temp
      - TempPE
    - Release
      - temp
  - UsageExample.csproj
  - UsageExample.csproj.user

<!-- saved from url=(0007)http:// -->
<HTML>
<HEAD>
<META http-equiv="Content-Type" content="text/html; charset=UTF-8">
<TITLE>Gopal.Data.Transform.FileLoadEventArgs.FileLoadEventArgs</TITLE>
<LINK REL=STYLESHEET HREF="../CommentReport.css" TYPE="text/css">
</HEAD>
<BODY topmargin=0 rightmargin=0 leftmargin=0 style="background-image: url(../titletile.jpg); background-repeat:repeat-x; background-position: 0 0;" >
<DIV CLASS="PageHeading">Gopal.Data.Transform.FileLoadEventArgs.FileLoadEventArgs Function</DIV>
<DIV CLASS="Description">

</DIV>
<IMG src="../GradLeft.jpg" width=7 height=378 alt="" border="0" style="position:absolute; left:10; top:18;z-Index:2">
<IMG src="../GradTop.jpg" width=352 height=7 alt="" border="0" align="top" style="position:absolute; left:10; top:18; z-index:1">
<DIV CLASS="Remarks">
<SPAN CLASS="RemarkHdrX">Public void FileLoadEventArgs (string)</SPAN></DIV>
<TABLE CLASS="InfoTable" cellpadding=0 cellspacing=0>
<TR height=20>
<TD width=20>&nbsp;</TD>
<TD valign=top align=left width=9 bgcolor="#cccc66"><IMG SRC="../graycorner.jpg" align=top></TD>
<TD CLASS="TableLightLabel" >Type</TD>
<TD CLASS="TableLightLabel" >Name</TD>
<TD CLASS="TableLightLabel" >Description</TD>
<TD width=20>&nbsp;</TD>
</TR>
<TR height=20>
<TD width=20>&nbsp;</TD>
<TD CLASS="TableLightDesc">&nbsp;</TD>
<TD CLASS="TableLightDesc">string</TD>
<TD CLASS="TableLightDesc">fileName</TD>
<TD CLASS="TableLightDesc">&nbsp;</TD>
<TD width=20>&nbsp;</TD>
</TR></TABLE>
<TABLE CLASS="InfoTable" cellpadding=0 cellspacing=0>
<TR height=20>
<TD width=20>&nbsp;</TD>
<TD valign=top align=left width=9 bgcolor="#cccc66"><IMG SRC="../graycorner.jpg" align=top></TD>
<TD CLASS="TableLightLabel" WIDTH=206>Return</TD>
<TD CLASS="TableLightLabel" >Description</TD>
<TD width=20>&nbsp;</TD>
</TR>
<TR height=20>
<TD width=20>&nbsp;</TD>
<TD CLASS="TableLightDesc">&nbsp;</TD>
<TD CLASS="TableLightDesc">void</TD>
<TD CLASS="TableLightDesc">&nbsp;</TD>
<TD width=20>&nbsp;</TD>
</TR></TABLE>
</BODY>
</HTML>

By viewing downloads associated with this article you agree to the Terms of Service and the article's licence.

If a file you wish to view isn't highlighted, and is a text file (not binary), please let us know and we'll add colourisation support for it.

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

Written By

ksgopal

Web Developer

United Kingdom

This member has not yet provided a Biography. Assume it's interesting and varied, and probably something to do with programming.

Export excel data to a Dataset

License

Comments and Discussions