Articles in this section
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.


            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;


            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.



Did you find this information helpful?
Help us improve this page
Please provide feedback or comments
Comments (0)
Please sign in to leave a comment