topic Re: .xlsx file in Application Development and Automation Discussions

.xlsx file

Former Member — Wed, 11 Jun 2008 16:00:05 GMT

Hi,

CAn anyone let me know how to upload .xlsx file in abap.

Thanks,

Keerthi

Edited by: keerthi kiran varanasi on Jun 11, 2008 6:03 PM

Re: .xlsx file

Former Member — Wed, 11 Jun 2008 16:12:32 GMT

Hi Keerthi,

Check this

CALL FUNCTION 'WS_FILENAME_GET'

EXPORTING

def_path = 'R:\allg\Rohwareneinsatzplan\'

mask = '.xlsx '

mode = 'S'

title = 'Rohwareneinsatzplanung'

IMPORTING

filename = p_file

EXCEPTIONS

inv_winsys = 1

no_batch = 2

selection_cancel = 3

selection_error = 4

OTHERS = 5.

Re: .xlsx file

Former Member — Wed, 11 Jun 2008 16:27:03 GMT

hi,

use GUI_UPLOAD function module.

Regards

Sandeep Reddy.

Re: .xlsx file

Former Member — Wed, 11 Jun 2008 16:29:11 GMT

Hi,

Thanks for your replies.

ALSM_excel_to_internal_table also worls for .xlsx file as it does for .xls file.

Thnaks,

Keerthi.

Re: .xlsx file

Former Member — Wed, 11 Jun 2008 16:36:23 GMT

Hi,

I presume your source data is in .xlsx extn. and you are using Office 2003 or 2000.

Your easiest solution to upload data from this new MS 2007 format lies outside SAP .

Hers is how u do it ..

Google for MS File Format Converters, Not only will this convert your file, outside SAP you will also be able to open files created in Office 2007 while using Office 2003 on the local machine.

Google keyword : MS file converter from 2007 to 2003.

The first Link is that of Microsoft.....follow instructions to download. open your file in regular wayand save as .xls.

Hope this helps

Regards

Shubh

Ps. Kindly reply back if it works for you.

Re: .xlsx file

Former Member — Wed, 11 Jun 2008 16:42:24 GMT

Hi Keerti,

I believe you got another function module apart from GUI_UPLOAD which suits your requirement. And I think you got an answer. So please mark the question as answered..

Re: .xlsx file

former_member787646 — Wed, 11 Jun 2008 17:21:52 GMT

Hi,

Try the following code.

TYPE-POOLS: TRUXS.

DATA : T_TAB_RAW_DATA TYPE TRUXS_T_TEXT_DATA.

DATA: BEGIN OF WA OCCURS 0,

FNAME(10) TYPE C,

LNAME(10) TYPE C,

ADDR(10) TYPE C,

CITY(10) TYPE C,

STATE(10) TYPE C,

ZIP(10) TYPE C,

END OF WA.

DATA: NLINES TYPE I, FILELEN(8) TYPE P DECIMALS 2.

PARAMETERS: FILE LIKE RLGRAP-FILENAME.

CALL FUNCTION 'TEXT_CONVERT_XLS_TO_SAP'

EXPORTING

I_FIELD_SEPERATOR =
I_LINE_HEADER =

I_TAB_RAW_DATA = T_TAB_RAW_DATA

I_FILENAME = FILE

TABLES

I_TAB_CONVERTED_DATA = WA

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.

I think it helps you.

Murthy

Re: .xlsx file

Former Member — Wed, 11 Jun 2008 17:31:53 GMT

use the tcode..

CG3Z for this ..