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

Resolved SaveAs Excel

  1. How-to
0
Votes
Undo
  1. Somit Bisoi
    Somit Bisoi
  2. PowerBuilder
  3. Thursday, 4 January 2024 06:25 AM UTC

Hi,


i have a specific datawindow with data shown in specific format in powerbuilder. i want to export the entire content to Excel in the same format including the exact look and feel that displays in the tool. i implemented using dw_sheet.Saveas(s_export_path + "Sample.XLS", HTMLTable!, TRUE), but the format is not the same what it actually displays in the tool. it adds extra spaces and line in between. Can someone help how can we overcome this. i check almost all the saveas type formats but still no luck. any trick would be really helpful.

Thank you,

Somit

  1. PowerBuilder
expert in powerbuilder
Passing message to PowerBuilder application
Responses (3)
Miguel Leeuwe
Miguel Leeuwe Accepted Answer Pending Moderation
  1. Friday, 5 January 2024 13:11 PM UTC
  2. PowerBuilder
  3. # 1

Have a look at https://community.appeon.com/index.php/qna/q-a/saveas-excel. It's not the fastest solution, nor perfect, but maybe it could serve your purpose. I've tested it one day and it was pretty nice, though not as good as dw2xls from Desta.

No guarantees, but here's another possible solution? https://github.com/2ruslan/wrx I've never used it myself and it's pretty old, but who knows if it might solve your problem.

 

 

Comment
There are no comments made yet.
Miguel Leeuwe
Miguel Leeuwe Accepted Answer Pending Moderation
  1. Thursday, 4 January 2024 14:34 PM UTC
  2. PowerBuilder
  3. # 2

As Chris suggested, also do a search on the Desta library "dw2xls" on this Q&A forum: https://community.appeon.com/index.php/qna/q-a/search/ZHcyeGxz 

Comment
There are no comments made yet.
Chris Pollach @Appeon
Chris Pollach @Appeon Accepted Answer Pending Moderation
  1. Thursday, 4 January 2024 13:11 PM UTC
  2. PowerBuilder
  3. # 3

Hi Somit;

   The SaveAs(PDF!) only exports the raw data and not the formatted data. To preserve the formatting, you would need to use a 3rd party product like DW2XLS.

http://desta.com.ua/dw2xls

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.