topic excel file in Application Development and Automation Discussions

excel file

Former Member — Wed, 25 Jan 2006 09:09:47 GMT

hi!

i am using fm WS_DOWNLOAD and after that bapi_document_change2 (with table objectfiles) in order to

add original type XLS to the document.

if i am doing this manually in cv02n and add an excel file

it works o.k, but with the bapi after loading the file to cv02n, when i want to watch the file i get error 'problem

loading file'.

i found out that the fields in the file has to be in text format

in order to load the file correctly.

how do i do this with the fm WS_DOWNLOAD ( i transfer to the fm the fowlling fields in the importing part:

FILETYPE = 'DAT' and the FILENAME).

REGARDS

YIFAT

Re: excel file

Former Member — Wed, 25 Jan 2006 09:12:51 GMT

First of all save the data in the excel file to ".txt of tabbed delimited format". Now again save it to excel file. i hope this will solve ur problem.

Cheers...!

Re: excel file

Former Member — Wed, 25 Jan 2006 09:19:51 GMT

HI!

THANKS FOR YOUR ANSWER.

ALL THIS HAS TO BE DONE AUTOMATICALLY WITHOUT THE USER INTERVERSION.

REGARDS

YIFAT

Re: excel file

hymavathi_oruganti — Wed, 25 Jan 2006 09:23:57 GMT

ISU_TRANSFER_TO_EXCEL

transfers document data to excel.

ALSM_EXCEL_TO_INTERNAL_TABL

transfers excel to internal table

Re: excel file

Former Member — Wed, 25 Jan 2006 09:36:13 GMT

HI!

I AM WORKING WITH 46C.

I DONT HAVE THE FM ISU_TRANSFER_TO_EXCEL

REGARDS

YIFAT