Improved reading of Excel Data to the datagridview (added the Excel export function)

 

Code

 Using system;
Using system. Collections. Generic;
Using system. componentmodel;
Using system. Data;
Using system. drawing;
Using system. text;
Using system. Windows. forms;
Using system. Web;
Using system. IO;

Namespace windowsapplication1
{
Public partial class form2: Form
{
Public form2 ()
{
Initializecomponent ();
}

Private void button#click (Object sender, eventargs E)
{
This. openfiledialog1.showdialog ();
This. textbox1.text = This. openfiledialog1.filename;
}

Private void button2_click (Object sender, eventargs E)
{
String filename = "";
Filename = This. textbox1.text;
If (this. textbox1.text! = "")
{
Try
{
String strcon = "provider = Microsoft. Jet. oledb.4.0; Data Source =" + filename + "; extended properties = Excel 8.0 ";
System. Data. oledb. oledbconnection myconn = new system. Data. oledb. oledbconnection (strcon );
String strcom = "select * from [punishcase $]";
System. Data. oledb. oledbdataadapter mycommand = new system. Data. oledb. oledbdataadapter (strcom, myconn );
System. Data. datatable dt = new system. Data. datatable ();
Mycommand. Fill (DT );
This. Maid = DT;
This. label1.text = myconn. state. tostring ();
MessageBox. Show ("imported successfully ");

}
Catch
{
MessageBox. Show ("select Excel for case import ");

}



}
Else
{
MessageBox. Show ("select an Excel file ");
}



}

Private void button3_click (Object sender, eventargs E)
{
Savefiledialog = new savefiledialog ();

Savefiledialog. Filter = "execl files (*. xls) | *. xls ";

Savefiledialog. filterindex = 0;

Savefiledialog. restoredirectory = true;

Savefiledialog. createprompt = true;

Savefiledialog. Title = "Export Excel file ";


Savefiledialog. showdialog ();


Stream mystream;

Mystream = savefiledialog. openfile ();

// Streamwriter Sw = new streamwriter (mystream, system. Text. encoding. getencoding ("gb2312 "));

Streamwriter Sw = new streamwriter (mystream, system. Text. encoding. getencoding (-0 ));

String STR = "";

Try

{

// Write the title

For (INT I = 0; I <datagridview1.columncount; I ++)

{

If (I> 0)

{

STR + = "\ t ";

}

STR + = maid [I]. headertext;

}


Sw. writeline (STR );



// Write content

For (Int J = 0; j <datagridview1.rows. Count; j ++)

{

String tempstr = "";

For (int K = 0; k <datagridview1.columns. Count; k ++)

{

If (k> 0)

{

Tempstr + = "\ t ";

}

Tempstr + = maid [J]. cells [K]. value. tostring ();

}



Sw. writeline (tempstr );

}

Sw. Close ();

Mystream. Close ();

}

Catch

{



}

Finally

{

Sw. Close ();

Mystream. Close ();

}

}



}
}