Panduan untuk Excel-to-Image Conversion dalam .NET

dotnet add package Aspose.Cells

using Aspose.Cells;
using Aspose.Cells.Rendering;

// Load the Excel file
Workbook workbook = new Workbook("Sample.xlsx");
Worksheet worksheet = workbook.Worksheets[0];

// Configure image options
ImageOrPrintOptions options = new ImageOrPrintOptions
{
    ImageType = ImageType.Png,
    HorizontalResolution = 200,
    VerticalResolution = 200,
    OnePagePerSheet = true
};

// Create renderer and export
SheetRender renderer = new SheetRender(worksheet, options);
renderer.ToImage(0, "output_image.png");

Workbook workbook = new Workbook("SalesData.xlsx");
Worksheet sheet = workbook.Worksheets["Q1 Report"]; // Access by name

ImageOrPrintOptions options = new ImageOrPrintOptions
{
    ImageType = ImageType.Png,
    OnePagePerSheet = true,
    HorizontalResolution = 200,
    VerticalResolution = 200
};

SheetRender renderer = new SheetRender(sheet, options);

// Export each page (if worksheet spans multiple pages)
for (int pageIndex = 0; pageIndex < renderer.PageCount; pageIndex++)
{
    string imageName = $"worksheet_page_{pageIndex + 1}.png";
    renderer.ToImage(pageIndex, imageName);
}

options.AllColumnsInOnePagePerSheet = true;
options.AllRowsInOnePagePerSheet = true;

Workbook workbook = new Workbook("FinancialReport.xlsx");

ImageOrPrintOptions options = new ImageOrPrintOptions
{
    ImageType = ImageType.Png,
    OnePagePerSheet = true,
    HorizontalResolution = 200,
    VerticalResolution = 200
};

// Use WorkbookRender for whole workbook
WorkbookRender renderer = new WorkbookRender(workbook, options);

for (int i = 0; i < renderer.PageCount; i++)
{
    string fileName = $"workbook_page_{i + 1}.png";
    renderer.ToImage(i, fileName);
}

Workbook workbook = new Workbook("Dashboard.xlsx");
Worksheet sheet = workbook.Worksheets["Charts"];

// Access the first chart
Chart chart = sheet.Charts[0];

// Configure chart image options
ImageOrPrintOptions options = new ImageOrPrintOptions
{
    ImageType = ImageType.Png,
    HorizontalResolution = 300,
    VerticalResolution = 300,
    SmoothingMode = SmoothingMode.AntiAlias,
    ChartImageWidth = 1200,
    ChartImageHeight = 800
};

// Export chart directly to image
chart.ToImage("chart_output.png", options);

Workbook workbook = new Workbook("DataSet.xlsx");
Worksheet worksheet = workbook.Worksheets[0];

// Define the range to export (A1 to D10)
Range range = worksheet.Cells.CreateRange("A1", "D10");

// Set the print area to this range
worksheet.PageSetup.PrintArea = range.RefersTo;

// Configure image options
ImageOrPrintOptions options = new ImageOrPrintOptions
{
    ImageType = ImageType.Png,
    HorizontalResolution = 200,
    VerticalResolution = 200,
    OnePagePerSheet = true
};

// Render only the specified range
SheetRender renderer = new SheetRender(worksheet, options);
renderer.ToImage(0, "range_output.png");

Workbook workbook = new Workbook("KPIReport.xlsx");
Worksheet sheet = workbook.Worksheets[0];

// Select a single cell
Cell cell = sheet.Cells["B5"];

// Set print area to just that cell
sheet.PageSetup.PrintArea = "B5";

// Configure image options
ImageOrPrintOptions options = new ImageOrPrintOptions
{
    ImageType = ImageType.Png,
    OnePagePerSheet = true,
    HorizontalResolution = 300,
    VerticalResolution = 300
};

// Render and save
SheetRender renderer = new SheetRender(sheet, options);
renderer.ToImage(0, "cell_b5_output.png");

using System;
using System.Drawing;
using Aspose.Cells;

// Load Excel file
Workbook workbook = new Workbook("Report.xlsx");
Worksheet sheet = workbook.Worksheets[0];

// Configure low-resolution options for initial render
ImageOrPrintOptions options = new ImageOrPrintOptions
{
    ImageType = ImageType.Png,
    HorizontalResolution = 96,
    VerticalResolution = 96,
    OnePagePerSheet = true
};

// Render full sheet as a temporary image
SheetRender renderer = new SheetRender(sheet, options);
renderer.ToImage(0, "preview_temp.png");

// Resize to thumbnail dimensions
using (Bitmap original = new Bitmap("preview_temp.png"))
{
    Bitmap thumbnail = new Bitmap(original, new Size(160, 120));
    thumbnail.Save("thumbnail.png");
}

Workbook workbook = new Workbook("DataGrid.xlsx");
Worksheet sheet = workbook.Worksheets[0];

// Hide gridlines and headings
sheet.PageSetup.PrintGridlines = false;
sheet.PageSetup.PrintHeadings = false;
sheet.DisplayGridlines = false;

// Set image rendering options with transparency enabled
ImageOrPrintOptions options = new ImageOrPrintOptions
{
    ImageType = ImageType.Png,
    Transparent = true,
    OnePagePerSheet = true
};

// Render the sheet as an image
SheetRender renderer = new SheetRender(sheet, options);
renderer.ToImage(0, "transparent_output.png");

Workbook workbook = new Workbook("Template.xlsx");
Worksheet worksheet = workbook.Worksheets["Sheet1"];

// Set up advanced rendering options
ImageOrPrintOptions options = new ImageOrPrintOptions
{
    ImageType = ImageType.Png,
    HorizontalResolution = 300,
    VerticalResolution = 300,
    PrintWithStatusDialog = false,
    Transparent = false,
    OnePagePerSheet = true,
    ShowGridLines = true,
    ShowRowColumnHeaders = true,
    AllColumnsInOnePagePerSheet = true,
    AllRowsInOnePagePerSheet = true
};

SheetRender renderer = new SheetRender(worksheet, options);
renderer.ToImage(0, "custom_output.png");

worksheet.AutoFitColumns();

options.HorizontalResolution = 300;
options.VerticalResolution = 300;

options.Transparent = false;