web
You’re offline. This is a read only version of the page.
close
Skip to main content
Community site session details

Community site session details

Session Id :
Finance | Project Operations, Human Resources, ...
Unanswered

Set Height Row Excel Export x++

(0) ShareShare
ReportReport
Posted on by 245

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. 

I have the same question (0)

Under review

Thank you for your reply! To ensure a great experience for everyone, your content is awaiting approval by our Community Managers. Please check back later.

Helpful resources

Quick Links

Responsible AI policies

As AI tools become more common, we’re introducing a Responsible AI Use…

Neeraj Kumar – Community Spotlight

We are honored to recognize Neeraj Kumar as our Community Spotlight honoree for…

Leaderboard > Finance | Project Operations, Human Resources, AX, GP, SL

#1
Martin Dráb Profile Picture

Martin Dráb 683 Most Valuable Professional

#2
André Arnaud de Calavon Profile Picture

André Arnaud de Cal... 563 Super User 2025 Season 2

#3
Sohaib Cheema Profile Picture

Sohaib Cheema 398 User Group Leader

Last 30 days Overall leaderboard

Product updates

Dynamics 365 release plans