使用 Aspose.Cells.LowCode 在 .NET 中自动化 Excel

Install-Package Aspose.Cells

var loadOptions = new LowCodeLoadOptions { InputFile = "quarterly_sales.xlsx" };
var saveOptions = new LowCodeTextSaveOptions { OutputFile = "quarterly_sales.csv", Format = TextFormat.Csv };
new TextConverter(loadOptions, saveOptions).Convert();

var loadOptions = new LowCodeLoadOptions { InputFile = "financial_report.xlsx" };
var pdfOptions = new LowCodePdfSaveOptions { 
    OutputFile = "financial_report.pdf",
    Compliance = PdfCompliance.PdfA1b,  // Archival-quality PDFs
    EmbedFonts = true
};

new PdfConverter(loadOptions, pdfOptions).Convert();

// Define a simple protection provider
public class SimpleProtectionProvider : AbstractLowCodeProtectionProvider
{
    private readonly string openPwd, writePwd;

    public SimpleProtectionProvider(string openPwd, string writePwd)
    {
        this.openPwd = openPwd;
        this.writePwd = writePwd;
    }

    public override string GetOpenPassword() => openPwd;
    public override string GetWritePassword() => writePwd;
}

// Apply dual-layer protection with one method call
var provider = new SimpleProtectionProvider("ReadAccess123", "EditAccess456");
SpreadsheetLocker.Process(
    new LowCodeLoadOptions { InputFile = "financial_data.xlsx" },
    new LowCodeSaveOptions { OutputFile = "financial_data_protected.xlsx" },
    provider
);

foreach (string file in Directory.GetFiles("quarterly_reports", "*.xlsx"))
{
    string filename = Path.GetFileNameWithoutExtension(file);
    
    new PdfConverter(
        new LowCodeLoadOptions { InputFile = file },
        new LowCodePdfSaveOptions { OutputFile = $"pdf_reports/{filename}.pdf" }
    ).Convert();
}

// Download Excel from API and convert to JSON
using (var client = new HttpClient())
{
    byte[] excelData = await client.GetByteArrayAsync("https://api.example.com/reports/latest");
    File.WriteAllBytes("temp_report.xlsx", excelData);
    
    new JsonConverter(
        new LowCodeLoadOptions { InputFile = "temp_report.xlsx" },
        new LowCodeJsonSaveOptions { OutputFile = "api_data.json", IndentOutput = true }
    ).Convert();
    
    File.Delete("temp_report.xlsx");  // Clean up
}

Metered metered = new Metered();
metered.SetMeteredKey("PublicKey", "PrivateKey");