|
<!-- saved from url=(0007)http:// -->
<HTML>
<HEAD>
<META http-equiv="Content-Type" content="text/html; charset=UTF-8">
<TITLE>Gopal.Data.Transform.ExcelExportControl</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.ExcelExportControl Class</DIV>
<DIV CLASS="Description">
Host this control in your windows forms. This control lets the user select an excel file. preview it.
and then export it in to a dataset.The user can be provided the choice to select column names from a
given list of column names and specify dataset and datatble name.
<P>
</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">Access: </SPAN>Public</DIV>
<DIV CLASS="Remarks">
<SPAN CLASS="RemarkHdrX">Base Classes: </SPAN>UserControl</DIV>
<TABLE CLASS="InfoTable" cellpadding=0 cellspacing=0>
<TR height=20>
<TD width=20> </TD>
<TD valign=top align=left width=9 bgcolor="#cccc66"><IMG SRC="../graycorner.jpg" align=top></TD>
<TD CLASS="TableLightLabel" WIDTH=206>Members</TD>
<TD CLASS="TableLightLabel" >Description</TD>
<TD width=20> </TD>
</TR>
<TR height=20>
<TD width=20> </TD>
<TD CLASS="TableLightDesc"> </TD>
<TD CLASS="TableLightDesc"><A HREF="CWP17.HTM" TARGET="CNTFRAME">button1</A></TD>
<TD CLASS="TableLightDesc"> </TD>
<TD width=20> </TD>
</TR><TR height=20>
<TD width=20> </TD>
<TD CLASS="TableLightDesc"> </TD>
<TD CLASS="TableLightDesc"><A HREF="CWP18.HTM" TARGET="CNTFRAME">textBox1</A></TD>
<TD CLASS="TableLightDesc"> </TD>
<TD width=20> </TD>
</TR><TR height=20>
<TD width=20> </TD>
<TD CLASS="TableLightDesc"> </TD>
<TD CLASS="TableLightDesc"><A HREF="CWP19.HTM" TARGET="CNTFRAME">groupBox1</A></TD>
<TD CLASS="TableLightDesc"> </TD>
<TD width=20> </TD>
</TR><TR height=20>
<TD width=20> </TD>
<TD CLASS="TableLightDesc"> </TD>
<TD CLASS="TableLightDesc"><A HREF="CWP20.HTM" TARGET="CNTFRAME">tabControl1</A></TD>
<TD CLASS="TableLightDesc"> </TD>
<TD width=20> </TD>
</TR><TR height=20>
<TD width=20> </TD>
<TD CLASS="TableLightDesc"> </TD>
<TD CLASS="TableLightDesc"><A HREF="CWP21.HTM" TARGET="CNTFRAME">tabPage1</A></TD>
<TD CLASS="TableLightDesc"> </TD>
<TD width=20> </TD>
</TR><TR height=20>
<TD width=20> </TD>
<TD CLASS="TableLightDesc"> </TD>
<TD CLASS="TableLightDesc"><A HREF="CWP22.HTM" TARGET="CNTFRAME">tabPage2</A></TD>
<TD CLASS="TableLightDesc"> </TD>
<TD width=20> </TD>
</TR><TR height=20>
<TD width=20> </TD>
<TD CLASS="TableLightDesc"> </TD>
<TD CLASS="TableLightDesc"><A HREF="CWP23.HTM" TARGET="CNTFRAME">dataGrid1</A></TD>
<TD CLASS="TableLightDesc"> </TD>
<TD width=20> </TD>
</TR><TR height=20>
<TD width=20> </TD>
<TD CLASS="TableLightDesc"> </TD>
<TD CLASS="TableLightDesc"><A HREF="CWP24.HTM" TARGET="CNTFRAME">groupBox2</A></TD>
<TD CLASS="TableLightDesc"> </TD>
<TD width=20> </TD>
</TR><TR height=20>
<TD width=20> </TD>
<TD CLASS="TableLightDesc"> </TD>
<TD CLASS="TableLightDesc"><A HREF="CWP25.HTM" TARGET="CNTFRAME">radioButton2</A></TD>
<TD CLASS="TableLightDesc"> </TD>
<TD width=20> </TD>
</TR><TR height=20>
<TD width=20> </TD>
<TD CLASS="TableLightDesc"> </TD>
<TD CLASS="TableLightDesc"><A HREF="CWP26.HTM" TARGET="CNTFRAME">groupBox3</A></TD>
<TD CLASS="TableLightDesc"> </TD>
<TD width=20> </TD>
</TR><TR height=20>
<TD width=20> </TD>
<TD CLASS="TableLightDesc"> </TD>
<TD CLASS="TableLightDesc"><A HREF="CWP27.HTM" TARGET="CNTFRAME">textBox2</A></TD>
<TD CLASS="TableLightDesc"> </TD>
<TD width=20> </TD>
</TR><TR height=20>
<TD width=20> </TD>
<TD CLASS="TableLightDesc"> </TD>
<TD CLASS="TableLightDesc"><A HREF="CWP28.HTM" TARGET="CNTFRAME">radioButton3</A></TD>
<TD CLASS="TableLightDesc"> </TD>
<TD width=20> </TD>
</TR><TR height=20>
<TD width=20> </TD>
<TD CLASS="TableLightDesc"> </TD>
<TD CLASS="TableLightDesc"><A HREF="CWP29.HTM" TARGET="CNTFRAME">checkBox1</A></TD>
<TD CLASS="TableLightDesc"> </TD>
<TD width=20> </TD>
</TR><TR height=20>
<TD width=20> </TD>
<TD CLASS="TableLightDesc"> </TD>
<TD CLASS="TableLightDesc"><A HREF="CWP30.HTM" TARGET="CNTFRAME">button2</A></TD>
<TD CLASS="TableLightDesc"> </TD>
<TD width=20> </TD>
</TR><TR height=20>
<TD width=20> </TD>
<TD CLASS="TableLightDesc"> </TD>
<TD CLASS="TableLightDesc"><A HREF="CWP31.HTM" TARGET="CNTFRAME">openFileDialog1</A></TD>
<TD CLASS="TableLightDesc"> </TD>
<TD width=20> </TD>
</TR><TR height=20>
<TD width=20> </TD>
<TD CLASS="TableLightDesc"> </TD>
<TD CLASS="TableLightDesc"><A HREF="CWP32.HTM" TARGET="CNTFRAME">comboBox1</A></TD>
<TD CLASS="TableLightDesc"> </TD>
<TD width=20> </TD>
</TR><TR height=20>
<TD width=20> </TD>
<TD CLASS="TableLightDesc"> </TD>
<TD CLASS="TableLightDesc"><A HREF="CWP33.HTM" TARGET="CNTFRAME">components</A></TD>
<TD CLASS="TableLightDesc">
Required designer variable.
<P>
</TD>
<TD width=20> </TD>
</TR><TR height=20>
<TD width=20> </TD>
<TD CLASS="TableLightDesc"> </TD>
<TD CLASS="TableLightDesc"><A HREF="CWP34.HTM" TARGET="CNTFRAME">State</A></TD>
<TD CLASS="TableLightDesc"> </TD>
<TD width=20> </TD>
</TR><TR height=20>
<TD width=20> </TD>
<TD CLASS="TableLightDesc"> </TD>
<TD CLASS="TableLightDesc"><A HREF="CWP38.HTM" TARGET="CNTFRAME">FileName</A></TD>
<TD CLASS="TableLightDesc"> </TD>
<TD width=20> </TD>
</TR><TR height=20>
<TD width=20> </TD>
<TD CLASS="TableLightDesc"> </TD>
<TD CLASS="TableLightDesc"><A HREF="CWP39.HTM" TARGET="CNTFRAME">CurrentTable</A></TD>
<TD CLASS="TableLightDesc"> </TD>
<TD width=20> </TD>
</TR><TR height=20>
<TD width=20> </TD>
<TD CLASS="TableLightDesc"> </TD>
<TD CLASS="TableLightDesc"><A HREF="CWP40.HTM" TARGET="CNTFRAME">CurrentSheet</A></TD>
<TD CLASS="TableLightDesc"> </TD>
<TD width=20> </TD>
</TR><TR height=20>
<TD width=20> </TD>
<TD CLASS="TableLightDesc"> </TD>
<TD CLASS="TableLightDesc"><A HREF="CWP41.HTM" TARGET="CNTFRAME">CurrentState</A></TD>
<TD CLASS="TableLightDesc"> </TD>
<TD width=20> </TD>
</TR><TR height=20>
<TD width=20> </TD>
<TD CLASS="TableLightDesc"> </TD>
<TD CLASS="TableLightDesc"><A HREF="CWP42.HTM" TARGET="CNTFRAME">dataGrid2</A></TD>
<TD CLASS="TableLightDesc"> </TD>
<TD width=20> </TD>
</TR><TR height=20>
<TD width=20> </TD>
<TD CLASS="TableLightDesc"> </TD>
<TD CLASS="TableLightDesc"><A HREF="CWP43.HTM" TARGET="CNTFRAME">checkBox2</A></TD>
<TD CLASS="TableLightDesc"> </TD>
<TD width=20> </TD>
</TR><TR height=20>
<TD width=20> </TD>
<TD CLASS="TableLightDesc"> </TD>
<TD CLASS="TableLightDesc"><A HREF="CWP44.HTM" TARGET="CNTFRAME">TitleText</A></TD>
<TD CLASS="TableLightDesc"> </TD>
<TD width=20> </TD>
</TR><TR height=20>
<TD width=20> </TD>
<TD CLASS="TableLightDesc"> </TD>
<TD CLASS="TableLightDesc"><A HREF="CWP45.HTM" TARGET="CNTFRAME">textBox3</A></TD>
<TD CLASS="TableLightDesc"> </TD>
<TD width=20> </TD>
</TR><TR height=20>
<TD width=20> </TD>
<TD CLASS="TableLightDesc"> </TD>
<TD CLASS="TableLightDesc"><A HREF="CWP46.HTM" TARGET="CNTFRAME">label1</A></TD>
<TD CLASS="TableLightDesc"> </TD>
<TD width=20> </TD>
</TR><TR height=20>
<TD width=20> </TD>
<TD CLASS="TableLightDesc"> </TD>
<TD CLASS="TableLightDesc"><A HREF="CWP47.HTM" TARGET="CNTFRAME">label2</A></TD>
<TD CLASS="TableLightDesc"> </TD>
<TD width=20> </TD>
</TR><TR height=20>
<TD width=20> </TD>
<TD CLASS="TableLightDesc"> </TD>
<TD CLASS="TableLightDesc"><A HREF="CWP48.HTM" TARGET="CNTFRAME">OutputColumnNames</A></TD>
<TD CLASS="TableLightDesc"> </TD>
<TD width=20> </TD>
</TR><TR height=20>
<TD width=20> </TD>
<TD CLASS="TableLightDesc"> </TD>
<TD CLASS="TableLightDesc"><A HREF="CWP49.HTM" TARGET="CNTFRAME">ExportMappingTableName</A></TD>
<TD CLASS="TableLightDesc"> </TD>
<TD width=20> </TD>
</TR><TR height=20>
<TD width=20> </TD>
<TD CLASS="TableLightDesc"> </TD>
<TD CLASS="TableLightDesc"><A HREF="CWP50.HTM" TARGET="CNTFRAME">ExportMappingExcelColumnName</A></TD>
<TD CLASS="TableLightDesc"> </TD>
<TD width=20> </TD>
</TR><TR height=20>
<TD width=20> </TD>
<TD CLASS="TableLightDesc"> </TD>
<TD CLASS="TableLightDesc"><A HREF="CWP51.HTM" TARGET="CNTFRAME">ExportMappingOutputColumnName</A></TD>
<TD CLASS="TableLightDesc"> </TD>
<TD width=20> </TD>
</TR><TR height=20>
<TD width=20> </TD>
<TD CLASS="TableLightDesc"> </TD>
<TD CLASS="TableLightDesc"><A HREF="CWP52.HTM" TARGET="CNTFRAME">pictureBox1</A></TD>
<TD CLASS="TableLightDesc"> </TD>
<TD width=20> </TD>
</TR><TR height=20>
<TD width=20> </TD>
<TD CLASS="TableLightDesc"> </TD>
<TD CLASS="TableLightDesc"><A HREF="CWP53.HTM" TARGET="CNTFRAME">ExcelExportControl</A></TD>
<TD CLASS="TableLightDesc"> </TD>
<TD width=20> </TD>
</TR><TR height=20>
<TD width=20> </TD>
<TD CLASS="TableLightDesc"> </TD>
<TD CLASS="TableLightDesc"><A HREF="CWP54.HTM" TARGET="CNTFRAME">DialogTitle</A></TD>
<TD CLASS="TableLightDesc">
Set this to set the title of the message boxes displayed by the control.
<P>
</TD>
<TD width=20> </TD>
</TR><TR height=20>
<TD width=20> </TD>
<TD CLASS="TableLightDesc"> </TD>
<TD CLASS="TableLightDesc"><A HREF="CWP56.HTM" TARGET="CNTFRAME">Clear</A></TD>
<TD CLASS="TableLightDesc"> </TD>
<TD width=20> </TD>
</TR><TR height=20>
<TD width=20> </TD>
<TD CLASS="TableLightDesc"> </TD>
<TD CLASS="TableLightDesc"><A HREF="CWP57.HTM" TARGET="CNTFRAME">AllowedOuputColumnNames</A></TD>
<TD CLASS="TableLightDesc">
Setting this to let the user select the column names of output column names, using a combo box populated
with the array values set.
<P>
</TD>
<TD width=20> </TD>
</TR><TR height=20>
<TD width=20> </TD>
<TD CLASS="TableLightDesc"> </TD>
<TD CLASS="TableLightDesc"><A HREF="CWP59.HTM" TARGET="CNTFRAME">FileLoadController</A></TD>
<TD CLASS="TableLightDesc"> </TD>
<TD width=20> </TD>
</TR><TR height=20>
<TD width=20> </TD>
<TD CLASS="TableLightDesc"> </TD>
<TD CLASS="TableLightDesc"><A HREF="CWP61.HTM" TARGET="CNTFRAME">Dispose</A></TD>
<TD CLASS="TableLightDesc"> </TD>
<TD width=20> </TD>
</TR><TR height=20>
<TD width=20> </TD>
<TD CLASS="TableLightDesc"> </TD>
<TD CLASS="TableLightDesc"><A HREF="CWP62.HTM" TARGET="CNTFRAME">InitializeComponent</A></TD>
<TD CLASS="TableLightDesc">
Required method for Designer support - do not modify
the contents of this method with the code editor.
<P>
</TD>
<TD width=20> </TD>
</TR><TR height=20>
<TD width=20> </TD>
<TD CLASS="TableLightDesc"> </TD>
<TD CLASS="TableLightDesc"><A HREF="CWP63.HTM" TARGET="CNTFRAME">button1_Click</A></TD>
<TD CLASS="TableLightDesc"> </TD>
<TD width=20> </TD>
</TR><TR height=20>
<TD width=20> </TD>
<TD CLASS="TableLightDesc"> </TD>
<TD CLASS="TableLightDesc"><A HREF="CWP64.HTM" TARGET="CNTFRAME">TestFile</A></TD>
<TD CLASS="TableLightDesc"> </TD>
<TD width=20> </TD>
</TR><TR height=20>
<TD width=20> </TD>
<TD CLASS="TableLightDesc"> </TD>
<TD CLASS="TableLightDesc"><A HREF="CWP65.HTM" TARGET="CNTFRAME">ReturnConnection</A></TD>
<TD CLASS="TableLightDesc"> </TD>
<TD width=20> </TD>
</TR><TR height=20>
<TD width=20> </TD>
<TD CLASS="TableLightDesc"> </TD>
<TD CLASS="TableLightDesc"><A HREF="CWP66.HTM" TARGET="CNTFRAME">LoadSchemaFromFile</A></TD>
<TD CLASS="TableLightDesc"> </TD>
<TD width=20> </TD>
</TR><TR height=20>
<TD width=20> </TD>
<TD CLASS="TableLightDesc"> </TD>
<TD CLASS="TableLightDesc"><A HREF="CWP67.HTM" TARGET="CNTFRAME">comboBox1_SelectedIndexChanged</A></TD>
<TD CLASS="TableLightDesc"> </TD>
<TD width=20> </TD>
</TR><TR height=20>
<TD width=20> </TD>
<TD CLASS="TableLightDesc"> </TD>
<TD CLASS="TableLightDesc"><A HREF="CWP68.HTM" TARGET="CNTFRAME">SheetChangeController</A></TD>
<TD CLASS="TableLightDesc"> </TD>
<TD width=20> </TD>
</TR><TR height=20>
<TD width=20> </TD>
<TD CLASS="TableLightDesc"> </TD>
<TD CLASS="TableLightDesc"><A HREF="CWP70.HTM" TARGET="CNTFRAME">FillExportDataGrid</A></TD>
<TD CLASS="TableLightDesc"> </TD>
<TD width=20> </TD>
</TR><TR height=20>
<TD width=20> </TD>
<TD CLASS="TableLightDesc"> </TD>
<TD CLASS="TableLightDesc"><A HREF="CWP71.HTM" TARGET="CNTFRAME">ExportMappingTable</A></TD>
<TD CLASS="TableLightDesc"> </TD>
<TD width=20> </TD>
</TR><TR height=20>
<TD width=20> </TD>
<TD CLASS="TableLightDesc"> </TD>
<TD CLASS="TableLightDesc"><A HREF="CWP72.HTM" TARGET="CNTFRAME">CreateExportTable</A></TD>
<TD CLASS="TableLightDesc"> </TD>
<TD width=20> </TD>
</TR><TR height=20>
<TD width=20> </TD>
<TD CLASS="TableLightDesc"> </TD>
<TD CLASS="TableLightDesc"><A HREF="CWP73.HTM" TARGET="CNTFRAME">DefaultColumn</A></TD>
<TD CLASS="TableLightDesc"> </TD>
<TD width=20> </TD>
</TR><TR height=20>
<TD width=20> </TD>
<TD CLASS="TableLightDesc"> </TD>
<TD CLASS="TableLightDesc"><A HREF="CWP74.HTM" TARGET="CNTFRAME">FillExportMapping</A></TD>
<TD CLASS="TableLightDesc"> </TD>
<TD width=20> </TD>
</TR><TR height=20>
<TD width=20> </TD>
<TD CLASS="TableLightDesc"> </TD>
<TD CLASS="TableLightDesc"><A HREF="CWP75.HTM" TARGET="CNTFRAME">LoadSpecifiedSheet</A></TD>
<TD CLASS="TableLightDesc"> </TD>
<TD width=20> </TD>
</TR><TR height=20>
<TD width=20> </TD>
<TD CLASS="TableLightDesc"> </TD>
<TD CLASS="TableLightDesc"><A HREF="CWP76.HTM" TARGET="CNTFRAME">ClearTabControl</A></TD>
<TD CLASS="TableLightDesc"> </TD>
<TD width=20> </TD>
</TR><TR height=20>
<TD width=20> </TD>
<TD CLASS="TableLightDesc"> </TD>
<TD CLASS="TableLightDesc"><A HREF="CWP77.HTM" TARGET="CNTFRAME">radioButton3_CheckedChanged</A></TD>
<TD CLASS="TableLightDesc"> </TD>
<TD width=20> </TD>
</TR><TR height=20>
<TD width=20> </TD>
<TD CLASS="TableLightDesc"> </TD>
<TD CLASS="TableLightDesc"><A HREF="CWP78.HTM" TARGET="CNTFRAME">OutputDatasetName</A></TD>
<TD CLASS="TableLightDesc">
Set the outpupt dataset names. If set to non-blank values, it disables users
ability to enter a name manually. by disbaling the textboxes.
<P>
</TD>
<TD width=20> </TD>
</TR><TR height=20>
<TD width=20> </TD>
<TD CLASS="TableLightDesc"> </TD>
<TD CLASS="TableLightDesc"><A HREF="CWP80.HTM" TARGET="CNTFRAME">OuputDatatableName</A></TD>
<TD CLASS="TableLightDesc">
Set the outpupt datatable names. If set to non-blank values, it disables users
ability to enter a name manually. by disbaling the textboxes.
<P>
</TD>
<TD width=20> </TD>
</TR><TR height=20>
<TD width=20> </TD>
<TD CLASS="TableLightDesc"> </TD>
<TD CLASS="TableLightDesc"><A HREF="CWP82.HTM" TARGET="CNTFRAME">button2_Click</A></TD>
<TD CLASS="TableLightDesc"> </TD>
<TD width=20> </TD>
</TR><TR height=20>
<TD width=20> </TD>
<TD CLASS="TableLightDesc"> </TD>
<TD CLASS="TableLightDesc"><A HREF="CWP83.HTM" TARGET="CNTFRAME">BackColor</A></TD>
<TD CLASS="TableLightDesc">
Set the background color.
<P>
</TD>
<TD width=20> </TD>
</TR><TR height=20>
<TD width=20> </TD>
<TD CLASS="TableLightDesc"> </TD>
<TD CLASS="TableLightDesc"><A HREF="CWP85.HTM" TARGET="CNTFRAME">LogoImage</A></TD>
<TD CLASS="TableLightDesc">
Set a custom logo on the usercontrol
<P>
</TD>
<TD width=20> </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.
This member has not yet provided a Biography. Assume it's interesting and varied, and probably something to do with programming.