SAP Excel program reading only two sheet

former_member191728 — Mon, 13 Jul 2015 14:28:35 GMT

Hi Experts

I have created a excel program to read data from Excel multiple sheets

I was able to read the data earlier from multiple sheet but now I am getting a strange problem

Only two sheet are always read

Even though I am passing the third sheet name only 2nd sheet data is being fetched

The other problem is If I open the excel file ,opened third worksheet and closed it.

The program starts reading the data from 3rd worksheet but not from worksheet 1

Can you please provide the solution for this or what I am missing here when working with excel

Please find the code what I have written to read the data from multiple sheets and correct me if I am doing anything wrong

LOOP AT i_sheets INTO wa_sheets.

lw_range-name = 'Test'.

lw_range-rows = p_rows.

lw_range-columns = p_cols.

APPEND lw_range TO lt_range.

CALL METHOD iref_spreadsheet->select_sheet

EXPORTING

name = wa_sheets-sheet_name

* no_flush = ' '

IMPORTING

error = iref_error

* retcode =

IF iref_error->has_failed = 'X'.

EXIT.

ENDIF.

CALL METHOD iref_spreadsheet->set_selection

EXPORTING

top = 1

left = 1

rows = p_rows

columns = p_cols.

CALL METHOD iref_spreadsheet->insert_range

EXPORTING

name = 'Test'

rows = p_rows

columns = p_cols

no_flush = ''

IMPORTING

error = iref_error.

IF iref_error->has_failed = 'X'.

EXIT.

ENDIF.

REFRESH i_data.

CALL METHOD iref_spreadsheet->get_ranges_data

* EXPORTING

* all = 'X'

IMPORTING

contents = i_data

error = iref_error

CHANGING

ranges = lt_range.

CALL METHOD iref_spreadsheet->delete_ranges

EXPORTING

ranges = lt_range.

endloop.

is there any special procedure we need to follow while saving the excel which I am using for the program

Thanks

Pawan Akella

Re: SAP Excel program reading only two sheet

roberto_vacca2 — Mon, 13 Jul 2015 15:22:40 GMT

Hi.

Your instructions are formally correct. Did you try to change Range-Name at each loop? Excel could go crazy for the same Range Reference..

Hope to help,

Bye

Re: SAP Excel program reading only two sheet

former_member191728 — Mon, 13 Jul 2015 19:22:08 GMT

Hi Roberto

Thanks for the suggestion but unfortunately it didn't work

Thanks

Pawan Akella

Re: SAP Excel program reading only two sheet

Former Member — Fri, 15 Jul 2016 07:33:58 GMT

Hi Pavan,

Did the issue got resolved. I am also facing similar issue in my project.

kindly suggest on how you resolved this issue.

Regards

Pallavi

topic Re: SAP Excel program reading only two sheet in Application Development and Automation Discussions

SAP Excel program reading only two sheet

Re: SAP Excel program reading only two sheet

Re: SAP Excel program reading only two sheet

Re: SAP Excel program reading only two sheet