topic Re: Excel upload in Application Development and Automation Discussions

Excel upload

Former Member — Thu, 28 Feb 2008 20:19:23 GMT

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

Re: Excel upload

Former Member — Thu, 28 Feb 2008 20:24:02 GMT


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.

Re: Excel upload

Former Member — Thu, 28 Feb 2008 20:26:32 GMT

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

Thanks.

Re: Excel upload

Former Member — Thu, 28 Feb 2008 20:30:34 GMT

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.

Re: Excel upload

Former Member — Thu, 28 Feb 2008 20:38:27 GMT

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?

Re: Excel upload

Former Member — Thu, 28 Feb 2008 20:43:09 GMT

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.

Re: Excel upload

Former Member — Thu, 28 Feb 2008 21:31:14 GMT

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