asp.net use OWC to manipulate Excel instance code _ practical Skills

Copy Code code as follows:

String connstr = system.configuration.configurationmanager.connectionstrings["dqpihrconnectionstring"]. ToString ();
SqlConnection conn = new SqlConnection (CONNSTR);
SqlDataAdapter SDA = new SqlDataAdapter (SQL1. TEXT, conn);
DataSet ds = new DataSet ();
Conn. Open ();
Sda. Fill (DS);
Conn. Close ();
OWC10. Spreadsheetclass Xlsheet;
xlsheet= new OWC10. Spreadsheetclass ();
DataRow Dr;
int i = 0;
for (int ii=0;ii<ds. Tables[0]. rows.count;ii++)
{
Dr = ds. Tables[0]. ROWS[II];
Merging cells
Xlsheet.get_range (Xlsheet. Cells[i+1, 1], xlsheet. Cells[i+1, 8]). Set_mergecells (True);
Xlsheet.get_range (Xlsheet. Cells[i + 5, 1], xlsheet. Cells[i + 5, 3]). Set_mergecells (True);
Xlsheet.get_range (Xlsheet. Cells[i + 5, 4], xlsheet. Cells[i + 5, 6]). Set_mergecells (True);
Xlsheet.get_range (Xlsheet. Cells[i + 5, 7], xlsheet. Cells[i + 5, 8]). Set_mergecells (True);
Xlsheet. Activesheet.cells[i + 1, 1] = dr["Name"]. ToString () + "natural condition";
Font Bold
Xlsheet.get_range (Xlsheet. Cells[i + 1, 1], xlsheet. Cells[i + 1, 14]). Font.set_bold (TRUE);
Aligns cell text horizontally in the center
Xlsheet.get_range (Xlsheet. Cells[i + 1, 1], xlsheet. Cells[i + 1]). Set_horizontalalignment (OWC10. Xlhalign.xlhaligncenter);
Set Font size
Xlsheet.get_range (Xlsheet. Cells[i + 1, 1], xlsheet. Cells[i + 1, 14]). Font.set_size (14);
Set column width
Xlsheet.get_range (Xlsheet. Cells[i + 1, 8], xlsheet. Cells[i + 1, 8]). Set_columnwidth (20);
Draw Border Lines
Xlsheet.get_range (Xlsheet. Cells[i + 1, 1], xlsheet. Cells[i+5, 8]). Borders.set_linestyle (OWC10. xllinestyle.xlcontinuous);
Write data (generated by DS here)
Xlsheet. Activesheet.cells[i + 2, 1] = "name";
Xlsheet. Activesheet.cells[i + 2, 2] = dr["Name"]. ToString ();
Xlsheet. Activesheet.cells[i + 2, 3] = "used name";
Xlsheet. Activesheet.cells[i + 2, 4] = dr["used name"]. ToString ();
Xlsheet. Activesheet.cells[i + 2, 5] = "Date of birth";
Xlsheet. Activesheet.cells[i + 2, 6] = DateTime.Parse (dr["date of birth"). ToString ()). Year.tostring () + "-" + datetime.parse (dr["Birth date"). ToString ()). Month.tostring ();
Xlsheet. Activesheet.cells[i + 2, 7] = "Participation in working hours";
Xlsheet. Activesheet.cells[i + 2, 8] = DateTime.Parse (dr["Working hours"). ToString ()). Year.tostring () + "-" + datetime.parse (dr["Working hours"). ToString ()). Month.tostring ();
Xlsheet. Activesheet.cells[i + 3, 1] = "gender";
Xlsheet. Activesheet.cells[i + 3, 2] = dr["Sex"]. ToString ();
Xlsheet. Activesheet.cells[i + 3, 3] = "Nation";
Xlsheet. Activesheet.cells[i + 3, 4] = dr["Nation"]. ToString ();
Xlsheet. Activesheet.cells[i + 3, 5] = "political visage";
Xlsheet. Activesheet.cells[i + 3, 6] = dr["political visage"]. ToString ();
Xlsheet. Activesheet.cells[i + 3, 7] = "title";
Xlsheet. Activesheet.cells[i + 3, 8] = dr["title"]. ToString ();
Xlsheet. Activesheet.cells[i + 4, 1] = "education";
Xlsheet. Activesheet.cells[i + 4, 2] = dr["Education"]. ToString ();
Xlsheet. Activesheet.cells[i + 4, 3] = "degree";
Xlsheet. Activesheet.cells[i + 4, 4] = dr["degree"]. ToString ();
Xlsheet. Activesheet.cells[i + 4, 5] = "position";
Xlsheet. Activesheet.cells[i + 4, 6] = dr["title"]. ToString ();
Xlsheet. Activesheet.cells[i + 4, 7] = "File number";
Excel does not support 0 start input, plus the first letter of surname is exactly the number full name
Xlsheet. Activesheet.cells[i + 4, 8] = dr["surname first letter"]. ToString () + dr["file Number"]. ToString ();
Xlsheet. Activesheet.cells[i + 5, 1] = "Now engaged in professional:" + dr["is engaged in professional"]. ToString ();
Xlsheet. Activesheet.cells[i + 5, 4] = "Work unit:" + dr["work unit"]. ToString ();
Xlsheet. Activesheet.cells[i + 5, 7] = "ID card:" + dr["identity card number"]. ToString ();
i + 6;
}
Try
{
String D = DateTime.Now.Year.ToString () + DateTime.Now.Month.ToString () + DateTime.Now.Day.ToString () +
DateTime.Now.Hour.ToString () + DateTime.Now.Minute.ToString () + DateTime.Now.Second.ToString () +
DateTime.Now.Millisecond.ToString ();
Xlsheet. Export (Server.MapPath ("./") + "\" +d+ ". xls", OWC10. Sheetexportactionenum.ssexportactionnone, OWC10. Sheetexportformat.ssexportxmlspreadsheet);
Response.Write ("<script>window.open" (' +d+ ". xls ') </script>");
}
Catch
{
}
}