PNG JPG BMP TIFF XLSX

Insert rectangle into Excel via .NET

Insert rectangle using Aspose.Cells’ API without any software like Microsoft or Open Office, Adobe PDF, etc.

How to Insert rectangle into Excel File Using C#

In order to insert rectangle into excel file, we’ll use

API which is a feature-rich, powerful and easy to use document manipulation and splitter API for C# platform. Open

package manager, search for Aspose.Cells and install. You may also use the following command from the Package Manager Console.

Command
PM> Install-Package Aspose.Cells

Steps to insert rectangle to Excel file via C#

You need the aspose.cells.dll to try the following workflow in your own environment.

Instantiating a Workbook object.(or->Load the XLSX file with full path.)
Select Worksheet via its index.
Use the add method to insert a rectangle in the selected worksheet
Save workbook in XLSX format.

System Requirements

Aspose.Cells for .NET is supported on all major operating systems. Just make sure that you have the following prerequisites.

Microsoft Windows or a compatible OS with .NET Framework, .NET Core, Mono or Xamarin Platforms
Development environment like Microsoft Visual Studio
Add reference to the Aspose.Cells for .NET DLL in your project - Install from NuGet using the Download button above

Insert Rectangle - C#

	// For complete examples and data files, please go to https://github.com/aspose-cells/Aspose.Cells-for-.NET
	// Create workbook from sample file
	Workbook workbook = new Workbook();

	// Access first worksheet from the collection
	Worksheet sheet = workbook.Worksheets[0];

	// Add the rectangle to the worksheet
	sheet.Shapes.AddRectangle(2, 0, 2, 0, 100, 300);

	//Save
	workbook.Save("sample.xlsx", SaveFormat.Xlsx);

view raw Examples-CSharp-InsertShapesToWorksheetInAsposeCells-Rectangle.cs hosted with ❤ by GitHub

About Aspose.Cells for .NET API

Aspose.Cells API can be used to create, edit, convert and render Microsoft Excel formats to different formats. Moreover, it can be used for comprehensive charting, scalable reporting and reliable calculations within software applications. Aspose.Cells is a standalone API and it does not require any software like Microsoft or OpenOffice.