C#操作office方面的总结 Excel和Word


C#操作Excel!
publicclassImportExportToExcel
{
privatestringstrConn;

privateSystem.Windows.Forms.OpenFileDialogopenFileDlg=newSystem.Windows.Forms.OpenFileDialog();
privateSystem.Windows.Forms.SaveFileDialogsaveFileDlg=newSystem.Windows.Forms.SaveFileDialog();

publicImportExportToExcel()
{
//
//TODO:在此处添加构造函数逻辑
//
this.openFileDlg.DefaultExt="xls";
this.openFileDlg.Filter="Excel文件(*.xls)|*.xls";

this.saveFileDlg.DefaultExt="xls";
this.saveFileDlg.Filter="Excel文件(*.xls)|*.xls";

}


#region从Excel文件导入到DataSet
/////<summary>
/////从Excel导入文件
/////</summary>
/////<paramname="strExcelFileName">Excel文件名</param>
/////<returns>返回DataSet</returns>
//publicDataSetImportFromExcel(stringstrExcelFileName)
//{
//returndoImport(strExcelFileName);
//}
///<summary>
///从选择的Excel文件导入
///</summary>
///<returns>DataSet</returns>

publicDataSetImportFromExcel()
{
DataSetds
=newDataSet();
if(openFileDlg.ShowDialog()==System.Windows.Forms.DialogResult.OK)
ds
=doImport(openFileDlg.FileName);
returnds;
}

///<summary>
///从指定的Excel文件导入
///</summary>
///<paramname="strFileName">Excel文件名</param>
///<returns></returns>

publicDataSetImportFromExcel(stringstrFileName)
{
DataSetds
=newDataSet();
ds
=doImport(strFileName);
returnds;
}

///<summary>
///执行导入
///</summary>
///<paramname="strFileName">文件名</param>
///<returns>DataSet</returns>

privateDataSetdoImport(stringstrFileName)
{
if(strFileName=="")returnnull;

strConn
="Provider=Microsoft.Jet.OLEDB.4.0;"+
"DataSource="+strFileName+";"+
"ExtendedProperties=Excel8.0;";
OleDbDataAdapterExcelDA
=newOleDbDataAdapter("SELECT*FROM[Sheet1$]",strConn);

DataSetExcelDs
=newDataSet();
try
{
ExcelDA.Fill(ExcelDs,
"ExcelInfo");

}

catch(Exceptionerr)
{
System.Console.WriteLine(err.ToString());
}

returnExcelDs;



}

#endregion


#region从DataSet到出到Excel
///<summary>
///导出指定的Excel文件
///</summary>
///<paramname="ds">要导出的DataSet</param>
///<paramname="strExcelFileName">要导出的Excel文件名</param>

publicvoidExportToExcel(DataSetds,stringstrExcelFileName)
{
if(ds.Tables.Count==0||strExcelFileName=="")return;
doExport(ds,strExcelFileName);


}

///<summary>
///导出用户选择的Excel文件
///</summary>
///<paramname="ds">DataSet</param>

publicvoidExportToExcel(DataSetds)
{
if(saveFileDlg.ShowDialog()==System.Windows.Forms.DialogResult.OK)
doExport(ds,saveFileDlg.FileName);

}

///<summary>
///执行导出
///</summary>
///<paramname="ds">要导出的DataSet</param>
///<paramname="strExcelFileName">要导出的文件名</param>

privatevoiddoExport(DataSetds,stringstrExcelFileName)
{

Excel.Applicationexcel
=newExcel.Application();

//Excel.Workbookobj=newExcel.WorkbookClass();
//obj.SaveAs("c:\zn.xls",Excel.XlFileFormat.xlExcel9795,null,null,false,false,Excel.XlSaveAsAccessMode.xlNoChange,null,null,null,null);

introwIndex=1;
intcolIndex=0;

excel.Application.Workbooks.Add(
true);


System.Data.DataTabletable
=ds.Tables[0];
foreach(DataColumncolintable.Columns)
{
colIndex
++;
excel.Cells[
1,colIndex]=col.ColumnName;
}


foreach(DataRowrowintable.Rows)
{
rowIndex
++;
colIndex
=0;
foreach(DataColumncolintable.Columns)
{
colIndex
++;
excel.Cells[rowIndex,colIndex]
=row[col.ColumnName].ToString();
}

}

excel.Visible
=false;
excel.Sheets[
0]="sss";
excel.ActiveWorkbook.SaveAs(strExcelFileName
+".XLS",Excel.XlFileFormat.xlExcel9795,null,null,false,false,Excel.XlSaveAsAccessMode.xlNoChange,null,null,null,null);


//wkbNew.SaveAsstrBookName


//excel.Save(strExcelFileName);
excel.Quit();
excel
=null;

GC.Collect();
//垃圾回收
}

#endregion


#region从XML导入到Dataset

///<summary>
///从选择的XML文件导入
///</summary>
///<returns>DataSet</returns>

publicDataSetImportFromXML()
{
DataSetds
=newDataSet();
System.Windows.Forms.OpenFileDialogopenFileDlg
=newSystem.Windows.Forms.OpenFileDialog();
openFileDlg.DefaultExt
="xml";
openFileDlg.Filter
="xml文件(*.xml)|*.xml";
if(openFileDlg.ShowDialog()==System.Windows.Forms.DialogResult.OK)
try{ds.ReadXml(openFileDlg.FileName,System.Data.XmlReadMode.ReadSchema);}
catch{}
returnds;
}

///<summary>
///从指定的XML文件导入
///</summary>
///<paramname="strFileName">XML文件名</param>
///<returns></returns>

publicDataSetImportFromXML(stringstrFileName)
{
if(strFileName=="")
returnnull;
DataSetds
=newDataSet();
try{ds.ReadXml(strFileName,System.Data.XmlReadMode.ReadSchema);}
catch{}
returnds;
}


#endregion


#region从DataSet导出到XML
///<summary>
///导出指定的XML文件
///</summary>
///<paramname="ds">要导出的DataSet</param>
///<paramname="strXMLFileName">要导出的XML文件名</param>

publicvoidExportToXML(DataSetds,stringstrXMLFileName)
{
if(ds.Tables.Count==0||strXMLFileName=="")return;
doExportXML(ds,strXMLFileName);
}

///<summary>
///导出用户选择的XML文件
///</summary>
///<paramname="ds">DataSet</param>

publicvoidExportToXML(DataSetds)
{
System.Windows.Forms.SaveFileDialogsaveFileDlg
=newSystem.Windows.Forms.SaveFileDialog();
saveFileDlg.DefaultExt
="xml";
saveFileDlg.Filter
="xml文件(*.xml)|*.xml";
if(saveFileDlg.ShowDialog()==System.Windows.Forms.DialogResult.OK)
doExportXML(ds,saveFileDlg.FileName);
}


///<summary>
///执行导出
///</summary>
///<paramname="ds">要导出的DataSet</param>
///<paramname="strExcelFileName">要导出的XML文件名</param>

privatevoiddoExportXML(DataSetds,stringstrXMLFileName)
{
try
{ds.WriteXml(strXMLFileName,System.Data.XmlWriteMode.WriteSchema);}
catch(Exceptionex)
{System.Windows.Forms.MessageBox.Show(ex.Message,"Errol");}
}


#endregion




}









C#操作Word!
namespaceImportExportToOffice
{
usingSystem;
usingSystem.ComponentModel;
usingSystem.Data;
usingSystem.Windows.Forms;
publicclassImportExportToWord
{
privateWord.ApplicationClassoWordApplic;
privateWord.DocumentoDoc;
privateconststringstrFileName=@"F:\";
privateconststringPostfixForWord=@".doc";
privateconststringPostfixForHtml=@".Html";

构造函数

publicWord.DocumentDocument
{
get
{
returnthis.oDoc;
}

}


publicWord.ApplicationClassApplication
{
get
{
returnthis.oWordApplic;
}

}


私有方法

公有方法
}

}


转:http://www.cnblogs.com/zhanghl/archive/2005/09/19/239595.html 优质内容筛选与推荐>>
1、ASP.NET中Cookie编程的基础知识
2、java学习笔记12(final ,static修饰符)
3、633. Sum of Square Numbers 一个数是否能由两个数相加所得
4、3.2 发布和显示文章
5、近半年所踩的坑的总结


长按二维码向我转账

受苹果公司新规定影响,微信 iOS 版的赞赏功能被关闭,可通过二维码转账支持公众号。

    阅读
    好看
    已推荐到看一看
    你的朋友可以在“发现”-“看一看”看到你认为好看的文章。
    已取消,“好看”想法已同步删除
    已推荐到看一看 和朋友分享想法
    最多200字,当前共 发送

    已发送

    朋友将在看一看看到

    确定
    分享你的想法...
    取消

    分享想法到看一看

    确定
    最多200字,当前共

    发送中

    网络异常,请稍后重试

    微信扫一扫
    关注该公众号





    联系我们

    欢迎来到TinyMind。

    关于TinyMind的内容或商务合作、网站建议,举报不良信息等均可联系我们。

    TinyMind客服邮箱:support@tinymind.net.cn