Skip to Content
avatar image
Former Member

Export to Excel-Date missing

Hi All,

While exporting the data from ALV output.

Code level nothing is being changed.

Previosly while exporting to excel, in the generated excel data and the  date used to come on the left top.

Now i am getting the data alone, missing the date.

I searched in SCN but couldnot get any solution.

PFA old and new screen shots.

I have highlighted the the date in Yellow mark.

Our system get upgraded recently. Is this related.

Please suggest.

Regards,

Munu

new_xls.PNG (2.2 kB)
old_xls.PNG (5.3 kB)
Add comment
10|10000 characters needed characters exceeded

  • Get RSS Feed

7 Answers

  • avatar image
    Former Member
    Jan 08, 2015 at 12:59 PM

    Any suggestion please.

    Add comment
    10|10000 characters needed characters exceeded

  • Jan 08, 2015 at 01:22 PM

    Hi Munu,

    Can you provide below information:

    1) What statement is used to print date?

    2) Upgrade is done from what to what version?

    Warm Regards,

    Shyam Agrawal

    Add comment
    10|10000 characters needed characters exceeded

  • avatar image
    Former Member
    Jan 12, 2015 at 03:56 AM

    Hi ,

    Check whether the date format that u are using in the Excel and the system date format are same if they are different then this kind of issue may occur.

    Regards,

    Vinodkumar.

    Add comment
    10|10000 characters needed characters exceeded

  • avatar image
    Former Member
    Jan 12, 2015 at 04:23 AM

    Hi Munu,

    Good day,

    Enter &reset_excel into the command line (for ABAP Lists only) to reset the default Excel File Format and try to export.

    Hope it may be helpful and let me know if any issues.

    Thanks & Regards,

    Seshadri.

    Add comment
    10|10000 characters needed characters exceeded

    • Former Member

      Hi Seshadri,

      I ma using ALV grid diplay.

      And the output is coming as well.

      But during exporting the date and the text  'Dynamic List Display' in the file is missing which used to come by default.

      Try exporting to Ecxel from ALV and you will get my issue.

      Thanks,

      Munu

  • avatar image
    Former Member
    Jan 12, 2015 at 02:58 PM

    When you press the Excel button, there will be a popup that lets you select different formats. Press F1 on one of the fields to help you decide which format to use.

    Rob

    Add comment
    10|10000 characters needed characters exceeded

    • Former Member

      Hi Rob,

      I used to select the Export then the Spreadsheet.

      The thing is that the date and text 'Dynamic List Display' in the file is missing.

      So any suggetsion.

      Thanks,

      Munu

  • avatar image
    Former Member
    May 04, 2015 at 08:16 AM

    Hi Manu,

    Did you manage to find the solution?

    After SP upgrade we are facing with the same issue. Dynamic list display with the date and time is missing in excel files.

    Thanks,

    Bojan.

    Add comment
    10|10000 characters needed characters exceeded

  • Oct 16, 2015 at 06:41 AM

    Dear Manu,


    This line was disabled with the note correction 1912127, you can reenable this line with the implementation of the note 2090822.

    Br,

    Gyorgy

    Add comment
    10|10000 characters needed characters exceeded