C# 操作 Office作的文章

《C# 操作 Office作的文章》由会员上传分享，免费在线阅读，更多相关内容在行业资料-天天文库。

1、usingSystem;usingSystem.Data;usingSystem.Drawing;usingSystem.Data.SqlClient;usingExcel;usingWord;usingSystem.IO;namespaceCommon{/**////

2、AGEWORDPATH=@"C:folderdocimagedoc";privateconststringIMAGEPATH=@"C:folderimage";privateconststringEXCELPATH=@"C:folderexcel";privateconststringTXTPATH=@"C:foldertxt";privateconststringIMAGEPOSTFIX=".bmp";privateconststringWORDPOSTFIX=".doc";privateconststringEXCELP

3、OSTFIX=".xls";privateconststringTXTPOSTFIX=".txt";privateconstintDATADISTANCE=5;privateconstintTABDISTANCE=8;publicExport(){  //  //TODO:在此处添加构造函数逻辑  //}/**////

4、Data(){  try  {   stringsConnectionString;   sConnectionString="workstationid=GUOFU;packetsize=4096;userid=sa;datasource=GUOFU;persistsecurityinfo=True;initialcatalog=YC;password=sc";   SqlConnectionobjConn=newSqlConnection(sConnectionString);   objConn.Open();                 

5、                             SqlDataAdapterdaPoint=newSqlDataAdapter("Select*FromPoint",objConn);   DataSetdsYC=newDataSet("YC");   daPoint.FillSchema(dsYC,SchemaType.Mapped,"Point");   daPoint.Fill(dsYC,"Point");   daPoint=newSqlDataAdapter("Select*FromEmployee",objConn);   da

6、Point.FillSchema(dsYC,SchemaType.Mapped,"Employee");   daPoint.Fill(dsYC,"Employee");   returndsYC;  }  catch(Exceptionex)  {   thrownewException(ex.Message);  }}/**////