excel opening automatically while running report

[Nick__2849]

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.

[FredericGirod]

Try ABAP2xlsx

[Nick__2849]

Hi Frederic,

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

[matt]

Try this link.

[Nick__2849]

link is not working

[FredericGirod]

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)

[Octavio_SA]

Hi Junaidshaik284,

[Octavio_SA]

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

[Sandra_Rossi]

@Octavio_SAjust search "abap2xlsx"

[Sandra_Rossi]

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)

[Nick__2849]

hi sandra rossi,

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

[matt]

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

[Sandra_Rossi]

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.

[Nick__2849]

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.