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

Resolved Save As Excel formatting issues

  1. How-to
0
Votes
Undo
  1. Somit Bisoi
    Somit Bisoi
  2. PowerBuilder
  3. Wednesday, 13 December 2023 11:47 AM UTC

Hi Team,

I wanted to export data to excel file using the powerbuilder SaveAs feature. I can successfully save the datastore data to pdf with SaveAs pdf method, with all specific formats. but when i save the same data in excel, using SaveAs (type Excel),  the formatting of the excel data is not proper and it looks very clumsy. Could you please suggest how can i overcome this.

Thanks,

Somit

Don't want schema name while selecting table name ...
PowerServer Sql Connection
Responses (3)
ma jack
ma jack Accepted Answer Pending Moderation
  1. Wednesday, 13 December 2023 14:50 PM UTC
  2. PowerBuilder
  3. # 1

Another solution is to use an Excel template file, pre-set the table styles in advance, and then use OLE to fill in data into the cells. Alternatively, modify the table styles using OLE after the 'dw.saveas' operation.

Comment
There are no comments made yet.
John Fauss
John Fauss Accepted Answer Pending Moderation
  1. Wednesday, 13 December 2023 14:35 PM UTC
  2. PowerBuilder
  3. # 2

Hi, Somit -

Please look at the information in the following thread:

    https://community.appeon.com/index.php/qna/q-a/export-report-with-groups-using-saveas-xlxs

Best regards, John

Comment
There are no comments made yet.
René Ullrich
René Ullrich Accepted Answer Pending Moderation
  1. Wednesday, 13 December 2023 12:44 PM UTC
  2. PowerBuilder
  3. # 3

Hi Somit,

The Excel export is only a raw data export without formats.

You could try to use the external tool DW2XLS.

AFAIK Appeon plans formatted excel export in a later release.

Regards,

René

Comment
John Fauss
  1. John Fauss
  2. Wednesday, 13 December 2023 14:39 PM UTC
In September 2023, it was communicated in a related Q&A thread that the formatted Excel export enhancement has been, unfortunately, removed from the PB product roadmap:

https://community.appeon.com/index.php/qna/q-a/datawindow-excel?limitstart=0#reply-42332

  1. Helpful 1
René Ullrich
  1. René Ullrich
  2. Wednesday, 13 December 2023 14:47 PM UTC
In Bruce Armstrongs Blog about Elevate conference (https://community.appeon.com/index.php/blogs/recent-blogs/elevate-2023-review?ct=t%28Watch+Elevate+2022+Replay+Online_COPY_01%29&goal=0_47b6f83fed-8c6599e29a-%5BLIST_EMAIL_ID%5D) I found:

"WYSIWYG Export to Excel using display values"
  1. Helpful
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.