Set Height Row Excel Export x++

(0) Share

Report

Posted on by Rangga Pramana

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)