topic Re: Export to Excel-Date missing in Application Development and Automation Discussions

Export to Excel-Date missing

Former Member — Wed, 07 Jan 2015 06:57:19 GMT

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

Re: Export to Excel-Date missing

Former Member — Thu, 08 Jan 2015 12:59:48 GMT

Any suggestion please.

Re: Export to Excel-Date missing

Former Member — Thu, 08 Jan 2015 13:05:48 GMT

may be your SAP system is upgraded and if so then you have to search a note for that upgrade

Re: Export to Excel-Date missing

former_member207661 — Thu, 08 Jan 2015 13:22:50 GMT

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

Re: Export to Excel-Date missing

Former Member — Sun, 11 Jan 2015 11:35:58 GMT

Hi Shyam,

If you export the ALV to excel then by default you will get the date and the text "Dynamic list display".

Currently I am not getting the date and the time.

So any suggestion.

Regards,

Munu

Re: Export to Excel-Date missing

vinodkumar_thangavel — Mon, 12 Jan 2015 03:56:44 GMT

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.

Re: Export to Excel-Date missing

Former Member — Mon, 12 Jan 2015 04:23:53 GMT

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.

Re: Export to Excel-Date missing

Former Member — Mon, 12 Jan 2015 14:58:57 GMT

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

Re: Export to Excel-Date missing

Former Member — Tue, 13 Jan 2015 05:59:13 GMT

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

Re: Export to Excel-Date missing

Former Member — Tue, 13 Jan 2015 06:01:51 GMT

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

Re: Export to Excel-Date missing

former_member207661 — Tue, 13 Jan 2015 08:41:52 GMT

Can you please tell what is current SAP version of your system?

Re: Export to Excel-Date missing

Former Member — Mon, 04 May 2015 08:16:46 GMT

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.

Re: Export to Excel-Date missing

former_member380133 — Fri, 16 Oct 2015 06:41:43 GMT

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