چگونه جریان‌های کاری اسناد Excel را در .NET ایمن کنیم

using Aspose.Cells;
using Aspose.Cells.LowCode;
using System;
using System.IO;

// Define the path to the Excel file that needs protection
string sourcePath = "path/to/sensitive-document.xlsx";

// Ensure the file exists before proceeding
if (!File.Exists(sourcePath))
{
    throw new FileNotFoundException("The source Excel file was not found.", sourcePath);
}

// Create load options for the source file
LowCodeLoadOptions loadOptions = new LowCodeLoadOptions
{
    InputFile = sourcePath
};

// Create save options for the protected output file
LowCodeSaveOptions saveOptions = new LowCodeSaveOptions
{
    SaveFormat = SaveFormat.Xlsx,
    OutputFile = "path/to/protected-document.xlsx"
};

// Alternatively, use a memory stream for enhanced security
// MemoryStream outputStream = new MemoryStream();
// saveOptions.OutputStream = outputStream;

// Define a strong password for document protection
string securePassword = "YourStrongPassword123!";

// Execute the process to lock the spreadsheet with the password
SpreadsheetLocker.Process(loadOptions, saveOptions, securePassword, null);

Console.WriteLine("Document successfully protected with password.");

using Aspose.Cells;
public void ValidateFileProtection(string filePath)
{
    try
    {
        // Attempt to open the file with an incorrect password
        new Workbook(filePath, new LoadOptions { Password = "wrongpassword" });
        Console.WriteLine("Warning: File opened with incorrect password!");
    }
    catch (CellsException ex)
    {
        if (ex.Code == ExceptionType.IncorrectPassword)
            Console.WriteLine("Success: Incorrect password rejected.");
        else
            throw;
    }
}

try
{
    // Load options setup
    LowCodeLoadOptions loadOptions = new LowCodeLoadOptions
    {
        InputFile = sourcePath
    };
    
    // Save options setup
    LowCodeSaveOptions saveOptions = new LowCodeSaveOptions
    {
        SaveFormat = SaveFormat.Xlsx,
        OutputFile = "path/to/protected-document.xlsx"
    };
    
    // Execute protection process
    SpreadsheetLocker.Process(loadOptions, saveOptions, securePassword, null);
    Console.WriteLine("Document successfully protected.");
}
catch (IOException ex)
{
    Console.WriteLine($"File operation error: {ex.Message}");
    // Log the error details for administrative review
}
catch (CellsException ex)
{
    Console.WriteLine($"Aspose.Cells error: {ex.Message} (Code: {ex.Code})");
    // Handle specific Cells exceptions based on error codes
}
catch (Exception ex)
{
    Console.WriteLine($"Unexpected error: {ex.Message}");
    // Consider more detailed logging for production environments
}

using Aspose.Cells;
using Aspose.Cells.LowCode;
public void BatchProtectExcelFiles(string[] inputFiles, string outputDirectory, string password)
{
    // Ensure output directory exists
    if (!Directory.Exists(outputDirectory))
    {
        Directory.CreateDirectory(outputDirectory);
    }
    
    int totalFiles = inputFiles.Length;
    int processedFiles = 0;
    int successCount = 0;
    int failCount = 0;
    
    foreach (string inputFile in inputFiles)
    {
        try
        {
            string fileName = Path.GetFileName(inputFile);
            string outputPath = Path.Combine(outputDirectory, $"Protected_{fileName}");
            
            // Configure options
            LowCodeLoadOptions loadOptions = new LowCodeLoadOptions
            {
                InputFile = inputFile
            };
            
            LowCodeSaveOptions saveOptions = new LowCodeSaveOptions
            {
                OutputFile = outputPath,
                SaveFormat = SaveFormat.Xlsx
            };
            
            // Apply protection
            SpreadsheetLocker.Process(loadOptions, saveOptions, password, null);
            
            successCount++;
            Console.WriteLine($"Protected {fileName} successfully");
        }
        catch (Exception ex)
        {
            failCount++;
            Console.WriteLine($"Failed to protect {Path.GetFileName(inputFile)}: {ex.Message}");
        }
        
        processedFiles++;
        
        // Report progress
        double progressPercentage = (double)processedFiles / totalFiles * 100;
        Console.WriteLine($"Progress: {progressPercentage:F1}% ({processedFiles}/{totalFiles})");
    }
    
    Console.WriteLine($"Batch protection complete. Success: {successCount}, Failed: {failCount}");
}

using System;
using System.IO;
using Aspose.Cells;
using Aspose.Cells.LowCode;

namespace SecureDocumentWorkflow
{
    public class SpreadsheetProtectionService
    {
        public void ProtectDocument(string inputPath, string outputPath, string password)
        {
            try
            {
                // Validate inputs
                if (string.IsNullOrEmpty(inputPath))
                    throw new ArgumentNullException(nameof(inputPath));
                
                if (string.IsNullOrEmpty(outputPath))
                    throw new ArgumentNullException(nameof(outputPath));
                
                if (string.IsNullOrEmpty(password))
                    throw new ArgumentException("Password cannot be empty", nameof(password));
                
                if (!File.Exists(inputPath))
                    throw new FileNotFoundException("Source file not found", inputPath);
                
                // Ensure output directory exists
                string outputDir = Path.GetDirectoryName(outputPath);
                if (!string.IsNullOrEmpty(outputDir) && !Directory.Exists(outputDir))
                {
                    Directory.CreateDirectory(outputDir);
                }
                
                // Configure options
                LowCodeLoadOptions loadOptions = new LowCodeLoadOptions { InputFile = inputPath };
                LowCodeSaveOptions saveOptions = new LowCodeSaveOptions
                {
                    SaveFormat = SaveFormat.Xlsx,
                    OutputFile = outputPath
                };
                
                // Execute protection
                SpreadsheetLocker.Process(loadOptions, saveOptions, password, null);
                
                // Verify protection
                VerifyPasswordProtection(outputPath, password);
                
                Console.WriteLine("Document successfully protected and verified.");
            }
            catch (Exception ex)
            {
                Console.WriteLine($"Error protecting document: {ex.Message}");
                throw;
            }
        }
        
        private void VerifyPasswordProtection(string filePath, string expectedPassword)
        {
            try
            {
                // Try to open without password (should fail)
                try
                {
                    new Workbook(filePath);
                    throw new Exception("Password protection verification failed: File opened without password");
                }
                catch (CellsException ex)
                {
                    if (ex.Code != ExceptionType.IncorrectPassword)
                    {
                        throw new Exception($"Unexpected error during verification: {ex.Message}");
                    }
                    // This is expected - file requires password
                }
                
                // Try to open with correct password (should succeed)
                try
                {
                    LoadOptions loadOptions = new LoadOptions { Password = expectedPassword };
                    new Workbook(filePath, loadOptions);
                    // Success - file opens with the provided password
                }
                catch (Exception ex)
                {
                    throw new Exception($"Password verification failed: {ex.Message}");
                }
            }
            catch (Exception ex)
            {
                Console.WriteLine($"Verification error: {ex.Message}");
                throw;
            }
        }
    }
    
    class Program
    {
        static void Main()
        {
            SpreadsheetProtectionService service = new SpreadsheetProtectionService();
            service.ProtectDocument(
                "sample.xlsx",
                "protected/financial-report-secured.xlsx",
                "SecureP@ssw0rd!"
            );
        }
    }
}