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