Subscribe via RSS
Toggle Submenu
  1. Categories
  2. Recent
  3. Tags
View Replies (3)

Resolved SaveAs Excel Headers

  1. How-to
0
Votes
Undo
  1. Roland Smith
    Roland Smith
  2. InfoMaker
  3. Tuesday, 17 September 2024 19:04 PM UTC

One of our customers is expecting that when saving a grid report to XLSX, the headers be what is in the header instead of the column name all lower case.

Is there a way around this in InfoMaker?

RichText field not displaying all information
Null columns export and position
Responses (3)
Roland Smith
Roland Smith Accepted Answer Pending Moderation
  1. Thursday, 19 September 2024 17:48 PM UTC
  2. InfoMaker
  3. # 1

I tried saving as HTML and then opening it in Excel. That works, although you have to turn grid lines on manually.

Comment
There are no comments made yet.
David Peace (Powersoft)
David Peace (Powersoft) Accepted Answer Pending Moderation
  1. Wednesday, 18 September 2024 15:16 PM UTC
  2. InfoMaker
  3. # 2

Hi Roland

Apart from changing the SQL query to be as near to their requirements there is not a lot you can do, it might be possible to Capitalise the Headings through a macro of something after the XLSX has been saved?

Good luck

David

Comment
There are no comments made yet.
Chris Pollach @Appeon
Chris Pollach @Appeon Accepted Answer Pending Moderation
  1. Tuesday, 17 September 2024 19:49 PM UTC
  2. InfoMaker
  3. # 3

Hi Roland;

  This is easy to do of course in PB as the PB App can share the current DWO buffer with a DataStore that has a duplicate DWO it it where the headers are customized to accomplish what the IM user wants. Of course, IM does not have this capability.

   Suggestion: What about creating a small PB App that runs the IM report (aka DWO) and performs the above task for the IM user reporting wise over to Excel?

Regards .. Chris

Comment
There are no comments made yet.
  • Page :
  • 1


There are no replies made for this question yet.
However, you are not allowed to reply to this question.
We use cookies which are necessary for the proper functioning of our websites. We also use cookies to analyze our traffic, improve your experience and provide social media features. If you continue to use this site, you consent to our use of cookies.