using?System;
using?System.Collections.Generic;
using?System.Linq;
using?System.Text;

namespace?SpireExcelDemo
{
????class?Program
????{
????????static?void?Main（string[]?args）
????????{
????????????Spire.Xls.Workbook?workbook?=?new?Spire.Xls.Workbook（）;
????????????//打開密碼
????????????workbook.OpenPassword?=?“123“;
????????????//加載
????????????workbook.LoadFromFile（“d:\\1.xls“）;
????????????foreach?（Spire.Xls.Worksheet?sheet?in?workbook.Worksheets）
????????????{
????????????????//設(shè)置值
????????????????sheet.Range[“A1“].Text?=?“111111“;
????????????????sheet.Range[“A2“].Text?=?“222222“;
????????????????//設(shè)置公式
????????????????sheet.Range[“A3“].Formula?=?“A1+A2“;
????????????????//列寬自適應(yīng)
????????????????sheet.AllocatedRange.AutoFitColumns（）;
????????????}
????????????//保存
????????????workbook.SaveToFile（“d:\\save.xlsx“）;
????????}
????}
}

?屬性????????????大小?????日期????時(shí)間???名稱
-----------?---------??----------?-----??----
?????目錄???????????0??2020-01-08?17:07??SpireExcelDemo\
?????目錄???????????0??2020-01-08?16:30??SpireExcelDemo\libs\
?????文件???????55808??2020-01-08?16:02??SpireExcelDemo\libs\Spire.License.dll
?????文件?????9808896??2020-01-08?16:02??SpireExcelDemo\libs\Spire.XLS.dll
?????目錄???????????0??2020-01-08?16:29??SpireExcelDemo\obj\
?????目錄???????????0??2020-01-08?16:30??SpireExcelDemo\obj\Debug\
?????文件??????????42??2020-01-08?16:02??SpireExcelDemo\obj\Debug\CoreCompileInputs.cache
?????文件????????6648??2020-01-08?16:30??SpireExcelDemo\obj\Debug\DesignTimeResolveAssemblyReferencesInput.cache
?????文件????????1491??2020-01-08?16:30??SpireExcelDemo\obj\Debug\SpireExcelDemo.csproj.FileListAbsolute.txt
?????文件???????23252??2020-01-08?16:30??SpireExcelDemo\obj\Debug\SpireExcelDemo.csprojResolveAssemblyReference.cache
?????文件????????6144??2020-01-08?16:30??SpireExcelDemo\obj\Debug\SpireExcelDemo.exe
?????文件???????13824??2020-01-08?16:30??SpireExcelDemo\obj\Debug\SpireExcelDemo.pdb
?????目錄???????????0??2020-01-08?16:01??SpireExcelDemo\obj\Debug\TempPE\
?????文件?????????920??2020-01-08?16:10??SpireExcelDemo\Program.cs
?????目錄???????????0??2020-01-08?16:29??SpireExcelDemo\Properties\
?????文件????????1344??2020-01-08?16:01??SpireExcelDemo\Properties\AssemblyInfo.cs
?????文件????????2784??2020-01-08?16:30??SpireExcelDemo\SpireExcelDemo.csproj
?????文件?????????996??2020-01-08?16:31??SpireExcelDemo\SpireExcelDemo.sln