//根據(jù)文件名，文件版本，文件格式信息來(lái)保存文件
public void SaveToFile(string fileName);
public void SaveToFile(string fileName, ExcelVersion version);
public void SaveToFile(string fileName, FileFormat fileFormat);
public void SaveToFile(string fileName, string separator);

//從文件加載，根據(jù)文件名，保護(hù)模式和Excel版本
public void LoadFromFile(string fileName);
public void LoadFromFile(string fileName, bool preserveMode);
public void LoadFromFile(string fileName, ExcelVersion version);
public void LoadFromFile(string fileName, string separator);
public void LoadFromFile(string fileName, string separator, int row, int column);
public void LoadFromFile(string fileName, string separator, int row, int column, ExcelVersion version);
//從數(shù)據(jù)流中加載
public void LoadFromStream(Stream stream);
public void LoadFromStream(Stream stream, bool loadStyles);
public void LoadFromStream(Stream stream, ExcelVersion version);
//從XML文件加載
public void LoadFromXml(Stream stream);
public void LoadFromXml(string fileName);
//從模版文件加載
public void LoadTemplateFromFile(string fileName);
public void LoadTemplateFromFile(string fileName, bool loadStyles);

#region 2.Excel文件屬性例子
static void ExcelTest2()
{   
 Workbook workbook = new Workbook();

 //修改文檔屬性信息，這樣在發(fā)布的時(shí)候，可以通過(guò)文檔顯示公司以及文件人的信息
 workbook.DocumentProperties.Author = "張三";   //作者
 workbook.DocumentProperties.Subject = "測(cè)試文件屬性"; //主題
 workbook.DocumentProperties.Title = "測(cè)試Excel文件"; //標(biāo)題
 workbook.DocumentProperties.Company = "XX有限公司";  //單位
 workbook.DocumentProperties.Comments = "保留文件評(píng)論"; //評(píng)論
 workbook.DocumentProperties.Keywords = "測(cè)試 Excel "; //關(guān)鍵詞
 workbook.DocumentProperties.CreatedTime = DateTime.Now; //創(chuàng)建時(shí)間
 //TODO:還有其他屬性，可以參考XlsBuiltInDocumentProperties的相關(guān)屬性   

 //將Excel文件保存到指定文件,還可以指定Excel版本
 workbook.SaveToFile("Sample.xls", ExcelVersion.Version2007);
}
#endregion

#region 3.加密Excel文件例子
static void ExcelTest3()
{
 Workbook workbook = new Workbook();
 workbook.Protect("pwd111");//設(shè)置保護(hù)加密的 密碼 ：pwd111
 //將Excel文件保存
 workbook.SaveToFile("Sample.xls", ExcelVersion.Version2007);
}
#endregion

Workbook workbook = new Workbook();

Worksheet sheet = workbook.Worksheets[0];

//保護(hù)sheet
sheet.Protect("test", SheetProtectionType.All);

//將Excel文件保存
workbook.SaveToFile("Sample.xlsx", ExcelVersion.Version2010);

static void ExcelTest4()
{
 Workbook workbook = new Workbook();
 workbook.CreateEmptySheets(1);
 Worksheet sheet = workbook.Worksheets[0];

 sheet.Range["A1"].Text = "鎖定";
 sheet.Range["B1"].Text = "未鎖定";

 sheet.Range["A1"].Style.Locked = true;
 sheet.Range["B1"].Style.Locked = false;

 //一定要對(duì)工作表進(jìn)行保護(hù)，才能生效
 sheet.Protect("test", SheetProtectionType.All);

 workbook.SaveToFile(@"Sample_Lock.xlsx", ExcelVersion.Version2010);
}