topic Re: Reading spool data into excel in Application Development and Automation Discussions

Reading spool data into excel

Former Member — Tue, 14 Apr 2009 18:52:16 GMT

Hi all

while downloadng spool data into excel...

in my spool table i have 60500 records.here i am skipping first 3 records (some junk text)which i don't need in output excel,by adding sy-tabix >3 condition.with this am gettngs 59999 records in one page correctly.

when its turn to 60000 reocord which should be displayed in second page.here problem is in second page am getting those 3 records which i skipped initially as 60000th n so onrecords.i don't want to display those 3 records again here.can any one explain me how to do?

Re: Reading spool data into excel

former_member194669 — Tue, 14 Apr 2009 19:57:23 GMT

I think you are using fm to read the spool , then


      call function 'RSPO_RETURN_ABAP_SPOOLJOB'
        exporting
          rqident              = wa_spool
          first_line           = 4   " Give the value here to skip top lines on each page
        tables
          buffer               = i_spldata
        exceptions
          no_such_job          = 1
          not_abap_list        = 2
          job_contains_no_data = 3
          selection_empty      = 4
          no_permission        = 5
          can_not_access       = 6
          read_error           = 7
          others               = 8.

a®

Re: Reading spool data into excel

Former Member — Wed, 15 Apr 2009 09:32:15 GMT

yes, let me try with this FM..am already using but not passing the parameter ' FIRST LINE'.

thank you..

Edited by: sunny on Apr 15, 2009 11:33 AM

Re: Reading spool data into excel

former_member203501 — Wed, 15 Apr 2009 09:41:46 GMT

hi try this ...may be helpful for you ...

Re: Reading spool data into excel

Former Member — Wed, 15 Apr 2009 11:26:26 GMT

Hi a@s,

call function 'RSPO_RETURN_ABAP_SPOOLJOB'

exporting

rqident = wa_spool

first_line = 4 " Give the value here to skip top lines on each page

tables

buffer = i_spldata

exceptions

no_such_job = 1

not_abap_list = 2

job_contains_no_data = 3

selection_empty = 4

no_permission = 5

can_not_access = 6

read_error = 7

others = 8.

This one working for only first page...in the same way i want to skip lines for 2nd page n 3rd page..how to do..can u suggest me..

thank u..

Re: Reading spool data into excel

Former Member — Wed, 15 Apr 2009 11:42:57 GMT

Hi Sunny,

How you solved your problem. I am also having the same type of requirement

Re: Reading spool data into excel

Former Member — Wed, 15 Apr 2009 12:13:28 GMT

Not at solved..Don't know how to solve this..still trying..

Re: Reading spool data into excel

former_member194669 — Wed, 15 Apr 2009 14:43:49 GMT

This may be a roundway solution.

While creating the spool keep the line to the maximum by


    call function 'GET_PRINT_PARAMETERS'
      exporting
        destination            = 'LOCL'
        immediately            = space
        new_list_id            = 'X'
        no_dialog              = 'X'
        user                   = sy-uname
      importing
        out_parameters         = wa_params
        valid                  = v_valid
      exceptions
        archive_info_not_found = 1
        invalid_print_params   = 2
        invalid_archive_params = 3
        others                 = 4.

    wa_params-linct = 1000000.   "<<<<  Keep this to maximum number of lines in 
    wa_params-paart = ' '.

then use


call function 'RSPO_RETURN_ABAP_SPOOLJOB'
        exporting
          rqident              = wa_spool
          first_line           = 4   " Give the value here to skip top lines on each page
        tables
          buffer               = i_spldata
        exceptions
          no_such_job          = 1
          not_abap_list        = 2
          job_contains_no_data = 3
          selection_empty      = 4
          no_permission        = 5
          can_not_access       = 6
          read_error           = 7
          others               = 8.

So in the Spool Heading part will come ONLY in the first page.

a®

Re: Reading spool data into excel

naimesh_patel — Wed, 15 Apr 2009 15:12:07 GMT

You must be having something in your TOP-OF-PAGE which can distinguish between your TOP-OF-PAGE and your actual data. You can read the spool as suggested by aRs and then deletes the header generated from TOP-OF-PAGE.

Program to generate the Spool


REPORT  ztest_np_1 LINE-COUNT 10 NO STANDARD PAGE HEADING.

start-of-selection.
 do 55 times.
   write: / sy-abcde.
 enddo.

top-of-page.
  write: / 'Top'.
  write: / 'Something'.

Read the spool and deletes header


DATA: lf_spool TYPE tsp01-rqident.

DATA: lt_buffer TYPE STANDARD TABLE OF txmisporow.

lf_spool = <spool>

CALL FUNCTION 'RSPO_RETURN_ABAP_SPOOLJOB'
  EXPORTING
    rqident              = lf_spool
    first_line           = 2
  TABLES
    buffer               = lt_buffer
  EXCEPTIONS
    no_such_job          = 1
    not_abap_list        = 2
    job_contains_no_data = 3
    selection_empty      = 4
    no_permission        = 5
    can_not_access       = 6
    read_error           = 7
    OTHERS               = 8.
IF sy-subrc <> 0.
  MESSAGE ID sy-msgid TYPE sy-msgty NUMBER sy-msgno
          WITH sy-msgv1 sy-msgv2 sy-msgv3 sy-msgv4.
ENDIF.

DATA: la_buffer LIKE LINE OF lt_buffer.
LOOP AT lt_buffer INTO la_buffer WHERE ( line+0(3) = 'Top' or line = 'Something' ).
  DELETE lt_buffer.
ENDLOOP.

Regards,

Naimesh Patel

Re: Reading spool data into excel

Former Member — Fri, 31 Jul 2009 14:36:32 GMT

yes..