保護 Excel 檔案

VBC#

using IronXL;

WorkBook workBook = WorkBook.Load("sample.xlsx");
WorkSheet workSheet = workBook.DefaultWorkSheet;

// Open protected spreadsheet file
WorkBook protectedWorkBook = WorkBook.Load("sample.xlsx", "IronSoftware");

// Spreadsheet protection
// Set protection for spreadsheet file
workBook.Encrypt("IronSoftware");

// Remove protection for spreadsheet file. Original password is required.
workBook.Password = null;

workBook.Save();

// Worksheet protection
// Set protection for individual worksheet
workSheet.ProtectSheet("IronXL");

// Remove protection for particular worksheet. It works without password!
workSheet.UnprotectSheet();

workBook.Save();

Imports IronXL

Dim workBook As WorkBook = WorkBook.Load("sample.xlsx")
Dim workSheet As WorkSheet = workBook.DefaultWorkSheet

' Open protected spreadsheet file
Dim protectedWorkBook As WorkBook = WorkBook.Load("sample.xlsx", "IronSoftware")

' Spreadsheet protection
' Set protection for spreadsheet file
workBook.Encrypt("IronSoftware")

' Remove protection for spreadsheet file. Original password is required.
workBook.Password = Nothing

workBook.Save()

' Worksheet protection
' Set protection for individual worksheet
workSheet.ProtectSheet("IronXL")

' Remove protection for particular worksheet. It works without password!
workSheet.UnprotectSheet()

workBook.Save()

PM > Install-Package IronXL.Excel

Install-Package IronXL.Excel

保護 Excel 檔案

IronXL 的 Encrypt 方法為開發人員提供了對整個 Excel 工作簿和個別工作表設置密碼保護的能力。此功能對保護敏感資料至關重要，確保只有授權的使用者才能存取或修改 Excel 文件的內容。

IronXL 還允許進行工作表級別的保護，這可以防止使用者編輯工作簿或特定工作表的某些部分。這在協作環境中特別有用，當您希望限制編輯權限但仍允許使用者查看或與資料互動時。此外，選擇使用密碼或不使用密碼刪除保護提供了靈活性，從而適合於既需要安全環境又需要臨時恢復存取權限的情況。總之，此功能是在自動化資料處理工作流程中確保 Excel 文件安全的基本工具。