Excel Arbeitsmappe mit Passwort schützen und Excel Tabelle erstellen mit C# (IronXL)

using IronXL;

// Attempt to open a password-protected workbook
try 
{
    WorkBook protectedWorkBook = WorkBook.Load("encrypted_data.xlsx", "MySecretPass123!");

    // Access the first worksheet
    WorkSheet sheet = protectedWorkBook.WorkSheets[0];

    // Read data from protected file
    var cellValue = sheet["A1"].Value;
    Console.WriteLine($"Successfully accessed protected workbook. A1 contains: {cellValue}");
}
catch (Exception ex)
{
    Console.WriteLine($"Failed to open workbook: {ex.Message}");
}

Imports IronXL

' Attempt to open a password-protected workbook
Try
    Dim protectedWorkBook As WorkBook = WorkBook.Load("encrypted_data.xlsx", "MySecretPass123!")

    ' Access the first worksheet
    Dim sheet As WorkSheet = protectedWorkBook.WorkSheets(0)

    ' Read data from protected file
    Dim cellValue = sheet("A1").Value
    Console.WriteLine($"Successfully accessed protected workbook. A1 contains: {cellValue}")
Catch ex As Exception
    Console.WriteLine($"Failed to open workbook: {ex.Message}")
End Try

WorkBook workBook = WorkBook.Load("sample.xlsx");

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

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

workBook.Save();

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

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

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

workBook.Save()

using IronXL;
using System;

// Create a new workbook with sensitive financial data
WorkBook workBook = WorkBook.Create(ExcelFileFormat.XLSX);
WorkSheet sheet = workBook.CreateWorkSheet("FinancialData");

// Add sensitive data
sheet["A1"].Value = "Confidential Financial Report";
sheet["A3"].Value = "Revenue";
sheet["B3"].Value = 1250000;
sheet["A4"].Value = "Expenses";
sheet["B4"].Value = 750000;

// Apply formatting before encryption
sheet["B3:B4"].FormatCells.FormatString = "$#,##0.00";

// Encrypt the workbook with a strong password
workBook.Encrypt("F!n@nc3_S3cur3_2024");

// Save the encrypted workbook
workBook.SaveAs("financial_report_encrypted.xlsx");

Console.WriteLine("Workbook encrypted successfully!");

Imports IronXL
Imports System

' Create a new workbook with sensitive financial data
Dim workBook As WorkBook = WorkBook.Create(ExcelFileFormat.XLSX)
Dim sheet As WorkSheet = workBook.CreateWorkSheet("FinancialData")

' Add sensitive data
sheet("A1").Value = "Confidential Financial Report"
sheet("A3").Value = "Revenue"
sheet("B3").Value = 1250000
sheet("A4").Value = "Expenses"
sheet("B4").Value = 750000

' Apply formatting before encryption
sheet("B3:B4").FormatCells.FormatString = "$#,##0.00"

' Encrypt the workbook with a strong password
workBook.Encrypt("F!n@nc3_S3cur3_2024")

' Save the encrypted workbook
workBook.SaveAs("financial_report_encrypted.xlsx")

Console.WriteLine("Workbook encrypted successfully!")

// Remove protection for opened workbook. Original password is required.
workBook.Password = null;

' Remove protection for opened workbook. Original password is required.
workBook.Password = Nothing

using IronXL;

// First, open the protected workbook with the correct password
WorkBook protectedWorkBook = WorkBook.Load("encrypted_report.xlsx", "CurrentPassword123");

// Perform any necessary operations
WorkSheet sheet = protectedWorkBook.DefaultWorkSheet;
sheet["A1"].Value = "Updated after removing protection";

// Remove the password protection
protectedWorkBook.Password = null;

// Save the workbook without password protection
protectedWorkBook.SaveAs("unprotected_report.xlsx");

Console.WriteLine("Password protection removed successfully!");

Imports IronXL

' First, open the protected workbook with the correct password
Dim protectedWorkBook As WorkBook = WorkBook.Load("encrypted_report.xlsx", "CurrentPassword123")

' Perform any necessary operations
Dim sheet As WorkSheet = protectedWorkBook.DefaultWorkSheet
sheet("A1").Value = "Updated after removing protection"

' Remove the password protection
protectedWorkBook.Password = Nothing

' Save the workbook without password protection
protectedWorkBook.SaveAs("unprotected_report.xlsx")

Console.WriteLine("Password protection removed successfully!")