Skip to main content

Export to Excel - With Fixed Column Width / Row Height

Hi all,

This article is based on request from my friend  +Damith Shan Abeywicrema.

Hey, man below are the steps how you can achieve it.
Create a function in Excel - say Setwidth as shown below 

[CODE Start]

SetWidth(Type : 'Row,Column';RangeName : Text[30];Width : Decimal)

IF Type = Type :: Column THEN
  XlWrkSht.Range(RangeName).ColumnWidth := Width;

IF Type = Type :: Row THEN
  XlWrkSht.Range(RangeName).RowHeight := Width;

[CODE End]

call this function before giving control to user in report as shown below.

[CODE Starts]

ExcelBuffer.CreateSheet('Sheet 1','Column Width',COMPANYNAME,USERID);
ExcelBuffer.SetWidth(0,'1:5',20); // FOR ROW 1 TO 5
ExcelBuffer.SetWidth(1,'2:2',40); // FOR Column 2

[CODE Ends]

And here is the output that you will get.

I hope this resolves the issue that you have.

Thanks & Regards,
Saurav Dhyani


Popular posts from this blog

Welcome - Microsoft Dynamics 365!

Hi All, In this article we will discuss the new introduced member of Dynamics Family. Yes you heard it correctly, one more new member with Name "Microsoft Dynamics 365" . #ProjectMadeira   #Dynamics365

Send Mail with Attachment From Navision.

Hi all, We have seen how to save a report into PDF and how to send mail to a customer. Let's link these two post in one i.e. Mailing statement to a customer into PDF Format. This article is part of the Series. Please Refer  Table of Content here . If you have the old objects set let me brief you what I will be changing - 

NAV 2013 Credential Type - How to Use?

Hi all, Please do these activities when you have time, its a long activity and i would suggest do all activities in one go. So be clam and lets start. For NAV 2013 R2 Refer Here. For NAV 2016 Steps have been Reduced Please Refer Here. I have installed NAV 2013 and its work great with my windows credentials. I was checking the service console (Microsoft Dynamics NAV Administration) in NAV 2013 and found out that Credentials Type have multiple Options.