News and Announcements icon

Dynamics 365 CommunityForums Finance | Project Operations, Human Resources, ... how to autofit columns...

Finance | Project Operations, Human Resources, ...

Unanswered

how to autofit columns in excel file

(0) Share

Report

Report

Posted on by dark_knight

795

Hello,

I've written a class that inherits from runbasebatch and I'm using it to fill up excel file. I use two classes - OXMLWorkbook_RU, OXMLWorksheet_RU. Here I open and close Excel document:

protected void printDocument(Common   _caller)
{

    this.makeDocument();

    workbook = excelDocument.workbook();
    worksheet = workbook.getWorksheet();
    bookmark = '';


    this.createTMPTable(_caller);
    this.formatTitle(_caller);
    this.formatHeader(taskDaysFactTmp_ICL);
    this.formatBody(taskDaysFactTmp_ICL,taskDaysFactTmp_ICL_additional, _caller);
    
    excelDocument.closeDocument(true);

    comExcelDocument = new ComExcelDocument_RU();
    comExcelDocument.open(excelDocument.fileName(), true);
}

BUt excel file opens with width of the columns not according to the contains of the columns. HOw to autofeet columns? I didn't find anything useful in classes OXMLWorkbook_RU, OXMLWorksheet_RU. I found googling that it can be done like that:

sysExcelWorksheet.columns().autoFit();

But I'm not using SysExcelWorksheet class at all. How to do that in my case?

Thanks.

All responses Img

All responses (3)

Answers Img

Answers (0)

Tony Mok 577 on at

Like (0)

Report

RE: how to autofit columns in excel file

If it is OfficeOpenXml, you can use cells.get_item(1,1,worksheet.Dimension.End.Row,worksheet.Dimension.End.Column).AutoFitColumns();
dark_knight 795 on at

Like (0)

Report

RE: how to autofit columns in excel file

Hi Sergei,

I use two classes - OXMLWorkbook_RU, OXMLWorksheet_RU but class OXMLWorksheet_RU doesn't contain any autofit() methods for columns.

Thanks.
Sergei Minozhenko 23,091 on at

Like (0)

Report

RE: how to autofit columns in excel file

Hi Azat,

If I understood correctly OpenXML doesn't support autofit option and you need to calculate the width for each column based on cell content

social.msdn.microsoft.com/.../solution-how-to-autofit-excel-content

Helpful resources

News and Announcements

🌸 Community Spring Festival 2025 Challenge & Updates🌸

Quick Links

Leaderboard

#1

André Arnaud de Cal... 294,206 Super User 2025 Season 1

#2

Martin Dráb 232,968 Most Valuable Professional

#3

nmaenpaa 101,158 Moderator

Leaderboard

Featured topics

End-of-life Announcement for Microsoft Dynamics GP

Product updates

Dynamics 365 release plans