topic Re: Purpose of this function module? in Application Development and Automation Discussions

Purpose of this function module?

Former Member — Fri, 09 Jun 2006 06:14:18 GMT

Hi Abapers,

Please let me know the purpose of this function module.

RH_START_EXCEL_WITH_DATA.

regards,

vijay

Re: Purpose of this function module?

Former Member — Fri, 09 Jun 2006 06:16:45 GMT

Hi Vijay,

This module enables you to transfer ASCII data (Parameter DATA_TABLE) to a front end and subsequently to start Excel. The system automatically opens the file with the data (parameter DATA_FILENAME).

You can start Excel modally or modelessly (parameter WAIT). If you start Excel modally, you can specify that the file is to be automatically deleted when Excel is closed (DELETE_FILE = 'X').

Standard path specifications can be added automatically to the file names transferred (Parameters DATA_PATH_FLAG, DATA_ENVIRONMENT, MACRO_PATH_FLAG, and MACRO_ENVIRONMENT). Refer to the function RH_COMPILE_FILENAME for a list of the index abbreviations currently supported.

In addition, when you start Excel, you can simultaneously load a macro. The name of the macro is in the parameter MACRO_NAME.

Refer the link.

Rgds,

Prakashsingh

Re: Purpose of this function module?

Former Member — Fri, 09 Jun 2006 06:17:18 GMT

Hi vijay,

1. It will open EXCEL

with our data

which is specified in the internal table.

regards,

amit m.

Re: Purpose of this function module?

Former Member — Fri, 09 Jun 2006 06:18:22 GMT

Hi,

<b>Taken from documentation:</b>

This module enables you to transfer ASCII data (Parameter DATA_TABLE) to a front end and subsequently to start Excel. The system automatically opens the file with the data (parameter DATA_FILENAME).

You can start Excel modally or modelessly (parameter WAIT). If you start Excel modally, you can specify that the file is to be automatically deleted when Excel is closed (DELETE_FILE = 'X').

In addition, when you start Excel, you can simultaneously load a macro. The name of the macro is in the parameter MACRO_NAME.

rgds,

latheesh

Message was edited by: Latheesh Kaduthara

Re: Purpose of this function module?

Former Member — Fri, 09 Jun 2006 06:19:14 GMT

Hi,

It allows you to download an internal table into a spreadsheet.When calling this FM you pass the internal table, then Excel starts automatically and opens up with the data from your internal table.

Check these links for examples:

Regards,

Anjali

Re: Purpose of this function module?

dani_mn — Fri, 09 Jun 2006 06:19:47 GMT

This module enables you to transfer data (Parameter DATA_TAB) to a frontend and subsequently to start Excel. The system automatically opens the file with the data (parameter DATA_NAME).

The function offers a number of additional features:

You can specify a minimum version for Excel required for the function module to run (parameter CHECK_VERSION). If you make no input here (SPACE), no check is carried out.

You can start Excel modal or modeless (parameter WAIT).

You can transfer data in various formats (parameter DATA_TYPE). For a list of valid data types, please refer to the function

Regards,

Wasim Ahmed

Re: Purpose of this function module?

Former Member — Fri, 09 Jun 2006 06:21:09 GMT

If you mention the Excel sheet file path in the 'DATA_FILENAME' of the EXPORTING parameters of the FM 'RH_START_EXCEL_WITH_DATA', it will open that particular excel file.

Re: Purpose of this function module?

Former Member — Fri, 09 Jun 2006 06:22:11 GMT

Starting Excel with Data Download and Execution of a Macro

plz rewards the points if it is helpful

Re: Purpose of this function module?

Former Member — Fri, 09 Jun 2006 06:31:51 GMT

Hi vijay,

1. Suppose i want to show some data

DIRECTLY IN EXCEL,

from my internal table.

2. Just copy paste in new program.

(it will show data from T001 Table,

directly into excel)

report abc.

*----

data : itab like table of t001 with header line.

select * from t001 into CORRESPONDING FIELDS OF table itab.

*----

CALL FUNCTION 'RH_START_EXCEL_WITH_DATA'

EXPORTING

DATA_FILENAME = '\ABCdd.XLS'

DATA_TABLE = ITAB[]

WAIT = 'X'

DELETE_FILE = 'X'

EXCEPTIONS

NO_BATCH = 1

EXCEL_NOT_INSTALLED = 2

INTERNAL_ERROR = 3

CANCELLED = 4

DOWNLOAD_ERROR = 5

NO_AUTHORITY = 6

FILE_NOT_DELETED = 7

OTHERS = 8.

regards,

amit m.

Re: Purpose of this function module?

Former Member — Wed, 04 Oct 2006 06:42:51 GMT

Hi Anjali,

i have a problem with der FM "RH_START_EXCEL_WITH_DATA". After the release of our SAP-system changed to ERP2005 the FM doesn't work. After calling the FM with an filled internal table Excel starts but the spreadsheet is empty.

What can i do?

Regards

Jutta

Problem is solved. There is no more an TABLES parameter DATA_TAB, now the internal table is an exporting parameter named DATA_TABLE.

Message was edited by: Jutta Campbell

Re: Purpose of this function module?

Former Member — Tue, 12 May 2009 17:05:17 GMT

Hi All,

Do you have some issues with FM RH_START_EXCEL_WITH_DATA when your Excel is 2007?

The data is either corrupted or garbled.

Thanks.

Jaime

Re: Purpose of this function module?

Former Member — Tue, 12 May 2009 17:17:33 GMT

What GUI patch level do you have?

Rob