将工作表渲染到图形上下文

将工作表渲染到图形上下文

以下代码说明如何使用 Aspose.Cells 将工作表呈现为图形上下文。执行代码后,它将打印整个工作表并在图形上下文中用蓝色填充剩余的空白区域并将图像另存为测试.png文件。您可以使用任何源 excel 文件来尝试此代码。另请阅读代码中的注释以便更好地理解。

// For complete examples and data files, please go to https://github.com/aspose-cells/Aspose.Cells-for-Java
// The path to the documents directory.
String dataDir = Utils.getDataDir(ReleaseUnmanagedResources.class);
// Create workbook object from source file
Workbook workbook = new Workbook(dataDir + "source.xlsx");
// Access first worksheet
Worksheet worksheet = workbook.getWorksheets().get(0);
// Create empty image and fill it with blue color
int width = 800;
int height = 800;
BufferedImage image = new BufferedImage(width, height, BufferedImage.TYPE_INT_ARGB);
Graphics2D g = image.createGraphics();
g.setColor(java.awt.Color.blue);
g.fillRect(0, 0, width, height);
// Set one page per sheet to true in image or print options
ImageOrPrintOptions opts = new ImageOrPrintOptions();
opts.setOnePagePerSheet(true);
// Render worksheet to graphics context
SheetRender sr = new SheetRender(worksheet, opts);
sr.toImage(0, g);
// Save the graphics context image in Png format
File outputfile = new File(dataDir + "test.png");
ImageIO.write(image, "png", outputfile);