excel cell height not increase automatically based on content size?

Question

I'm using Microsoft.Office.Interop.Excel to write data into excel cell. cell has certain height initially and i m setting both "merge cell = true" and "wrap text = true".

when the cell content is large, the cell height is not increased, here I tried both,

_range.entrirerow.autofit() 
_range.columns.autofit()

but doesn't work anything for me, please suggest some solution.

Answer 1

If your Excel sheet has a predefined format, Means you already know which type of data will come in which row and column. Then Create an Excel template for this format and started writing into a new copy of this template, It will decrease your formatting effort at programming level.

---

Kapul

Answer 2

Try posting in Excel for Developers Forum

---

Mark Answered, if it solves your question and Vote if you found it helpful.
Rohit Arora

Answer 3

This should be taken care by MS.I do not find any solutions.

---

Asadulla Javed