Render Worksheet to Graphic Context

Contents
[ ]

The following code illustrates how to use Aspose.Cells to render worksheet to graphic context. Once you will execute a code, it will print the entire worksheet and fill the leftover empty space with blue color in graphics context and save the image as **OutputImage_out_.png** file. You can use any source excel file to try this code. Please also read the comments inside the code for better understanding.

// For complete examples and data files, please go to https://github.com/aspose-cells/Aspose.Cells-for-.NET
// The path to the documents directory.
string dataDir = RunExamples.GetDataDir(System.Reflection.MethodBase.GetCurrentMethod().DeclaringType);
// Create workbook object from source file
Workbook workbook = new Workbook(dataDir + "SampleBook.xlsx");
// Access first worksheet
Worksheet worksheet = workbook.Worksheets[0];
// Create empty Bitmap
System.Drawing.Bitmap bmp = new System.Drawing.Bitmap(1100, 600);
// Create Graphics Context
System.Drawing.Graphics g = System.Drawing.Graphics.FromImage(bmp);
g.Clear(System.Drawing.Color.Blue);
// Set one page per sheet to true in image or print options
Aspose.Cells.Rendering.ImageOrPrintOptions opts = new Aspose.Cells.Rendering.ImageOrPrintOptions();
opts.OnePagePerSheet = true;
// Render worksheet to graphics context
Aspose.Cells.Rendering.SheetRender sr = new Aspose.Cells.Rendering.SheetRender(worksheet, opts);
sr.ToImage(0, g, 0, 0);
// Save the graphics context image in Png format
bmp.Save(dataDir + "OutputImage_out.png", System.Drawing.Imaging.ImageFormat.Png);