Epplus cell range numerically

c# excel epplus
sarsnake picture sarsnake · Jan 11, 2016 · Viewed 12.5k times · Source

In EPPlus extension, if I need to set style for a range of cells such as A1 to C1, I will use the following

ws.Cells["A1:C1"].Style.Font.Bold = true;

What is the equivalent for this using numbers only?

Answer

Ernie S picture Ernie S · Jan 12, 2016

Cells has an overload that will let you do [FromRow, FromCol, ToRow, ToCol] like this:

ws.Cells[1, 1, 1, 3].Style.Font.Bold = true;

Related questions

EPPlus - Read Excel Table

Using EPPlus, I want to read an excel table, then store all the contents from each column into its corresponding List. I want it to recognize the table's heading and categorize the contents based on that. For example, if my …

Read More
Export DataTable to Excel with EPPlus

I want to export a data table to an Excel file with EPPlus. That data table has a property with int type, so I want the same format in the Excel file. Does anyone know way to export a DataTable …

Read More
Excel to DataTable using EPPlus - excel locked for editing

I'm using the following code to convert an Excel to a datatable using EPPlus: public DataTable ExcelToDataTable(string path) { var pck = new OfficeOpenXml.ExcelPackage(); pck.Load(File.OpenRead(path)); var ws = pck.Workbook.Worksheets.First(); DataTable tbl = new DataTable(); bool …

Read More