Excel upload

[Former Member]

Hye...

My input is a parameter which contains the output file destination path.

parameter: p_path type char50.

Now i want to upload the data of internal table to the excel in the given path. when i am using fm gui_upload it is eliminating non values in the cells, it is considering only the non-zero part of the column... if the column has value '0012', the output in the cell is '12'.

Please give me any code as how to upload using the directory as input.. urgent..

Thanks in advance.

Edited by: Alvaro Tejada Galindo on Feb 28, 2008 3:21 PM

[Former Member]

Now i want to upload the data of internal table to the excel in the given path. 

You want to updload the internal table to a Excel file???

Could you explain...I know that we can upload an Excel to an Internal Table or Download an Internal to an Excel...

Greetings,

Blag.

[Former Member]

i want to download the contents of the internal table to the excel.

Thanks.

[Former Member]

Ok -:)

Have you tried to change the data types for C...I mean...

Instead of having

DMBTR TYPE MSEG-DMBTR.

Use...

DMBTR(15) TYPE C.

That might work...

Greetings,

Blag.

[Former Member]

Do you mean Excel is converting '0012' to '12'.?

If that's so, I don't think you can fix that with gui_download, because excel is treating that data as a numeric type.

Are you just passing the internal table as .xls?

[Former Member]

Yes i am passing the internal table with coloums of char type to .xls.. i knw gui_download is not helping me in that case. i want some other solution.. i also tried 'MS_EXCEL_OLE_STANDARD_DAT' which does not take my input parameter as file_name and also the result is same.. the field is considered as neumeric. any better solution.

[Former Member]

Look at this thread

Is a really good solution. You can print a character before the number with the leading zeros, one guy gives a series of characters that don't appear in excel.

Is a good solution if no one is going to use that sheet to upload data or manipulate it in for of sums or other numeric functions.

I've been thinking of writing a function to download data in xml to excel. Never looked at the blogs, try those, maybe someone tought about the idea first