topic Re: excel uploading in Application Development and Automation Discussions

excel uploading

Former Member — Tue, 01 Jul 2008 09:13:59 GMT

Hi Experts,

i am uploading the EXCEL file to SAP using Function Module 'TEXT_CONVERT_XLS_TO _SAP', In that flat file i have one text field around 700 charecters, but from Function Module it is uploading only 256 charcters.

i have tried with both STRING and CHAR

data : var_text type string, and

data : var_text(4096) type c.

But this variables are not storing more than 256 charecters...

please give me UR valuable and HELPFUL suggestion.....

Regards

Prasad.EV

Re: excel uploading

Former Member — Tue, 01 Jul 2008 10:05:18 GMT

Hi,

Please do try the following function module,"'ALSM_EXCEL_TO_INTERNAL_TABLE'"

which will collect the excell to an internal table from where you can update to DB table.

regards,

Ajith

Re: excel uploading

Former Member — Tue, 01 Jul 2008 10:07:25 GMT

EV,

just use like that:

DATA: BEGIN OF it_excel OCCURS 0,
  belnr(10),
  xblnr(16),
  bktxt(25),
  bldat(10),
  zuonr(18),
  oac(1),
  dmbtr(16),
  pszah(15),
  wrbtr(16),
  kunnr(10),
  budat(10),
  konto(16),
  bukrs(04),
  waers(05),
  agkon(16),
  prctr(10),
  wrbtr1(16),
  spesw(15),
  kostl(10),
  sgtxt(50),

END OF it_excel.

CALL FUNCTION 'TEXT_CONVERT_XLS_TO_SAP'
    EXPORTING
*     I_FIELD_SEPERATOR          =
      i_line_header              = 'X'
      i_tab_raw_data             = it_raw
      i_filename                 = pfile
    TABLES
      i_tab_converted_data       = it_excel[]
*   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.

Amit.

Re: excel uploading

Former Member — Tue, 01 Jul 2008 10:09:36 GMT

Have a look at FM ALSM_EXCEL_TO_INTERNAL_TABLE this is fine until it gets to teh following statement

perform separated_to_intern_convert tables excel_tab intern

using ld_separator.

You should be able to utilise a lot of the code from here.

Regards

Re: excel uploading

Former Member — Wed, 02 Jul 2008 07:19:43 GMT

use function

CALL FUNCTION 'GUI_UPLOAD'

if u r using ecc 5.0/6.0

regds

jigar

Re: excel uploading

Subhankar — Wed, 02 Jul 2008 12:33:26 GMT

You have do the fallowing steps

1) Copy the FM ALSM_EXCEL_TO_INTERNAL_TABLE and make a zFM use this FM.

2) Copy the table ALSMEX_TABLINE make a Ztable using this table.

3) Change the filed(VALUE) in ztable with a 1000 char dataelement.

4) Use this table as table parameter associated type.

then the ZFM

Re: excel uploading

former_member787646 — Thu, 03 Jul 2008 10:32:16 GMT

Hi,

The Character Data Type (C) can store upto 255 characters.

If you want to store more than 255 characters then go for

STRING Data Type.

Hope it helps you.

Murthy.

Re: excel uploading

Former Member — Fri, 04 Jul 2008 07:30:48 GMT

Hi,

I do not think it is a DATA TYPE problem. As far as I understand one cannot export/import more that 256 characters into excel/word for a single field. I think this is more like a constrain.

I had a scenario where I tried replacing a word in WORD doc using a macro and it had a similar issue.

Refer to link http://support.microsoft.com/kb/212543

Regards,

Saurabh

Re: excel uploading

Former Member — Mon, 07 Jul 2008 13:07:50 GMT

Hii!

Check Out this code


REPORT  z_file3.

DATA: fname(40),
      w_line TYPE i VALUE 1,
      w_file TYPE rlgrap-filename.


DATA:
  t_tab LIKE
  TABLE OF ALSMEX_TABLINE
  WITH HEADER LINE.

DATA: fs_tab LIKE LINE OF t_tab.


w_file = 'C:\Documents and Settings\abc\Desktop\Book1.xls'.
CALL FUNCTION 'ALSM_EXCEL_TO_INTERNAL_TABLE'
  EXPORTING
    filename                      = w_file
    i_begin_col                   = 1
    i_begin_row                   = 1
    i_end_col                     = 10
    i_end_row                     = 100
  tables
    intern                        = t_tab
 EXCEPTIONS
   INCONSISTENT_PARAMETERS       = 1
   UPLOAD_OLE                    = 2
   OTHERS                        = 3
          .
IF sy-subrc <> 0.
 MESSAGE ID SY-MSGID TYPE SY-MSGTY NUMBER SY-MSGNO
         WITH SY-MSGV1 SY-MSGV2 SY-MSGV3 SY-MSGV4.
ELSE.
  WRITE: 'UPLOAD SUCCESSFUL'.
ENDIF.

fname = '.\zfile.xls'.
OPEN DATASET fname FOR OUTPUT IN TEXT MODE ENCODING DEFAULT.
LOOP AT t_tab INTO fs_tab.
  TRANSFER fs_tab TO fname.
ENDLOOP.

IF sy-subrc EQ 0.
  WRITE: / 'FILE OPENED ON APPS SERVER'.
ELSE.
  WRITE: / 'FILE COULD NOT BE OPENED'.
ENDIF.

Regards

Abhijeet Kulshreshtha