Skip to main content

Notifications

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. 

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

Announcing Our 2025 Season 1 Super Users!

A new season of Super Users has arrived, and we are so grateful for the daily…

Vahid Ghafarpour – Community Spotlight

We are excited to recognize Vahid Ghafarpour as our February 2025 Community…

Congratulations to the January Top 10 leaders!

Check out the January community rock stars...

Leaderboard

#1
André Arnaud de Calavon Profile Picture

André Arnaud de Cal... 291,996 Super User 2025 Season 1

#2
Martin Dráb Profile Picture

Martin Dráb 230,853 Most Valuable Professional

#3
nmaenpaa Profile Picture

nmaenpaa 101,156

Leaderboard

Product updates

Dynamics 365 release plans