Hi Everyone,
I have a requirement to set the specific height of a row when exporting Excel using X .
I hope anyone can help me.
Here is my export code.
public void run() { MemoryStream memoryStream = new MemoryStream(); using (var package = new ExcelPackage(memoryStream)) { var currentRow = 1; var worksheets = package.get_Workbook().get_Worksheets(); var CustTableWorksheet = worksheets.Add("Doctor gross fee"); var cells = CustTableWorksheet.get_Cells(); var cell = cells.get_Item(currentRow, 1); OfficeOpenXml.ExcelRange cellRange; cell.set_Value('Transaction date'); cell = null; cell = cells.get_Item(currentRow, 2); cell.set_Value('Vendor account'); cell = null; package.Save(); file::SendFileToUser(memoryStream, 'MyDummy.xlsx'); } }
I have 2 columns, and I want to set a specific row height.
Thanks,
Rangga.
André Arnaud de Cal...
291,996
Super User 2025 Season 1
Martin Dráb
230,853
Most Valuable Professional
nmaenpaa
101,156