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

Resolved OLE Automation to Excel

  1. Advice
0
Votes
Undo
  1. Peter Currier
    Peter Currier
  2. PowerBuilder
  3. Friday, 28 August 2020 15:40 PM UTC

Hi All,

We have several PB2017 applications that do extensive OLE automation to create formatted Excel reports.  The formatting that we do is anything from basic column formatting (numeric and date) up to creating multi-tabbed workbooks with Auto Filtering and Subtotal functions in specific cells.   This OLE logic is not going to work in click-to-run versions of Office.  I'm looking for advice on alternatives to using OLE Automation when generating these sophisticated Excel outputs.   

Thanks.

Peter

  1. OLE
Resizable response: how to show gripper in right b...
Runtime Files question
Responses (2)
mike S
mike S Accepted Answer Pending Moderation
  1. Wednesday, 2 September 2020 15:49 PM UTC
  2. PowerBuilder
  3. # 1

there is the graph api for office 365 applications:

https://docs.microsoft.com/en-us/graph/api/resources/excel?view=graph-rest-1.0

Comment
There are no comments made yet.
Chris Pollach @Appeon
Chris Pollach @Appeon Accepted Answer Pending Moderation
  1. Wednesday, 2 September 2020 14:59 PM UTC
  2. PowerBuilder
  3. # 2

Hi Peter;

   For those type PB App's that use OLE, you sould probably recommend to the application users that they use the Office365 "Windows Installer" edition that includes OLE compatibility. I would think that most IT shops may go this route anyways as various commercial Apps out there use MS-Office OLE functionality - not just PB. My $0.02.

Regards .... Chris

Comment
Peter Currier
  1. Peter Currier
  2. Wednesday, 2 September 2020 19:00 PM UTC
Thanks for the info, Chris. I'm still trying to gather information at this point, but I'm reading that Office365 is only offered as Click To Run and that Office 2016 was the last version of Office to offer an MSI version. I'm also reading that the Office Interop assembly is available on Click To Run versions so that may be an option. Does that make sense? Peter
  1. Helpful
Chris Pollach @Appeon
  1. Chris Pollach @Appeon
  2. Wednesday, 2 September 2020 19:40 PM UTC
Yep ... just need to test that aspect! ;-)
  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.
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.