How to set height, width, background color, font color of excel using Microsoft.Office.Interop.Excel library in C#

Question

xlWorkSheetToExportCells3 3  34Karishma Marine Solutions Pvt Ltd34

dharmendr · Accepted Answer

Hi santosh86Refer the below code Assigning value to cellxlWorkSheetToExportCells3 3  34Karishma Marine Solutions Pvt Ltd34 Get the range from excelExcelRange range  xlAppToExportActiveCellWorksheetCells3 3 as ExcelRange Auto resize cell width and heightrangeColumnsAutoFit Set background colorrangeInteriorColor  SystemDrawingColorTranslatorToOleSystemDrawingColorRed Set font colorrangeFontColor  SystemDrawingColorTranslatorToOleSystemDrawingColorWhite Set Row HeightrangeEntireRowRowHeight  500 Set Column WidthrangeColumnWidth  500

How to set height, width, background color, font color of excel using Microsoft.Office.Interop.Excel library in C#

Company

Explore

Follow us

Contact Us