To transfer data in excel sheet..

Advertisement

hi experts,
     please let me know how do we transfer the sap data to excel sheet?...using any method..
thanks in advance...

Advertisement

Hi,
If you are using ALV there should be an icon
( F9 Function ) for download to spreadsheet
also using GUI_DOWNLOAD FM also you can download data into word ,excel or in rtf or html format
and u want to ur data frm aplication server then use dataset concepts
regards
Santosh L...

November 30, -0001

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

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'   

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

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

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

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

Data in excel sheet to be used for programing

Hi, I have to make a z report for which the data i have to use is in a excel sheet. How can I use this data for making different reports. Reg, ArchanaHi, Try the following code for multiple sheets. data : $i_intern type  kcde_cells occurs 0 with head

Uploading Data From Excel Sheet to SAP Database Tables

Dear Friends, We are having an Excel Sheet with 90 different columns. Now we want only 2 of the columns to be uploaded in the database tables. So, Plz tell me which function module will be suitable for this. And plz help me with the code also. Thanks

Oracle function to extract data into excel sheet

I have extracted data from a couple of tables onto a view. Basically I have got about 15 coloums in that view but i need to extract the data in the view into an Excel sheet. I just want to know if their is a function in oracle whereby i can export th

Exporting data into excel sheet from CRM

Hi All, I am facing problem while extracting data from CRM - Service Process Monitor. I tried to extract data(records) from executed service process monitor through System -> List ->Save->Local file->Spreadsheet I am not getting actual records

Problem in spooling the clob data to Excel sheet

Hi dev's currently i am using below version : Oracle Database 11g Enterprise Edition Release 11.2.0.1.0 - Production           PL/SQL Release 11.2.0.1.0 - Production                                           CORE     11.2.0.1.0     Production        

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

How to delete the Junk Data From Excel Sheet

Dear ABAPers,             I am uploading the Excel sheet from the Desktop to the SAP System. In the Internal table i am getting Unwanted Junk data's for Example '##########'.I am not getting this Junk data for all the times. i am getting it for Some

Uploading data from Excel sheet into SAP.

Dear All, I want to upload data existing in Excel sheet into SAP. Is there any possibility with the following requirements? 1) Excel file contains serial numbers with different values.Like power(230Wp),Voc,Isc,Vmp and Imp. 2) We need to upload the sa