Downloading table data into Excel sheet - Webdynpro Java

Advertisement

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 are around 11,000 & columns are 32, and when user tries to download whole 11000 rows in excel sheet, the timeout occurs after 20 mins due to huge data. But when I apply filtering on the same table data and then try to download some 700 rows out of 11000 into excel, it took me around 3.36 mins.
If anyone encountered such scenario in past, please guide in this regard to speed-up the download to excel functionality or suggest any other alternative.
We are using 7.3 Portal and tableUtilities java class for export to excel functionality.
Thanks,
Amol.

Advertisement

hi monica ,
sorry im not able to understand properly ,
The server don't restarts automatically when we uploading a huge data, onlly we open the file instead of save the file.
If we save the file the problem is that when we try to open this, the process can take hours and sometimes excel is blocked
you mean that after saving the file to your desktop , having huge data you are not able to open the file i.e the excel file. your file gets blocked or consumes more time to open the file ,
or else when you are prompted for saving or opening , on click of opening  you are facing the problem ?
let me be clear with your part , here your application deals with uploading the data from webdynpro table to excel sheet and allowing the end user to save or open the file  right .
Regards
Govardan Raj S

October 11, 2015

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

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

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

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 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

How to convert internal table data into excel format?

Hi all, I want to convert internal table data in excel format and then send it as email attachment in workflow. Please tell me how do i perform this. Regards, Arpita.Hi Arpita, Try this sample code:: Send mail maildata-obj_name = 'TEST'. maildata-obj

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

Get data from view and displaying the table data into Excel  pivot table

Hi All, I have a small reqirement inthat When i get the data from the View that would displayed as Excel Pivot table. For displaying gerneral data to Excel I have followed Binarcy cachey Please suggest me in this. Thanks, Lohi. Message was edited by:

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

Possible to export Tuple data along with main table data in Excel sheet?

Hi Expert, Wondering is it possible to export tuple table data from data manager along with main table data? Regards, RajeevRajeev, I am afraid that functionality of exporting tuples data using data manager is not available at the moment till MDM 7.1

How to download data displayed in a BSP page into Excel sheet

Hi, I'm displaying an internal table data into tableview of a BSP page. I want to provide a feature to download the tableview contents to Excel sheet from Internet Explorer.  How do I do it?  Can someone guide me. Kedhar.Hi Kedhar, welcome to SDN. Yo

Downloading the multiple columns(Multiple fields) into excel sheet in OLE

HI friends,                 I am using OLE method to download 3 internal tables data into 3 worksheeets in one excel file. i am able to create 3 worksheets.but i am getting the whole data merged into one column(A column) where as i want 5 columns in

How to export the data as integer into excel sheet?

Hi All,      I am working on export to excel functionality and using JEXCEL API to create it.  When I export the data to excel sheet, the data are stored in text format in the excel sheet.  If I click on summation button on excel sheet,  it is not su

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

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 to download internal table data into xml file?

Hi, Experts, I have downloaded internal table data into XLS format using GUI_DOWNLOAD Function module, But i didn't Know how to download internal table data into XML format please post some ideas/inputs on this issue. Thank you, Shabeer ahmed.check t

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

Download header data to excell

Hi guru, I am using gui_download for downloading header data to excell.The probleam i am facing that the field length(so many descriptions) exceeds more than 256 char. so iam unable to download some of data .I want it should display in one line in th

How export report into excel sheet automatically using SSRS 2010?

Hi, I have created many reports using SQL Server Data Tool 2010 and at my work, we are using active batch to ran reports every month. Now question is, my boss want me to set up reports such a way that when active batch is ran, reports should be expor