📄 1.mht
字号:
=
href=3D"http://www.sudu.cn/info/html/edu/access/list_14_1.html">Access</A=
> </LI>
<LI><A=20
=
href=3D"http://www.sudu.cn/info/html/edu/coreldraw/list_31_1.html">Coreld=
raw</A>=20
</LI>
<LI><A =
href=3D"http://www.sudu.cn/info/html/edu/flash/list_32_1.html">flash</A> =
</LI>
<LI><A=20
=
href=3D"http://www.sudu.cn/info/html/edu/web_server/list_24_1.html">web=B7=
=FE=CE=F1=C6=F7</A>=20
</LI>
<LI><A=20
=
href=3D"http://www.sudu.cn/info/html/edu/ftp_server/list_25_1.html">ftp=B7=
=FE=CE=F1=C6=F7</A>=20
</LI>
<LI><A=20
=
href=3D"http://www.sudu.cn/info/html/edu/mail_server/list_26_1.html">mail=
=B7=FE=CE=F1=C6=F7</A>=20
</LI>
<LI><A=20
=
href=3D"http://www.sudu.cn/info/html/edu/mail_system/list_44_1.html">=D3=CA=
=BC=FE=CF=B5=CD=B3</A>=20
</LI>
<LI><A =
href=3D"http://www.sudu.cn/info/html/edu/ibm/list_43_1.html">IBM-AIX</A> =
</LI>
<LI><A =
href=3D"http://www.sudu.cn/info/html/edu/hp/list_42_1.html">HP-UX=20
</A></LI>
<LI><A =
href=3D"http://www.sudu.cn/info/html/edu/sco/list_41_1.html">Sco</A>=20
</LI>
<LI><A =
href=3D"http://www.sudu.cn/info/html/edu/solaris/list_40_1.html">Solaris =
</A></LI>
<LI><A =
href=3D"http://www.sudu.cn/info/html/edu/freebsd/list_39_1.html">FreeBSD =
</A></LI>
<LI><A =
href=3D"http://www.sudu.cn/info/html/edu/linux/list_38_1.html">Linux=20
</A></LI>
<LI><A =
href=3D"http://www.sudu.cn/info/html/edu/proxy/list_37_1.html">Proxy</A> =
</LI>
<LI><A =
href=3D"http://www.sudu.cn/info/html/edu/css/list_36_1.html">CSS=BD=CC=B3=
=CC</A>=20
</LI>
<LI><A=20
=
href=3D"http://www.sudu.cn/info/html/edu/javascript/list_35_1.html">Javas=
cript=BD=CC=B3=CC=20
</A></LI>
<LI><A =
href=3D"http://www.sudu.cn/info/html/edu/ajax/list_73_1.html">Ajax</A>=20
</LI>
<LI><A=20
=
href=3D"http://www.sudu.cn/info/html/edu/dns_server/list_29_1.html">dns=B7=
=FE=CE=F1=C6=F7</A>=20
</LI>
<LI><A=20
=
href=3D"http://www.sudu.cn/info/html/edu/photoshop/list_33_1.html">Photos=
hop=BD=CC=B3=CC</A>=20
</LI></UL>
<DIV class=3Dclear></DIV></DIV>
<DIV class=3Dclear></DIV>
<DIV id=3DmainBody style=3D"WIDTH: 640px">
<DIV id=3DarticleInfo>
<H3><IMG height=3D18 =
src=3D"http://www.sudu.cn/info/article/img/back.gif" width=3D15=20
align=3DabsMiddle> =B5=B1=C7=B0=CE=BB=D6=C3:<A class=3DSTYLE2=20
href=3D"http://www.sudu.cn/info/index.php">=D7=CA=D1=B6=D6=D0=D0=C4=D6=F7=
=D2=B3</A> ><A=20
style=3D"COLOR: #000000"=20
href=3D"http://www.sudu.cn/info/html/edu/C/list_52_1.html">C/C++</A> =
>=CE=C4=D5=C2=C4=DA=C8=DD=20
</H3>
<UL>
<LI=20
style=3D"FONT-WEIGHT: bold; FONT-SIZE: 15px; MARGIN-LEFT: =
0px">=D4=D9=CF=D6c#=B5=BC=B3=F6excel=D4=B4=C2=EB_c#=D3=A6=D3=C3=20
<LI=20
style=3D"PADDING-RIGHT: 0px; MARGIN-TOP: 10px; PADDING-LEFT: 0px; =
PADDING-BOTTOM: 2px; PADDING-TOP: 0px; BORDER-BOTTOM: #cccccc 1px =
solid">=C0=B4=D4=B4=A3=BA=D7=F7=D5=DF=A3=BA=20
=B7=A2=B2=BC=CA=B1=BC=E4:2007-12-24 15:36:33=20
<LI=20
style=3D"PADDING-RIGHT: 10px; MARGIN-TOP: 20px; PADDING-LEFT: 10px; =
PADDING-BOTTOM: 0px; MARGIN-LEFT: 0px; LINE-HEIGHT: 25px; PADDING-TOP: =
0px; TEXT-ALIGN: left">
<DIV id=3Dtextad>
<UL>
<H1><A =
href=3D"http://www.sudu.cn/domain">=D3=F2=C3=FB=D7=A2=B2=E1</A></H1>
<LI>=D3=F2=C3=FB=BE=AA=CF=B2=BC=DB=B8=F1 cn=D3=F2=C3=FB<SPAN =
class=3Dred>1</SPAN>=D4=AA=D7=A2=B2=E1=20
<LI>com=D3=F2=C3=FB<SPAN class=3Dred>39.9</SPAN>=D4=AA </LI></UL>
<UL>
<H1><A =
href=3D"http://www.sudu.cn/webhosting">=D0=E9=C4=E2=D6=F7=BB=FA</A></H1>
<LI>=D6=F7=BB=FA=B0=B4=D4=C2=D6=A7=B8=B6,=B5=CD=D6=C1<SPAN =
class=3Dred>19</SPAN>=D4=AA/=D4=C2=20
<LI>=B3=AC=B4=F3=C1=F7=C1=BF,=BF=C9=BF=AA=D7=D3=D5=BE=B5=E3 =
</LI></UL>
<UL>
<H1><A href=3D"http://www.sudu.cn/vps">VPS=D6=F7=BB=FA</A></H1>
<LI>=CC=D8=BB=DDVPS<SPAN =
class=3Dred>168</SPAN>=D4=AA/=D4=C2,4-8M=B6=C0=CF=ED=B4=F8=BF=ED=B1=A3=D6=
=A4=20
=
<LI>=B6=C0=C1=A2=B2=D9=D7=F7=CF=B5=CD=B3,=CE=DE=CF=DE=BF=AA=D5=BE=B5=E3 =
</LI></UL>
<DIV class=3Dclear></DIV></DIV>
=
<P>=BD=D3=CE=D2=C9=CF=D2=BB=C6=AAC#?=B3=F6Excel=D4=B4?.<BR>=CD=F8=C9=CF=B7=
=B4=D3=A6=B1=C8=BD=CF=C7=BF=C1=D2=A1=A3=B1=BE=C8=CB=D2=B2=D2=F2=CE=AA=B9=A4=
=D7=F7=D0=E8=D2=AA=B5=C4=D4=AD=D2=F2=A3=AC=BD=AB=C6=E4=B7=E2=D7=B0=C1=CB=B3=
=C9=C1=CBExcelManager=A1=A3=C6=F3=D2=B5=B5=B1=D6=D0=A3=AC=D7=F6=B1=A8=B1=ED=
=B5=C4=CA=FD=BE=DD=C0=B4=D4=B4=BF=CF=B6=A8=BE=CD=CA=C7=CA=FD=BE=DD=BF=E2=C1=
=CB=A1=A3=B8=C3ExcelManager=C4=BF=C7=B0=D6=BB=CC=E1=B9=A9Ms=20
Sql =
Server=B5=C4=D6=A7=B3=D6=A3=AC=D2=F2=CE=AA=CE=D2=C3=C7=B9=AB=CB=BE=CA=B9=D3=
=C3=B5=C4=BE=CD=CA=C7ms sql server 2000=20
=
=C1=CB=A1=A3=B7=E2=D7=B0=BA=F3=B5=C4ExcelManager=A3=AC=C4=E3=D6=BB=D0=E8=B4=
=AB=C8=EB=C4=E3=B5=C4=B1=A8=B1=ED=B1=ED=CD=B7=A3=A8=D2=BB=BC=B6=B1=ED=CD=B7=
=A1=A2=B6=FE=BC=B6=B1=ED=CD=B7=A1=A3=B4=F3=B2=BF=B7=D6=D3=D0=C1=BD=BC=B6=D2=
=B2=BE=CD=B9=BB=C1=CB=A1=A3=C8=E7=B9=FB=C4=E3=D3=D0=B6=E0=B8=F6=A3=AC=BF=C9=
=D7=D4=D0=D0=D0=DE=B8=C4=B8=C3=C0=E0.=A3=A9,=B2=A2=BD=AB=B6=D4=D3=A6=B5=C4=
=CA=FD=BE=DD=BF=E2=B1=ED=D7=D6=B6=CE=B4=AB=C8=EB=C0=E0=BF=E2=D6=D0=B5=C4=B7=
=BD=B7=A8DeclareExcelApp=BC=B4=BF=C9=A1=A3<BR>=CD=AC=C7=B0=D2=BB=C6=AA=CF=
=E0=CD=AC=A3=AC=C4=E3=BF=C9=BD=AB=CF=C2=C3=E6=B4=FA=C2=EB=B8=B4=D6=C6=C1=ED=
=B4=E6=D2=BB=B8=F6=D0=C2=C0=E0=BE=CD=C4=DC=C1=CB=A3=A8=B2=BB=D6=AA=CE=AA=CA=
=B2=C3=B4=A3=AC=CE=D2=D4=DA=BC=D2=C0=EF=C9=CF=CD=F8=C0=CF=CA=C7=B4=AB=B8=BD=
=BC=FE=B2=BB=C9=CF=C0=B4=A3=A1faint...=A3=A9=A1=A3=CB=E6=BA=F3=A3=AC=CE=D2=
=BB=E1=B8=F8=B3=F6=D2=BB=B8=F6=B5=F7=D3=C3=B5=C4=B7=BD=B7=A8=B5=C4=A3=BA<=
BR>namespace=20
ExportToExcel<BR>{<BR> using =
System;<BR> =20
using System.Data;<BR> using=20
System.Data.SqlClient;<BR> using=20
System.=CA=D3=B4=B0=CF=B5=CD=B3.Forms;<BR> using=20
System.Runtime.InteropServices;</P>
<P> =20
=
/************************************************************************=
***********<BR> =20
****Class Name : ExcelManger<BR> =20
=
****Author: &n=
bsp;=20
KingNa<BR> ****Create Date : =20
2006-9-1<BR> =
****CopyRight: =20
Reserve this info if you want to User this Class<BR> =
=
*************************************************************************=
**********/<BR> =20
public class ExcelManager:IDisposable<BR> =20
{<BR> Excel.Range m_objRange =
=3D=20
null;<BR> Excel.Application=20
m_objExcel =3D null;<BR> =20
Excel.Workbooks m_objBooks =3D=20
null;<BR> Excel._Workbook =
m_objBook=20
=3D null;<BR> Excel.Sheets =
m_objSheets=20
=3D null;<BR> =
Excel._Worksheet=20
m_objSheet =3D null;<BR> =20
Excel.QueryTable m_objQryTable =3D=20
null;<BR> object m_objOpt =
=3D=20
=
System.Reflection.Missing.Value;<BR> &=
nbsp;=20
//DataBase-used variable<BR> =
private=20
System.Data.SqlClient.SqlConnection sqlConn =3D=20
null;<BR> private string =
strConnect=20
=3D string.Empty;<BR> =
private=20
System.Data.SqlClient.SqlCommand sqlCmd =3D null;</P>
<P> //Sheets=20
variable<BR> private double=20
dbSheetSize =3D 65535;//the hight limit number in one=20
sheet<BR> private int=20
intSheetTotalSize =3D 0;//total record can divied sheet=20
number<BR> private double=20
dbTotalSize =3D 0;//record total number</P>
<P><BR> ///=20
<summary><BR> ///=20
=BD=A8=B9=B9=BA=AF=CA=FD<BR> =
///=20
</summary><BR> public=20
ExcelManager(){}</P>
<P> ///=20
<summary><BR> ///=20
=BD=A8=B9=B9=BA=AF=CA=FD<BR> =
///=20
</summary><BR> /// =
<param=20
=
name=3D"dbHL">=D2=BB=B8=F6Excel=B1=ED=B8=F1=B5=C4=D7=EE=B4=F3=BC=C7=C2=
=BC=CA=FD</param><BR> =20
/// <param=20
=
name=3D"dbTotal">=B8=C3=CA=FD=BE=DD=BF=E2=B1=ED=B9=B2=B2=E9=D1=AF=B3=F6=
=B6=E0=C9=D9=CC=F5=BC=C7=C2=BC</param><BR> &=
nbsp; =20
/// <param=20
=
name=3D"intDivide">=B2=E9=D1=AF=B3=F6=B5=C4=BC=C7=C2=BC=BF=C9=B7=D6=B3=
=C9=BC=B8=B8=F6Excel</param><BR>  =
; =20
/// <param=20
=
name=3D"conn">sqlConnection</param><BR> &=
nbsp; =20
public ExcelManager(Double dbHL,Double dbTotal,int =
intDivide,SqlConnection=20
conn )<BR> =20
=
{<BR> =20
dbSheetSize =3D=20
=
dbHL;<BR> &nbs=
p;=20
intSheetTotalSize =3D=20
=
intDivide;<BR>  =
; =20
dbTotalSize =3D=20
=
dbTotal;<BR> &=
nbsp;=20
sqlConn =3D conn;<BR> =20
}<BR> ///=20
<summary><BR> ///=20
=BD=A8=B9=B9=BA=AF=CA=FD<BR> =
///=20
</summary><BR> /// =
<param=20
=
name=3D"dbHL">=D2=BB=B8=F6Excel=B1=ED=B8=F1=B5=C4=D7=EE=B4=F3=BC=C7=C2=
=BC=CA=FD</param><BR> =20
/// <param=20
=
name=3D"strTableName">=D0=E8=B2=E9=D1=AF=B5=C4=CA=FD=BE=DD=BF=E2=B5=C4=
=B1=ED=C3=FB</param><BR> =
/// <param=20
=
name=3D"conn">sqlConnection</param><BR> &=
nbsp; =20
public ExcelManager(Double dbHL,string strTableName,SqlConnection=20
conn)<BR> =20
=
{<BR> =20
dbSheetSize =3D=20
=
dbHL;<BR> &nbs=
p;=20
sqlConn =3D=20
=
conn;<BR> &nbs=
p;=20
intSheetTotalSize =3D=20
=
GetTotalSize(strTableName,sqlConn);<BR> &nbs=
p; =20
}</P>
<P> public void=20
Dispose()<BR> =20
=
{<BR> =20
=
Dispose(true);<BR> &=
nbsp; =20
=
GC.SuppressFinalize(this);<BR> =
}<BR> private void =
Dispose(bool=20
disposing)<BR> =20
=
{<BR> =20
=
if(disposing)<BR> &n=
bsp; =20
=
{<BR> &n=
bsp; =20
// Dispose managed=20
=
resources.<BR>  =
; =20
=
Marshal.FinalReleaseComObject(m_objExcel);<BR> &nb=
sp; =20
m_objRange =3D=20
=
null;<BR> &nbs=
p; =20
m_objSheet =3D=20
=
null;<BR> &nbs=
p; =20
m_objSheets =3D=20
=
null;<BR> &nbs=
p; =20
m_objBooks =3D=20
=
null;<BR> &nbs=
p; =20
m_objBook =3D=20
=
null;<BR> &nbs=
p; =20
m_objExcel =3D=20
=
null;<BR> &nbs=
p;=20
}<BR> =20
}<BR> ///=20
<summary><BR> ///=20
=
⌨️ 快捷键说明
复制代码
Ctrl + C
搜索代码
Ctrl + F
全屏模式
F11
切换主题
Ctrl + Shift + D
显示快捷键
?
增大字号
Ctrl + =
减小字号
Ctrl + -