• ** There has been a recent site upgrade. Please clear your browser cache to avoid issues. **
  • New forum feature - post voting and best solution

    Check out this thread for the details: https://www.access-programmers.co.uk/forums/threads/new-forum-feature-post-voting-and-best-answer.314134/

    This new feature looks great to me! :)

  • We now have 3 forum themes

    Go for the default (light) theme, Shades of Grey or Shades of Blue. I just added the Blue one.

    The thread about it is here: https://www.access-programmers.co.uk/forums/threads/new-forum-theme-shades-of-blue.314136/

question: can you export a report to excel with all the same formatting and colors? (1 Viewer)

Db-why-not

Registered User.
Local time
Today, 04:51
Joined
Sep 17, 2019
Messages
118
I haven't tried exporting access reports to excel before but when you export it can you export it with all its formatting and colors so it looks the same?
If so how?
 

theDBguy

I’m here to help
Staff member
Local time
Today, 02:51
Joined
Oct 29, 2018
Messages
12,440
Hi. It might get close, but not all the way (depending on your report design). By the way, you can only export reports to XLS format.
 

plog

Banishment Pending
Local time
Today, 04:51
Joined
May 11, 2011
Messages
10,058
No, and why?

If you ultimately want to print it out you can go to Rich Text (.rtf) or possibly HTML (.htm) which would better preserve the formatting but still won't be perfect. If you want to analyze the data with Excel, then formatting and coloring shouldn't be important and you should just dump the data. Also, there are .pdf plugins which will send the report to an .pdf file which retain most if not all the formatting.
 

Pat Hartman

Super Moderator
Staff member
Local time
Today, 05:51
Joined
Feb 19, 2002
Messages
29,705
I don't think the export report to Excel exists or if it does, it does a poor job. When I want to export to Excel, I create an Excel template that does all the necessary formatting and then open it and fill it with data and run a formatting macro if necessary.
 

The_Doc_Man

Immoderate Moderator, Former MVP, Retired SysAdmin
Staff member
Local time
Today, 04:51
Joined
Feb 28, 2001
Messages
17,964
The problem with exporting to Excel is that using the pre-defined method, you don't have the same color palette. (At least, not automatically.) Excel uses a 64-color palette even though it is possible to use the full 24-bit (16-million) color specifications. The automatic export features probably won't use quite that variety of colors, and the formatting might be susceptible to formatting conversions. Exporting the elements via an Excel Application Object would give you absolute control over format and content but would be incredibly tedious to manage.
 

isladogs

CID VIP
Local time
Today, 10:51
Joined
Jan 14, 2017
Messages
13,929
You could try adding colour to the query containing your report data and exporting that.
.
However, the formatting available in queries may not be sufficient for your needs
 

Users who are viewing this thread

Top Bottom