CODEWITHSUNDEEP
c#npoi
Garrus_En
Garrus_En

Reputation: 161

How set height row in excel with NPOI?

How set height row in c# with NPOI?

To specify the width of the columns I'm using XSSFSheet.SetColumnWidth, but what does the command for the height of the cells look like?

Upvotes: 4

Views: 9852

Answers (3)

zxst
zxst

Reputation: 33

In addition to @kumar answer, you can set it like this

row.HeightInPoints = 16.5F;

Upvotes: 0

kumar chandraketu
kumar chandraketu

Reputation: 2370

try below approach

var row = sheet.CreateRow(0);
row.Height = 10 ;    
//Or     
sheet.GetRow(1).Height = 10;

Upvotes: 7

Garrus_En
Garrus_En

Reputation: 161

The height of the row is the same: XSSFSheet.GetRow(index).Heigh {get;set;}

Upvotes: 2

Related Questions