web

You’re offline. This is a read only version of the page.

Dynamics 365 CommunityForums Small and medium business | Business Central, N... Report Export To Excel...

Small and medium business | Business Central, N...

Suggested answer

Report Export To Excel - Set Worksheet Name

(0) Share

Report

Report

Posted on by Samantha73

3,197

Hi All,

I have created a report and I can use "send to" and select excel so it can be saved in excel. Now the question is, is there any way to control the worksheet name once exported to excel?

Currently, it comes up as "Sheet1". We use this excel file as an import file to another external system

Thanks

I have the same question (0)

All responses Img

All responses (1)

Answers Img

Answers (0)

Suggested answer

MahGah 15,529 on at

Like (0)

Report

RE: Report Export To Excel - Set Worksheet Name

Hi

See this post

specially the answer below

Final working solution:

IF ISCLEAR(xlApp) THEN

CREATE(xlApp, FALSE, TRUE);

xlBook:=xlApp.Workbooks.Add;

xlSheet := xlBook.Worksheets.Item('Sheet1');

Code...

xlSheet.Activate();

xlApp.Visible(TRUE);

Was this reply helpful? Yes No

Join the conversation

Helpful resources

Quick Links

Leaderboard > Small and medium business | Business Central, NAV, RMS

#1

Sumit Singh 2,674

#2

Rishabh Kanaskar 2,580

#3

YUN ZHU 2,115 Super User 2025 Season 2

Last 30 days Overall leaderboard

Featured topics

Product updates

Dynamics 365 release plans