Downloading data into Excel

[Former Member]

Hi guys,

I am trying to download data into Excel sheet with heading as I need to change the some filed contents

& save this file as ".TXT" tab delimited that is uploaded by another program .But now my problem is

if the records are more that the max. Limit of Excel (65..............) Data is not completely downloaded.

Also I need to download the data in a form so that it has headings and can alter the contents by user and upload the same again.Please guide.

[Former Member]

Hi,

Refer to this link..[Download to excel with more than 65000 records|https://www.sdn.sap.com/irj/scn/directforumsearch?threadid=&q=downloadtoexcelwithmorethan65000+records&objID=c42&dateRange=all&numResults=30&rankBy=10001]

[Former Member]

Hi,

Why dont you try downloading the data into notepad. It does not have a limit and data can be changed after download.

tc

saji

[Former Member]

Please install excel 2007 on your system which allows you to access more than 65000 records.

also while downloading give the file name as xlxs.

OLE_EXCEL_STANDARD_DAT

CALL FUNCTION 'EXCEL_OLE_STANDARD_DAT' 
 EXPORTING 
  file_name            = 'D:\MARA.XLSX' 
*  CREATE_PIVOT          = 0 
*  DATA_SHEET_NAME         = ' ' 
*  PIVOT_SHEET_NAME        = ' ' 
*  PASSWORD            = ' ' 
*  PASSWORD_OPTION         = 0 
 TABLES 
*  PIVOT_FIELD_TAB         = 
  data_tab            = t_mara 
  fieldnames           = t_fields.
* EXCEPTIONS 
*  FILE_NOT_EXIST         = 1 
*  FILENAME_EXPECTED        = 2 
*  COMMUNICATION_ERROR       = 3 
*  OLE_OBJECT_METHOD_ERROR     = 4 
*  OLE_OBJECT_PROPERTY_ERROR    = 5 
*  invalid_filename     = 6        "CHBAL0K051095
*  invalid_pivot_fields   = 7
*  download_problem     = 8
*  OTHERS          = 9

Regards,

Lalit Mohan GUpta.