1. Marcelo Edinger
  2. PowerBuilder
  3. Thursday, 16 November 2023 13:23 PM UTC

Hi Appeon

My name is Marcelo, I work with systems development using Appeon PowerBuilder.
I have an application that uses Excel generation by an Active x DLL.
I currently use a dll for this, OLE XLSFile v4.0 ( olexlsf.dll ).
The great advantage of using this DLL is its Excel generation speed, it is very fast.

But this DLL is old and does not support the new Excel formats (xlsx) and it also doesn't have several functions that I currently need, for exemple:  grouping cells or columns, recalculating formulas, generate excel with more than 256 columns, generate excel with more than 65,536 lines.
Using this DLL it is not necessary to install Microsoft Excel on the computer.

I researched several companies that have components that generate Excel, but none of them have support for PowerBuilder or Active X.

I don't use programming via OLE format because it becomes very slow as the file is generated.

Would Appeon have any suggestions for generating Excel?
It does not need to be a free object/component, if applicable, our company will purchase the object/component.

Thanks,
Marcelo Edinger
+55(51)99163-5079

mike S Accepted Answer Pending Moderation
  1. Thursday, 16 November 2023 15:20 PM UTC
  2. PowerBuilder
  3. # 1

Starting in PB 2019 (r2?), you can use .net libraries in powerbuilder.

Calling .NET Assembly - - What's New (appeon.com)

 

do a search for .net excel library

 

 

 

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.