Discussions tagged Excel
Windows Forms/WPF (need to view xlsx files without having Excel installed)
- How-to
- Last updated 1 week ago
- Aron Cox replied 21 hours ago
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...
Why save as xlsx cannot work for PB2022 on WIN2016 server
- Issue
- Last updated 2 weeks ago
- Roland Smith replied 2 weeks ago
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 ...
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...
High volume text or excel file import in powerserver
- How-to
- Last updated 3 months ago
- Miguel Leeuwe replied 3 months ago
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...
Create graphs in an Excel file from PowerBuilder
- How-to
- Last updated 11 months ago
- Mark Goldsmith replied 11 months ago
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 ...
DDEPoke from Excel client doesn't trigger remotesend event
- Resolved
- How-to
- Last updated 11 months ago
- Tracy Lamb replied 11 months ago
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...
Remove datawindow title bar but not the column headings
- Issue
- Last updated 11 months ago
- John Fauss replied 11 months ago
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
- Last updated 11 months ago
- John Fauss replied 11 months ago
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...
How to specify the font when save datawindow to excel file
- Resolved
- How-to
- Last updated 11 months ago
- Chris Pollach @Appeon replied 11 months ago
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...
DataWindow saveas excel8, sheet name is garble code
- Resolved
- How-to
- Last updated 1 year ago
- Kai Zhao @Appeon replied 1 year ago
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...
Remove Oleobject dependency on MS Office install
- Advice
- Last updated 1 year ago
- Miguel Leeuwe replied 1 year ago
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
- Last updated 1 year ago
- Paul Weir replied 1 year ago
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...
How to change the delimiter from comma to other special character using powerbuilder
- Resolved
- Issue
- Last updated 2 years ago
- Hannu Pikkarainen replied 1 year ago
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...
Excel, OLE, Error in Copying multiple sheets into an excel. Wrong sheet was copied.
- Issue
- Last updated 3 years ago
- John Fauss replied 3 years ago
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 ...
SAVEAS XLSX! file is unreadable by Excel
- How-to
- Last updated 3 years ago
- Gordon Weil replied 3 years ago
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...
How call VBA macros und functions written yourself?
- Resolved
- How-to
- Last updated 3 years ago
- Konrad Kaltenbach replied 3 years ago
Dear Experts,
I want to call VisualBasic for Application (VBA) macros and functions in Word or Excel documents which I have written myself out of/from PowerScript functions (instead of rewritting them in the PowerScript functions).
Is this possible...
How calling VBA Excel functions with optional arguments?
- Resolved
- How-to
- Last updated 3 years ago
- Konrad Kaltenbach replied 2 years ago
Dear Experts,
I want to call the VBA Excel functions with optional parameters like Range.PasteSpecial(...) for example in PowerScript functions.
I tried the following:
OLEObject lole_WS_From // Excel worksheetOLEObject lole_WS_To // Excel works...
- Page :
- 1