C# Worksheet.cells. Export data of selective datacolumns to excel in c##. Imports system.linq imports ironxl imports ironxl.styles private workbook as workbook = workbook.load(test.xls) private sheet as worksheet = workbook.worksheets.first() private range = sheet(a1:h10) private cell = range.first() 'this is how we set background color of the cell with an rgb string cell.style.setbackgroundcolor(#428d65.
I can read all of them. String value = worksheet.cells [1,1].value as string; In this example, we will be creating a new excel worksheet from scratch and then merge a few cells by following below steps: