Discussions tagged Excel
Hello,After migration to PB 2022 R3 Build 3391 there is an issue with XLS files generated.When I mark few columns/rows, it looks like copy / paste isn't working. Choosing specific cell, and copying this cell only - works, but larger range not copying...
Hola buenas,A ver si alguien me puede ayudar con esto. No puedo realizar la apertura de un excel, para hacer una importacin de dicho documento:
OLEObject lnvo_excel
n_cst_datetime lnv_retardo
lnvo_excel = create OLEObject
// Se reali...
Hey everyone,
is here a way to invoke Windows Forms or WPS ui as part of a PB 2022R3 application ?My need is to use an Excel Control to be able to view Excel files without having Excel installed.
Thanks
//Steen...
Dear Appeon:
We tried the Powerbuilder 2022 R3, and try to use the datawindow saveas function to save data into excel file. we noticed that xlsx format are also supported in the PB2022, but unfortunately, the compiled application works well ...
Pdf to Excel
- How-to
Hi,
does anyone out there know how to convert a pdf to excel or csv / text programmatically, or using an command line converter.
I am using the latest verison of PB on windows 10
I have a requirement to be able to check a pdf document listing tran...
Hello all,
We're working on a project that will open Excel, call a stored procedure, create a chart, print as a pdf then close.Using PB2022R2 Build 2828.
Thanks to Tobias we have a very nice OLE example that does everything we need, except the abil...
We have existing processes to export something to excel using OLE and Excel VBA commands, which do their job, and then exit. We have a call at the end to an external function EndTask to kill the excel.exe process for these.
We're developing a new pr...
Hi Team,
What is the best method to import high volume text or excel file. For example having column 20 and no of line 50000
We have tried using datawindow import and reading 100 line each loop till we get datawindow import error, but this wo...
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...
Is it possible to draw graphs in an Excel file from PowerBuilder? I create tables with data in Excel from PowerBuilder, but how can I build charts or pies based on this data? I saw that classes ExcelPieChart, ExcelBarChart, enum eChartType in C# are ...
Hi all,
My application registers with Windows as a DDE Server, and communicates with several different 3rd party apps through DDE. We're just now exploring how to communicate via Excel by the same means.
In Excel, I put a button on the worksheet t...
Is there a function in datawindow that I can use to remove header (title and other objects) but leave the column headers intact? I tried adjusting header height but it leave the space from the top not the bottom of the header bar. I need to change ...
Excel OLE: How do I reference a sheet by name?
- Resolved
- How-to
Hi all,
I'm trying to import data from an Excel workbook using an OLE object. The algorithm works great, but I have hard-coded the WorkSheet number. How can I refernce the sheet by name instead of number? I specifically want to find the sheet nam...
Hello everyoneI use the saveas method such as dw_1.saveas("test.xlsx",xlsx!,true) to save datawindow into an excel file. The font of all cells in the excel file is Arial and the size is 10.
I try to modify the column font and size in datawindow , bu...
Hello everyone
I saved the data window as an excel file. The name of the excel file is displayed normally, but the sheet name is garble code.this is my codedw_1.saveas("D:\test\作成.xls",excel8!,true)
If I use ascii characters as the file name, the s...
We have application that saves reports to Excel file using Oleobject and does data formatting after file is saved. This stopped working after MS Office was uninstalled form Citrix server due to company new policy. The file does get saved but erro...
Save Rows As Excel 12 Crashes InfoMaker
- Resolved
- Issue
I open InfoMaker 2019 Build 2083.
I then run a report and click File Save Rows As.
I then choose Excel12(*.xlsx) with headers as the Save as type, and then click Save.
InfoMaker then crashes.
But InfoMaker does not cra...
Hello Team,
I am using PowerBuilder 2019 in my application. The application has an option to save the files as .csv(Comma Separated Value File Type). Our Client wants to change the delimiter from 'comma' to some other special character. Tried to cha...
Hi All,
My program is generating reports in excel format which contains 8 sheets. It is batch program to pick up the request from the queue, generate the reports, and send them to the user. And 4 sessions are running at the same time to process the ...
I have an application that creates a number of reports and saves them as Excel files with the XLSX! save as type and file extension.xlsx. All the reports open in Excel 2016 except one. The one exception can be saved with the EXCEL! SaveAs type and it...
Find Questions by Tag
.EXE
.NET 6.0
.NET Assembly
.NET Core 3.1
.NET Core Framework
.NET DataStore
.NET Std Framework
32-bit
64-bit
ADO.NET
AEM
AI
Algorithm
Amazon AWS
Android
Apache
API
APK
App Store
App Store (Apple)
Appeon Workspace
Appeon Xcelerator Plug-in
Architecture
Array
ASE
Asynchronous Methods
Authentication
AutoBuild
AutoCompiler
Automated Testing
Automation
AutoScript
Azure
Barcode
Base64
Batch
BigData
BLOB
Branch & Merge
Browser
Bug
Build
Button
C#
C# Class Importer
C# Editor
C# Model generator
Calendar
Camera
Certificate
Chrome
Citrix
Class
Client
Client/Server
Cloud
Cluster
Collection
COM
Command Line
Compiler
Compression
Computed Field
Configuration
Controls
Cookies
Cordova
Crash
Cross-Platform
Crosstab
CSharpAssembly
CSharpObject
CSS
CSV
Cursor
Data
Database
Database Driver
Database Painter
Database Profile
Database Provider
DataObject
DataSource
DataStore
DataStore (C#)
DataStore (PS)
DataType
DataWindow
DATE
DATETIME
DB2
Debug
Debugger
Debugging
Deployment
Design
DLL
DO-WHILE
Dockable
Docker
Documentation
DOUBLE
Download
DragDrop
Edge
Edit Style
Editor
Elevate Conference
Email
Embedded SQL
Emulator
Encoding
Encryption
Enhancement Request
Entity
Entity Framework
ERP
Error
Event
Event Handler
Event Handling
Excel
Exception
Export
Expression
External Functions
F#
Field
File
File Access
Filter
Firefox
Firewall
Font
FOR-NEXT
Foreground
Format
Function
Garbage Collection
GeoLocation
Git
Graph
HANA
Hash
Header
HTML/5
HTTP/S
HTTPClient
Icon
IDE
Identity
IIS
IMAPI
Import
InfoMaker
Inheritance
Installation
Integer
IntelliSense
Interface
Internet
Internet Explorer
iOS
IPA
iPad
iPhone
IWA
J#
Java
JavaScript
JBoss
JDBC
JOIN
JSON
JSONGenerator
JSONParser
Kestrel
Label
Lambda
Large File
LDAP
Library
License
LINQ
Linux OS
Load Balancing
Localization
Localized PBVM
Log In
Log Out
Logging
LONG
LONGLONG
macOS
MAPI
Maps
MDI
Memory
Memory Leak
Menu
Merge
MessageBox
Messagging
Method
Migration
MIME TYPE
Mobile
Model
ModelStore
ModelStore (C#)
MSOLEDBSQL
Multi Threading
MVC
MySQL
n-Tier
Namespace
NativePDF
NVO
OAuth
ODATA
ODBC
Office
Offline
OLE
OLEDB
Online
Open Source
OpenAPI
OpenSSL
Oracle
OrcaScript
Other
Outlook
Output
Package
Parameter
Patch
PayPal
PB Classic
PB Native
PB.NET
PBC
PBD
PBDOM
PBG
PBJVM
PBL
PBNI
PBORCA
PBVM
PBX
PDF
Performance
Permission
PFC
Picture
Pipeline
Play Store (Google)
Plugin
Popup
Port
POST
PostgreSQL
PowerBuilder
PowerBuilder (Appeon)
PowerBuilder (SAP)
PowerBuilder Compiler
PowerBuilder Runtime
PowerClient
PowerScript (PS)
PowerScript IDE
PowerScript Migrator
PowerServer
PowerServer Mobile
PowerServer Toolkit
PowerServer Web
PowerServerLabel
Print
Properties
Proxy
Publish
PULL
PUSH
Query
Regression
Release
Renew
Resize
Response
REST
Retrieve
RibbonBar
RibbonBar Builder
Rich Text
Roadmap
RPC
Runtime Packager
SaaS
Scaffolding
Script
SDI
SDK
Security
Server
Service
Session
Single Sign-on
Size
SMTP
SMTPClient
SnapDevelop
SOAP
Sort
Source Code
Speech Recognition
SQL
SQL Anywhere
SQL Server
SqlBuilder
SqlExecutor
SQLite
SqlModelMapper
Storage
Stored Procedure
Subscription
SVN
Swagger
Syntax
TabbedBar
TabbedView
Tablet
TabPage
Target
TE Control
Testing
Text
TFS
Theme
TIME
Timer
TLS/SSL
Tomcat
TortoiseGit
TortoiseSVN
Transaction
Transparency
Trial
Trigger
TRY-CATCH
TX Control
Type
UI
ULONG
UltraLite
Uninstall
Unit Test
Unit Testing
UNIX OS
Update
Upgrade
Upload
URL
User Center
User Object
UWP
Validation
VARCHAR
Variable
Versioning
Visual Studio
Visual Studio Code
VM
Voice
Warning
WCF
Web API
Web Extensions
Web Service
WebBrowser
WebForms
WebLogic
WebSphere
WildFly
WinAPI
Window
Windows OS
WinForms
Wizard
Workgroup
Workspace
WPF
XCODE
XHTML
XML
Zoom