Category / Section
How to apply border to an image in a worksheet using XlsIO?
2 mins read
Pictures in a worksheet can be formatted for a better view. XlsIO provides the feature to format pictures. This article explains on how to apply borders to an image using XlsIO.
A picture added to a worksheet is referred with the interface IPictureShape. The property Line in the interface allows to set borders settings, which is shown in the below code snippets.
C#
ExcelEngine excelEngine = new ExcelEngine();
//Instantiate the excel application object.
IApplication application = excelEngine.Excel;
//The workbook is opened.
IWorkbook workbook;
string inputPath = GetFullTemplatePath("Sample.xlsx");
workbook = application.Workbooks.Open(inputPath, ExcelOpenType.Automatic);
//The first worksheet object in the worksheets collection is accessed.
IWorksheet worksheet = workbook.Worksheets[0];
IPictureShape picShape = worksheet.Pictures.AddPicture(5, 3, @"..\..\Data\Img.png");
picShape.Line.ForeColor = Color.Red;
picShape.Line.DashStyle = ExcelShapeDashLineStyle.Solid;
picShape.Line.Weight = 3;
VB
Dim excelEngine As ExcelEngine = New ExcelEngine()
‘Instantiate the excel application object.
Dim application As IApplication = excelEngine.Excel
'The workbook is opened.
Dim workbook As IWorkbook
Dim inputPath As String = GetFullTemplatePath("Sample.xlsx")
workbook = application.Workbooks.Open(inputPath, ExcelOpenType.Automatic)
'The first worksheet object in the worksheets collection is accessed.
Dim worksheet As IWorksheet = workbook.Worksheets(0)
Dim picShape As IPictureShape = worksheet.Pictures.AddPicture(5, 3, "..\..\Data\Img.png")
picShape.Line.ForeColor = Color.Red
picShape.Line.DashStyle = ExcelShapeDashLineStyle.Solid
picShape.Line.Weight = 3
The sample illustrating this behavior can be downloaded here.