topic Re: Problem in uploading data through Excel file in Application Development and Automation Discussions

Problem in uploading data through Excel file

Former Member — Tue, 12 Jul 2011 07:11:53 GMT

Hello Experts,

Suppose I have a excel file that need to be uploaded into SAP System. There is a FM to upload excel file data into internal table, where we have to provide number of rows and cols . Now my question is that how to track my row no if the file is getting changed month by month.I mean some modification can be done into the excel file and monthly from same excel file data needs to be uploaded.Is it possible or should I maintain diff excel file for each month?

Thanks in adv.

A Miter.

Re: Problem in uploading data through Excel file

vallamuthu_madheswaran2 — Tue, 12 Jul 2011 10:06:00 GMT

HI,

Add one more flag column in the excel and the internal table based on that you can retrive,

can you explain where the data is stored in SAP. or give me your requirement clearly.

Thanks & Regards,

Vallamuthu Madheswaran

Re: Problem in uploading data through Excel file

Former Member — Tue, 12 Jul 2011 11:13:31 GMT

Hi ,

Thanks for reply. Suppose I have one excel file containing list of customers . But the number of customer may change month by month.That means number of row can be added into the file.My question is how to dynamically track the number of rows of that file, as because I have to provide the number of row and col into the FM.

Please suggest.

Thanks in adv.

A Miter.

Re: Problem in uploading data through Excel file

Former Member — Tue, 12 Jul 2011 11:52:46 GMT

Hi Arit,

It is possible in one excel sheet. You have declare the column and row position like below if your record starts in excel sheet with 1st column and 3rd row and you put for end column value 256 and end row value 65536. Keep in your mind that the excel format will not be changed i.e the start column and start row should be as it before position.

DATA : gd_scol TYPE i VALUE '1', "Start Column

gd_srow TYPE i VALUE '3', "Start Row

gd_ecol TYPE i VALUE '256', "End Column

gd_erow TYPE i VALUE '65536'. "End row

Thanks,

Sanjeeb

Re: Problem in uploading data through Excel file

Former Member — Tue, 12 Jul 2011 11:54:47 GMT

Hi Arit,

You can use the fm TEXT_CONVERT_XLS_TO_SAP, it will not ask the no. of rows.

Regards,

Karthik

Re: Problem in uploading data through Excel file

Former Member — Tue, 12 Jul 2011 12:57:29 GMT

Hello Sanjeeb ,

Thanks for reply.

I just wanted to know that suppose as on date the number of customer is arround 6000.Now if I give end row as 65536 then after populating my internal table , how many entries will be there? Is it upto 6000 or after 6000 record there will be blank entry till 65536.Please suggest.

Thanks in adv.

A Miter.

Re: Problem in uploading data through Excel file

Former Member — Wed, 13 Jul 2011 04:25:38 GMT

Hi Arit,

If you have 6000 customers record in Excel sheet, then 6000 entries will be there. It will not take any blank entry. That means how many records you have in your excel sheet these records will papulate.

I think it will be helpful to you.

Thanks,

Sanjeeb.