topic Re: Excel upload Error!!!!!!!!!!! in Application Development and Automation Discussions

Excel upload Error!!!!!!!!!!!

sudarshan_d29 — Tue, 16 Aug 2016 07:43:28 GMT

Hi Friends,

I am uploading Excel to Internal Table Using F4_FILENAME and TEXT_CONVERT_XLS_TO_SAP!!!!!!

Sometime It getting uploaded and sometime is not.

I have searched lot in SCN not able to find the solution.

My file path : C:\Users\Sony\Desktop\Go Colors\Upload1.xls

Upload program for FB60.

Program:

CALL FUNCTION 'F4_FILENAME'

EXPORTING

FIELD_NAME = 'PA_FILE'

IMPORTING

FILE_NAME = pa_file

if sy-subrc <> 0.

message id sy-msgid type sy-msgty number sy-msgno

with sy-msgv1 sy-msgv2 sy-msgv3 sy-msgv4.

endif.

call function 'TEXT_CONVERT_XLS_TO_SAP'

exporting

* I_FIELD_SEPERATOR =

i_line_header = 'X'

i_tab_raw_data = it_raw

i_filename = v_file

tables

i_tab_converted_data = it_data1[]

exceptions

conversion_failed = 1

others = 2.

if sy-subrc <> 0.

message id sy-msgid type sy-msgty number sy-msgno

with sy-msgv1 sy-msgv2 sy-msgv3 sy-msgv4.

endif.

clear v_file.

Please guide I don't know why is not working!!!!!!!

Regards,

Sudarshan D

Re: Excel upload Error!!!!!!!!!!!

former_member196331 — Tue, 16 Aug 2016 07:46:54 GMT

May i know what is the error message.

Re: Excel upload Error!!!!!!!!!!!

former_member196331 — Tue, 16 Aug 2016 07:50:59 GMT

Any Error like File conversion failed, please check the file.

Re: Excel upload Error!!!!!!!!!!!

sudarshan_d29 — Tue, 16 Aug 2016 07:54:22 GMT

Hi bro,

While executing the file first getting executed successfully.

But if executing again for testing purpose, its not getting uploaded.

Regards,

Sudarshan D

Re: Excel upload Error!!!!!!!!!!!

former_member196331 — Tue, 16 Aug 2016 07:56:32 GMT

If you put break point AT sy-subrc . Some return parameter will comes, have you got my point.

Re: Excel upload Error!!!!!!!!!!!

sudarshan_d29 — Tue, 16 Aug 2016 08:10:38 GMT

Hi bro,

I didn't get it!!!!!!!!!!!!

Please clarify....

Regards,

Sudarshan D

Re: Excel upload Error!!!!!!!!!!!

former_member196331 — Tue, 16 Aug 2016 08:28:16 GMT

if sy-subrc <> 0.

message id sy-msgid type sy-msgty number sy-msgno

with sy-msgv1 sy-msgv2 sy-msgv3 sy-msgv4.

endif.

clear v_file.

you Can put break point at if sy-subrc <> 0.

then execute the code.

Re: Excel upload Error!!!!!!!!!!!

PeterJonker — Tue, 16 Aug 2016 08:46:23 GMT

What is the error you are getting ? Did you debug ? If yes, At which step it is going wrong ?

Re: Excel upload Error!!!!!!!!!!!

sudarshan_d29 — Tue, 16 Aug 2016 11:32:45 GMT

Hi Bro's,

I tried Till now, while debugging it run normally without capturing data

it don't also entered into break point inside sy-subrc <> 0 .

Instead it also doesnt provide any session transaction (A-display all screen) for FB60.

Regards,

Sudarshan D

Re: Excel upload Error!!!!!!!!!!!

former_member185116 — Tue, 16 Aug 2016 11:40:29 GMT

hi sudharshan,

try below code, i have tested it , it works fine...


DATA: IT_RAW TYPE TRUXS_T_TEXT_DATA,
           IT_FNAM TYPE FILETABLE.


*sel screen declaration *****************************
 SELECTION-SCREEN BEGIN OF BLOCK b1 WITH FRAME TITLE text-001.
 
  PARAMETERS : FILE LIKE RLGRAP-FILENAME OBLIGATORY.
 
  SELECTION-SCREEN skip 1.
   
 SELECTION-SCREEN END OF BLOCK b1.
 *****************************************************
 


AT SELECTION-SCREEN ON VALUE-REQUEST FOR FILE.
   CALL FUNCTION 'F4_FILENAME'
     IMPORTING
       FILE_NAME = FILE.




 start-of-selection.
 
  CALL FUNCTION 'TEXT_CONVERT_XLS_TO_SAP'
     EXPORTING
       I_FIELD_SEPERATOR    = 'X' "is an .xls file
       I_LINE_HEADER        = 'X' "has a header line
       I_TAB_RAW_DATA       = IT_RAW
       I_FILENAME           = FILE
     TABLES
       I_TAB_CONVERTED_DATA = it_itab.

here it_itab i s your internal table that holds data of uploaded excel file...

Re: Excel upload Error!!!!!!!!!!!

sudarshan_d29 — Tue, 16 Aug 2016 13:23:57 GMT

Thanks a lot vinay!!!!!!!!!!!!

Regards,

Sudarshan D