Skip to Content

how to modify data in the excel sheet.

Hi,

I have a requirement like ,

i have a excel file which contains only one column (all the data in the single colume )so now i have to modify that excel sheet and have to make some more columns based on my requirement.

eg:

column1

mumbaikolkata

delhichennai

mumbaikolkata

this shud be converted like this

column1 column2

mumbai kolkata

delhi chennai

mumbai kolkata

can i directly modify the excel sheet based on my requirement without using internal tables in between.

like excel ->internal table-> modified internaltable-> excel.

Edited by: Sravani Bellana on Dec 18, 2008 5:46 AM

Add a comment
10|10000 characters needed characters exceeded

Assigned Tags

Related questions

6 Answers

  • Best Answer
    author's profile photo Former Member
    Former Member
    Posted on Dec 18, 2008 at 05:39 AM

    Hi,

    Use 'ALSM_EXCEL_TO_INTERNAL_TABLE' to upload, and fill internal table witjhh values whatever u want, and use 'EXCEL_OLE_STANDARD_DAT' to download into excel.

    Regards,

    Krishna.

    Add a comment
    10|10000 characters needed characters exceeded

    • Former Member Sravani Bellana

      Hi sravani,

      true that we need to specify the rows and columns,

      I have worked on such applications i shall describe the possibilities and then you can find the necessary option,

      1) Function module:SAP_CONVERT_TO_XLS_FORMAT .

      it needs

      file path p_file type rlgrap-filename and

      i_tab_sap_data (the internal table name).

      2) Function module : MS_EXCEL_OLE_STANDARD_DAT

      it needs

      file path p_file like RLGRAP-FILENAME

      data_tab (int_data "internal table with data)

      fieldnames (int_head "internal table with header)

      3) if the download application is a one time then go for the following option:

      write the program to display the data in the internal table on the screen.

      execute the program.

      type %pc on the command bar and try downloading using the options displayed.

      hope any one of these work out.

      get back if you till have any clarificatrion

      thanks

      srikanth

  • author's profile photo Former Member
    Former Member
    Posted on Dec 18, 2008 at 04:54 AM

    hi

    you can check out this fm aslm_excel_to_internal_table.it requires the number of coloumns you want to have in your excel sheet.so you can give any number of coloumns depending on your requirement.

    hope it helps

    regards

    Aakash Banga

    Add a comment
    10|10000 characters needed characters exceeded

  • author's profile photo Former Member
    Former Member
    Posted on Dec 18, 2008 at 04:56 AM

    hi

    kindly refer : how-save-a-excel-sheet-automatically-

    it will help you a lot

    regards

    rahul

    Edited by: RAHUL SHARMA on Dec 18, 2008 6:02 AM

    Add a comment
    10|10000 characters needed characters exceeded

  • author's profile photo Former Member
    Former Member
    Posted on Dec 18, 2008 at 04:51 AM

    HI,

    which is impossible..You need to take the data into the internal table and modify the data into two coloumns and download to excel sheet.

    Add a comment
    10|10000 characters needed characters exceeded

  • author's profile photo Former Member
    Former Member
    Posted on Dec 18, 2008 at 04:52 AM

    Dear,

    Asper my knowledge,

    you can modify the data through internal table, u can not intercat with the excel directly.

    Regards

    Add a comment
    10|10000 characters needed characters exceeded

  • author's profile photo Former Member
    Former Member
    Posted on Dec 22, 2008 at 12:00 PM

    Hi Sravani

    u can use

    'EXCEL_OLE_STANDARD_DAT' function Module.

    Regards

    Adesh

    Add a comment
    10|10000 characters needed characters exceeded

Before answering

You should only submit an answer when you are proposing a solution to the poster's problem. If you want the poster to clarify the question or provide more information, please leave a comment instead, requesting additional details. When answering, please include specifics, such as step-by-step instructions, context for the solution, and links to useful resources. Also, please make sure that you answer complies with our Rules of Engagement.
You must be Logged in to submit an answer.

Up to 10 attachments (including images) can be used with a maximum of 1.0 MB each and 10.5 MB total.