Aspose.Cells LowCode Plugins enable developers to seamlessly integrate Excel automation into .NET applications. Whether converting Excel sheets to HTML, JSON, CSV, images, PDFs, or applying secure password protection, the Aspose.Cells.LowCode namespace simplifies these tasks significantly. This guide provides detailed C# code examples and explanations for each plugin.

Why Use Aspose.Cells LowCode Plugins for Excel Automation?

  • Wide Range of Conversions: Easily convert between Excel formats and other popular file types like HTML, JSON, CSV, images, and PDF.
  • Reduced Coding Complexity: Intuitive APIs like HtmlConverter, JsonConverter, TextConverter, and more significantly reduce boilerplate code.
  • Advanced Workbook Security: Protect spreadsheets with robust password-based restrictions using SpreadsheetLocker.
  • High Compatibility: Fully compatible with .NET Framework, .NET Core, and .NET 5/6/7+.

Installation: How to Set Up Aspose.Cells LowCode Plugins

Install the LowCode plugin package via NuGet easily:

PM> Install-Package Aspose.Cells.LowCode

Convert Excel to HTML Using C#

Generate responsive HTML files from Excel sheets with embedded images:

using Aspose.Cells.LowCode;

var loadOpts = new LowCodeLoadOptions {
InputFile = "report.xlsx"
};

var htmlOpts = new LowCodeHtmlSaveOptions {
OutputFile = "report.html",
ExportImagesAsBase64 = true
};

var htmlConverter = new HtmlConverter(loadOpts, htmlOpts);
htmlConverter.Convert(); 

Export Excel Data to JSON in .NET

Transform Excel data into structured JSON format:

using Aspose.Cells.LowCode;

var loadOpts = new LowCodeLoadOptions {
InputFile = "data.xlsx"
};

var jsonOpts = new LowCodeJsonSaveOptions {
OutputFile = "data.json",
IndentOutput = true
};

var jsonConverter = new JsonConverter(loadOpts, jsonOpts);
jsonConverter.Convert(); 

Convert Excel Sheets to CSV, TSV, XML, or SQLScript

Quickly export Excel data to various text-based formats:

using Aspose.Cells.LowCode;

var loadOpts = new LowCodeLoadOptions {
InputFile = "records.xlsm"
};

var textOpts = new LowCodeTextSaveOptions {
OutputFile = "records.csv",
Format = TextFormat.Csv,
Delimiter = ','
};

var textConverter = new TextConverter(loadOpts, textOpts);
textConverter.Convert(); 

Generate Images from Excel Worksheets

Create high-quality images from Excel sheets for reports and dashboards:

using Aspose.Cells.LowCode;

var loadOpts = new LowCodeLoadOptions {
InputFile = "dashboard.xlsx"
};

var imgOpts = new LowCodeImageSaveOptions {
OutputDirectory = "images/",
ImageFormat = ImageFormat.Png,
ScaleFactor = 2.0
};

var imageConverter = new ImageConverter(loadOpts, imgOpts);
imageConverter.Convert(); 

Convert Excel Files to PDF in .NET

Ensure accurate, professional PDF output from Excel sheets:

using Aspose.Cells.LowCode;

var loadOpts = new LowCodeLoadOptions {
InputFile = "financials.xlsx"
};

var pdfOpts = new LowCodePdfSaveOptions {
OutputFile = "financials.pdf",
Compliance = PdfCompliance.PdfA1b,
EmbedFonts = true
};

var pdfConverter = new PdfConverter(loadOpts, pdfOpts);
pdfConverter.Convert(); 

Secure Excel Files with Password Protection

Apply robust security measures to sensitive Excel spreadsheets:

using Aspose.Cells.LowCode;

var loadOpts = new LowCodeLoadOptions {
InputFile = "sensitive.xlsx"
};

var saveOpts = new LowCodeSaveOptionsProviderOfPlaceHolders {
OutputPattern = "protected\_{OriginalFileName}"
};

var locker = new SpreadsheetLocker(loadOpts, saveOpts) {
Password = "Secure#123",
AllowPrinting = false,
AllowModification = false
};
locker.Lock(); 

Try Aspose.Cells LowCode Plugins Free

Explore the full capabilities of Aspose.Cells LowCode Plugins with a free temporary license, eliminating evaluation restrictions. Visit our Purchase Page to request your trial key.

Final Thoughts: Simplify Excel Automation Today

Using Aspose.Cells LowCode Plugins significantly reduces the complexity involved in spreadsheet management, data conversion, and workbook protection within .NET applications. Integrate these powerful tools into your development workflow and enhance your productivity immediately.

More in this category