1. 技术参考网站
首先给大家介绍一个介绍Excel技术的网站: http://msdn2.microsoft.com/en-us/library/syyd7czh.aspx
2. 保存Excel文件
下面是Workbook.SaveAs()的原形:
C#
public
virtual
void
SaveAs (
[OptionalAttribute] Object Filename,
[OptionalAttribute] Object FileFormat,
[OptionalAttribute] Object Password,
[OptionalAttribute] Object WriteResPassword,
[OptionalAttribute] Object ReadOnlyRecommended,
[OptionalAttribute] Object CreateBackup,
[OptionalAttribute] XlSaveAsAccessMode AccessMode,
[OptionalAttribute] Object ConflictResolution,
[OptionalAttribute] Object AddToMru,
[OptionalAttribute] Object TextCodepage,
[OptionalAttribute] Object TextVisualLayout,
[OptionalAttribute] Object Local
)
![](https://i-blog.csdnimg.cn/blog_migrate/6810355c2f78c12e91b7997a8e8c583a.gif)
使用的时候大部分的参数可以使用缺省值:
workBookTempt.SaveAs(path, Missing.Value, Missing.Value, Missing.Value, Missing.Value, Missing.Value,
Excel.XlSaveAsAccessMode.xlNoChange, Missing.Value, Missing.Value, Missing.Value, Missing.Value, Missing.Value);
//
workBookTempt是一个Workbook对象
3. 根据一个Worksheet模板向Workbook插入Wroksheet
workSheetTemplate.Copy(Missing.Value,workBookTempt.Worksheets[workBookTempt.Worksheets.Count]);
//workSheetTemplate是一个Worksheet类型的模板,workBookTempt是一个Workbook类型的你要插Sheet的Excel表
//这条语句实现向workBookTempt的最后插入一个基于workSheetTemplate模板的Sheet.
注意如果用这个函数是参数都用缺省值,则它会新建一个workbook然后用模板向这个Workbook中插入一个sheet。