Question Re: excel opening automatically while running report in Technology Q&A

excel opening automatically while running report

Nick__2849 — Mon, 05 Jun 2023 13:15:08 GMT

I used this function module TEXT_CONVERT_XLS_TO_SAP to access excel from presentation server to application server and the problem is that while running report, Automatically, It opens excel sheet as shown in above image, what should I do for not displaying that pop up while running report.

Re: excel opening automatically while running report

FredericGirod — Mon, 05 Jun 2023 13:19:32 GMT

Try ABAP2xlsx

Re: excel opening automatically while running report

Nick__2849 — Mon, 05 Jun 2023 16:13:03 GMT

Hi Frederic,

Can you please tell me what it means ABAP2xlsx and how to do that for not displaying excel sheet while running report...

Re: excel opening automatically while running report

matt — Tue, 06 Jun 2023 06:21:49 GMT

Try this link.

Re: excel opening automatically while running report

Nick__2849 — Wed, 07 Jun 2023 04:36:31 GMT

link is not working

Re: excel opening automatically while running report

FredericGirod — Wed, 07 Jun 2023 05:07:59 GMT

it is a non-standard tool provide by Abap developpers.

This tool is really powerfull to manage Excel file

You could find it in the Git using the ABAPGit (it could be little bit long to understand ABAPGit and ABAP2xlsx, but it is a real additionnal value)

Re: excel opening automatically while running report

Sandra_Rossi — Mon, 12 Jun 2023 12:02:03 GMT

It never happens that Excel opens automatically when you just display ALV.

It should open only if the user clicks on the button to export to Excel.

Re: excel opening automatically while running report

Nick__2849 — Tue, 13 Jun 2023 09:38:50 GMT

Hi Sandra rossi,

While uploading excel sheet from application server to presentation server and it opens excel sheet automatically amd i need not to display it while running in report and it opens excel sheet when calls function module TEXT_CONVERT_XLS_TO_SAP.

Re: excel opening automatically while running report

Sandra_Rossi — Tue, 13 Jun 2023 10:09:00 GMT

The function module TEXT_CONVERT_XLS_TO_SAP starts Excel, opens the file which you indicate in the parameter of the function module, and returns the contents of the Excel file.

Saying "automatically" whenever you run a function or a program is the same as not saying "automatically"

e.g. GUI_UPLOAD automatically uploads the file

versus

GUI_UPLOAD uploads the file.

If you don't want to open Excel, don't use TEXT_CONVERT_XLS_TO_SAP, use other solutions to read an Excel file.

(you can find thousands of answers in the forum)

Re: excel opening automatically while running report

Nick__2849 — Tue, 13 Jun 2023 12:45:22 GMT

hi sandra rossi,

Please tell me that which function module i should use to convert excel to internal table

Re: excel opening automatically while running report

matt — Tue, 13 Jun 2023 14:12:58 GMT

As Sandra Rossi said "you can find thousands of answers in the forum". Or you could follow the first link I gave you.

Re: excel opening automatically while running report

Octavio_SA — Fri, 06 Sep 2024 21:00:27 GMT

Hi Junaidshaik284,

Re: excel opening automatically while running report

Octavio_SA — Fri, 06 Sep 2024 21:01:37 GMT

Hi Junaidshaik284, did you get the solution for this, or did you replace the FM?

Re: excel opening automatically while running report

Sandra_Rossi — Sat, 07 Sep 2024 07:47:44 GMT

@Octavio_SAjust search "abap2xlsx"