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.CreateBook();
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
ExcelBuffer.GiveUserControl();
ERROR('');

[CODE Ends]

And here is the output that you will get.




I hope this resolves the issue that you have.

Thanks & Regards,
Saurav Dhyani

Comments

Popular posts from this blog

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 - 

Error After Restore SQL Backup of NAV 2013 Database

Hi all, we are facing a conman issue during restoring a SQL Database backup restored for NAV 2013. While Trying to run object from Object Designer we get below listed error (even the service is configured properly) - --------------------------- Microsoft Dynamics NAV Development Environment --------------------------- There are no NAV Server instances available for this database. You must ensure that a NAV Server instance is running and is configured to use the database before you perform this activity. --------------------------- OK    ---------------------------

Future - What Next After NAV 2016. Code Name - Madeira...

Hi All, While Browsing web I came across some article which says about next release of Microsoft Dynamics NAV. Let's see the History of Code Names Given to Previous Version  - NAV 2013 - Code Name 'Sicily' NAV 2015 - Code Name 'CRETE' NAV 2016 - Code Name 'CORFU' And as we all know that all these are the Islands.