1. Dennis Huynh
  2. PowerBuilder
  3. Wednesday, 5 December 2018 17:47 PM UTC

Hello All,

We recently migrated PB 12.5 app to PB 2017 R2 and things went well.  One thing that we've noticed that the columns on Excel 2013 maximized after data have been saved from the following script:

             ldw_focus.SaveAs("", XLSX! , TRUE)

Would there be a way not to have the columns on Excel maximized?

Thanks and Regards,

Dennis

 

Dennis Huynh Accepted Answer Pending Moderation
  1. Friday, 7 December 2018 15:38 PM UTC
  2. PowerBuilder
  3. # 1

Juan,

Your input is very informative.

Thanks!

Dennis

Comment
There are no comments made yet.
Juan Alejandro Lam López Accepted Answer Pending Moderation
  1. Friday, 7 December 2018 14:34 PM UTC
  2. PowerBuilder
  3. # 2

Hello,

I am currently working with the PB 2017 R3 version and I would like to tell you that the SaveAs is going to save the information as it is brought from the database, this implies that you will not save it in the format you designed the datawindow nor the groupings or calculated fields. If you want to save your datawindo as it is seen you can use this tool that you find in the following link http://desta.com.ua/dw2xls/

 

Regards

 

Juan Alejandro Lam

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.