Downloading data in excel sheet

Advertisement

Hi All,
    I want to download data in excel sheet. My requirment is to use the same excle sheet to fill data.
The next data should be entered in the column of the excel sheet. Is there a possible to write data in excel sheet at a particular row/column.
   Please let me know if this can be achevied?
For Ex:
Data: 10, 20, 30
Excel sheet:
10
20
30
Data: 40, 50, 60
Excel sheet:
10          40
20          50
30          60
Thanks & Regards,
Rupali Ray

Advertisement

Hi,
This should be possible by OLE concept.
Have a look at report RSDEMO01
Regards

October 11, 2015

Downloading data in excel sheet

Hi All,     I want to download data in excel sheet. My requirment is to use the same excle sheet to fill data. The next data should be entered in the column of the excel sheet. Is there a possible to write data in excel sheet at a particular row/colu

How can i download data in excel sheet .

Hi all My Requirement : In a selection screen after giving a VBELN,It will show all the related data from VBRP table through alv  . There are a customize icon ,after clicking the icon it will download all fetched data . Can any one help me .how can i

How to Restict number of rows to download data in excel sheet

hi, my requirement is that i m showing top 50 seller in my dashboard. but when we click on download to excel then all 500 rows are downloading. i want to restrict downloading all data and want show only displayed data of dashboard in excel sheet.(ex

Function Module to DownLoad data in excel.

Hi All, Is there a FM to download data in excel sheet. Regards, Vidya.Hi use this works. TYPE-POOLS: truxs. DATA: it_raw TYPE truxs_t_text_data. Uploading data from Local system to SAP. PARAMETERS: p_file TYPE  rlgrap-filename. AT SELECTION-SCREEN ON

Downloading table data into Excel sheet - Webdynpro Java

Hi All, We have developed a custom webdynpro application that executes an RFC and displays data in Table UI element. We have provided a button to download the data in excel sheet. When data is huge like, total number of rows filled up in the table ar

Download internal table data into excel sheet with column heading and data

Hi,   I am having one internal table with column headings and other table with data. i want to download the data with these tables into an excel sheet. It should ask the user for file name to save it on their own name. They should give the file name

To transfer data in excel sheet..

hi experts,      please let me know how do we transfer the sap data to excel sheet?...using any method.. thanks in advance...Hi, If you are using ALV there should be an icon ( F9 Function ) for download to spreadsheet also using GUI_DOWNLOAD FM also

How to downlaod vednor master data into excel sheet in SAP Application ser

Hi friends I want to download SAP vendor master data into excel sheet and the file should be stored in SAP Application server Location with padding zeros. Please help me. ThanksHi Ramesh, You can download the data into application server using the fo

Download to multiple excel sheets

Hi all, How can we download data to different sheets in one excel using 2 internal tables. Thanks, Rajesh.Hi thanks for the reply, i almost solved the problem, except i need to save the excel file in a particular directory. what is the procedure. the

Problem while exporting data to Excel sheet.......

Hi I have written the following code to export data to excel sheet... data:        conv_out TYPE REF TO cl_abap_conv_out_ce,        content TYPE xstring. data : itab_slsrl type table of znslsrlitm. data: xml_out TYPE string. Data: Node_slsrl type ref

How to  send ALV output data into Excel sheet format via Mail to the user?

Hi friends, I have a doubt ie, How to  send ALV output data into Excel sheet format via Mail to the user? regards MoosaHi, Provide the output internal table to the objbin in the below FM Send Message   CALL FUNCTION 'SO_NEW_DOCUMENT_ATT_SEND_API1'   

How to download data in excel from web report in sap ?

how to download data in excel from web report made  in sap abap? through tcode smw0.for exemple using MS_EXCEL_OLE_STANDARD_DATRead other 2 answers

Urgent - Migrate data from Excel sheets

Hello all.. I want to move data from excel sheets into oracle9i Database I have a bout 50 table with average of 5000 row per table How could I do it I will be so obligated if you could detail it for me Thanks in advanceI want to insert data using loa

How to read the data in excel sheet

Dear sir, How to read the data in excel sheet when i recieve a data serial communication... ie i have store a data in excel such that Cell A       Cell B    A           Apple     B           Ball    C           Cat    D           Doll when i recieve

Export Data into Excel Sheet in UNIX

Hi All How to export the table data into excel sheet in unix. ThanksCreate a csv file. A csv file is just an ascii file, so it doesn't matter what OS you are on.Read other 2 answers

Download Data From Excel - VBA Code to SAP Using BDC

Hi , I am Sudhir Dure, working with Satyam Computers. I need help on the below query: I have an excel file which download data from Excel to SAP using RFC function & with the help of VBA interface. In this VBA code I have used BDC recording of SAP Tr

Read data from excel sheet and then perform the required operations.

Hi all I need to write a procedure which can read data from excel sheet.I have excel sheet in which i have to options one is modification and other is addition.so if it reads modification then i need to read the concerned table name then check its av

How to populate the Quering data into Excel sheet in Oracle

Dear Guys, How to populate the Quering data into Excel sheet in oracle. Please provide a solution. Thanks & Regards, Senthil K KumarHi To make Excel sheets from sqlplus, you can use the markup html tag in sqlplus. Here's an example. Example <code&g

Getting short dumps while reading bulky data from excel sheet

Hi all, We have converted our non-unicode based sap system (R/3 4.7, Windows 2003, SQL 2000) into a unicode based system recently. We are facing two peculiar problems for last few days. *Problem 1 - *Whenever we want to upload the data from excel she

Regarding downloading data into excel from alv output

hi experts, i have developed a customized report(ALV) in which the employee number and all details are coming but when i press download to excel button and get downloaded it to the excel sheet the employee number is only not coming but all details ar