topic Open Excel with out saving on presentation server in Application Development and Automation Discussions

Open Excel with out saving on presentation server

Former Member — Thu, 15 Nov 2007 13:15:07 GMT

Hi All

I have requirement like when I execute the report, result should open in Excel sheet automatically with out saving on Presentation server.

Please help me. Thanks in advance.

Regards

Rama

Re: Open Excel with out saving on presentation server

Former Member — Thu, 15 Nov 2007 13:25:58 GMT

Try using FM FTBU_START_EXCEL populating your data...

Regards,

Arun

Re: Open Excel with out saving on presentation server

Former Member — Thu, 15 Nov 2007 14:15:58 GMT

HI Arun

Thanks for your help, but It is opening blank Excel sheet, Internal table data not loading. I am copying the FM how I used in report. Please help me if any thing worng.

CALL FUNCTION 'FTBU_START_EXCEL'

EXPORTING

CHECK_VERSION = ' '
DATA_NAME = ' '

DATA_PATH_FLAG = 'W'

DATA_TYPE = 'ASC'

DATA_BIN_FILE_SIZE =
MACRO_NAME = ' '
MACRO_PATH_FLAG = ' '

FORCE_START = 'X'

WAIT = 'X'
IMPORTING
WINID =

TABLES

DATA_TAB = it_output

EXCEPTIONS

NO_BATCH = 1

EXCEL_NOT_INSTALLED = 2

WRONG_VERSION = 3

INTERNAL_ERROR = 4

INVALID_TYPE = 5

CANCELLED = 6

DOWNLOAD_ERROR = 7

OTHERS = 8.

Re: Open Excel with out saving on presentation server

Former Member — Thu, 15 Nov 2007 14:39:29 GMT

User the REUSE_ALV_GRID_DISPLAY AND EXCEL FUNCIONALITES

Re: Open Excel with out saving on presentation server

Former Member — Thu, 15 Nov 2007 15:33:03 GMT

Try FM <b>XXL_SIMPLE_API</b>

Rob