Skip to main content

Export to Excel - Delete Un-used Sheets.

Hi all,

I know most of us know if but i still got queries where some of our colleges don't know how to delete the un-used sheets while add export to excel functionality in a Report.

So if you know how to do it you can skip this article.

Issue -

When we add the functionality of Export to excel we get a output as shown below. The excel Workbook contain sheets Report and Other standard Sheets which are named as Sheet1 , Sheet2 & Sheet3.


The sheets 1,2 & 3 are of no use and are empty. I don't want these sheets.

Resolution -

I prefer it by creating a function in master tables and calling it from report. I would suggest this also because if you create it in report then you need to create it every time.

I created a function in Table Excel Buffer and i named it as DeleteUnusedSheet as shown below -

PROCEDURE DeleteUnusedSheet@1102153003(SheetName@1102153000 : Text[30]);
    BEGIN
      XlWrkSht := XlWrkBk.Worksheets.Item(SheetName);
      XlWrkSht.Delete;
    END;  



I call this function in Post Report before Giving User Control to the sheet (Function - GiveUserControl).

How to Use From Report -


As  shown above I just called the function before Function GiveUserControl.

I hope you will like this post.

Regards,
Saurav Dhyani

www.sauravdhyani.com

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.