CODEWITHSUNDEEP
c#excelopenxml-sdkepplus
ffffff01
ffffff01

Reputation: 5238

Get style of excel cell with Epplus

Is there any way to get the style of a specific cell with open xml sdk and epplus?

Currently I'm getting the value in the following way:

currentWorksheet.Cells[nRowId, 3].Text.Trim();

In adittion to this I want if there is a background color, and a border.

Upvotes: 0

Views: 5569

Answers (1)

Vincent Tan
Vincent Tan

Reputation: 3166

Try

currentWorksheet.Cells[nRowId, 3].Style;

Also:

currentWorksheet.Cells[nRowId, 3].Style.Fill.BackgroundColor;
currentWorksheet.Cells[nRowId, 3].Style.Border;

Upvotes: 4

Related Questions