topic Re: Selection Screen Excel File Format in Application Development and Automation Discussions

Selection Screen Excel File Format

Former Member — Fri, 07 Oct 2011 06:58:39 GMT

Hi,

I developed a BDC report to upload data. Data is uploaded Perfactly.

parametrs: p_file TYPE rlgrap-filename.

and Excel file format is Storage Location Matnr Stock_Qty

1000 Mat_00001 50

but i want to give eaxel file screen shot with sample data

is it possible to give excel format screen shot on selection screen

before parametrs: p_file TYPE rlgrap-filename.

Re: Selection Screen Excel File Format

Former Member — Fri, 07 Oct 2011 07:03:24 GMT

i didnt get ur question ...

but i thnk this fm wld help u a little

ALSM_EXCEL_TO_INTERNAL_TABLE

Re: Selection Screen Excel File Format

Former Member — Fri, 07 Oct 2011 07:19:55 GMT

Please make screenshot of excel sheet as image and store in SAP system.

Refer the below link to display the image in selection screen

http://wiki.sdn.sap.com/wiki/display/Snippets/Displayimagesontheselection-screen

Please let me know if it helps you.

Regards

Mohamed

Re: Selection Screen Excel File Format

Former Member — Fri, 07 Oct 2011 08:03:41 GMT

Hi,

Add a button to your selection screen and create your excel template with OLE. I follow this way. I think it s simply solve template issue but if you don t want to use this way image is still not a good altenative. Upload your template excel to SAP system with OAOR transaction and call with this file with functions.

Take care.

Çağatay

Re: Selection Screen Excel File Format

Former Member — Fri, 07 Oct 2011 08:35:47 GMT

Hi ,

If you want to do that for letting the user know the format of the file .

Instead of that i think we can add some commenst kinf of thing on selction screen makinga block

which says format is t is column 1 is what ever u have mentioned in ur query .

Eq:

SELECTION-SCREEN BEGIN OF BLOCK b2 WITH FRAME TITLE text-001.( This File format)

SELECTION-SCREEN COMMENT /25(40) text-021." Here u can say Column-MATNR (eg)

SELECTION-SCREEN COMMENT /25(40) text-023.

SELECTION-SCREEN COMMENT /25(40) text-024.

SELECTION-SCREEN COMMENT /25(40) text-025.

SELECTION-SCREEN END OF BLOCK b2.

ThankYou,

Poornima

Re: Selection Screen Excel File Format

Former Member — Fri, 07 Oct 2011 09:10:08 GMT

Sorry , Not able to understand the the solution..

Actually this bdc is used after 1 year at end of stock taking. so user forget the file format . To avoid this, want to display a picture

of excel with sample data.

otherwise, i hvae done through SELECTION-SCREEN COMMENT /1(20) text-001.

Is it possible to give excel sample.

Thanks

Re: Selection Screen Excel File Format

Former Member — Fri, 07 Oct 2011 09:29:29 GMT

Hi,

I was telling if its only to tell user we can print like comment at the end .I have pasted the code for you .

it will look at at the bottom of your screen.

After you declare your slection screen parameters then paste the code and first text you create text element which has- MS EXCEL format types

Second textelemnt-Give column1 - "so and so ......

was i clear this time...

It not poss to give scrreen shot thriugh above way but throuh your text elemnt message you convery what is colum 1,2 .... to user

Thank You

Poornima

Edited by: Pendyala_poornima on Oct 7, 2011 3:01 PM

Edited by: Pendyala_poornima on Oct 7, 2011 3:03 PM