Using ClosedXML how to adjust row height to content?

Question

I create cell with text. After that I set WrapText property and column width.

var cell = worksheet.Cell("A1");
cell.Style.Alignment.WrapText = true;
cell.SetValue("This is very long text");
worksheet.Column(1).Width = 10;
worksheet.Rows().AdjustToContents();

The text has been moved by words, but row height is not changed. How to adjust row height to cell content?

score 18 · Answer 1 · answered Jul 15 '15 at 17:38

There are many ways to achieve this.

Don't use wrap or shrink properties on cell values rather include this line just before saving your excel

ws.Columns().AdjustToContents();

Another way is to make use of Allignment property

 IXLRange titleRange = ws.Range("B2:AA2");
        titleRange.Cells().Style
            .Alignment.SetWrapText(true); // Its single statement

Hope it helps!!

score 16 · Accepted Answer · answered May 15 '14 at 15:24

16

It works when you remove the worksheet.Rows().AdjustToContents();.

Autofitting sometimes needs more of a trial and error approach ...

answered May 15 '14 at 15:24

Raidri

17,258
9
62
65

score 3 · Answer 3 · edited Feb 08 '22 at 10:39

3

I think this is a bug of ClosedXML. enter link description here

ws.Row(1).AdjustToContents();
ws.Row(1).ClearHeight();

In my case it works. Version: 0.95.4

edited Feb 08 '22 at 10:39

ouflak

2,458
10
44
49

answered Feb 08 '22 at 09:40

Lisar

31
1

score 1 · Answer 4 · answered Oct 07 '15 at 16:09

1

The following code worked for me.

IXLRange contents = ws.Range("A1:A50");
contents.Style.Alignment.WrapText = true;

answered Oct 07 '15 at 16:09

Dhruv Rangunwala

228
4
6

score 0 · Answer 5 · answered Oct 19 '15 at 17:09

0

You can also AdjustToContents on Specific range of cells.

worksheet.Columns(2, 20).AdjustToContents();

answered Oct 19 '15 at 17:09

Smit Patel

2,992
1
26
44

Question is about adjusting the height, not columns. – Himalaya Garg Dec 15 '21 at 04:10
7 Years later????? - I didn't remember the question :D – Smit Patel Dec 16 '21 at 09:22
@SmitPatel In that case, it's best if you delete your answer, since it doesn't answer the question! It adds nothing new that the other (more upvoted) answers haven't already covered. – Zimano Jan 18 '23 at 15:20
@Zimano - I've put it because of a Range can also be applied with AdjustToContents - Someone might have that question as well apart from what asked, As a developer we should think on wider level and don't need to stick to the exact question everytime. – Smit Patel Jan 21 '23 at 16:58

Using ClosedXML how to adjust row height to content?

5 Answers5