Discussions tagged Excel
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 4 months ago
- Mark Goldsmith replied 4 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 4 months ago
- Tracy Lamb replied 4 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 4 months ago
- John Fauss replied 4 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 5 months ago
- John Fauss replied 5 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 5 months ago
- Chris Pollach @Appeon replied 5 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 5 months ago
- Kai Zhao @Appeon replied 6 months 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 8 months ago
- Miguel Leeuwe replied 8 months 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 9 months ago
- Paul Weir replied 8 months 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 1 year ago
- Hannu Pikkarainen replied 5 months 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 2 years ago
- John Fauss replied 2 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 2 years ago
- Gordon Weil replied 2 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 2 years ago
- Konrad Kaltenbach replied 2 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 2 years ago
- Konrad Kaltenbach replied 1 year 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...
CROSSTAB TO XLSX Export Issue
- Issue
- Last updated 3 years ago
- Danish Ahamed LiakathAli replied 3 years ago
Hi,
We have migrated from 10.2 to 2019 R2 and We have added a new '.XLSX' extension in our existing SaveAs option.
We are able to export the all datawindows with this extension expect the reports that has designed using crosstab datawindow.
...
Datawindow SaveAs Excel without MS Office installed
- Resolved
- How-to
- Last updated 3 years ago
- René Ullrich replied 3 years ago
Hello,
I have a requirement to check feasibility of saving a datawindow report to '.xlsx' format using an executable built in PowerBuilder 2017 R3. The constraint is that the host machine on which the executable will be running will not have any ...
datawindow SaveAs XLSX! with column that has more than 32767 characters
- Issue
- Last updated 3 years ago
- Olan Knight replied 3 years ago
Hello,
In PB2017R3 when you do dw.SaveAs XLSX! an there is a cell with more than 32767 characters (character size limit of Ecel's cell) - resulting .xlsx file will consider this cell unreadable in MicroSoft Excel. At the same time Open Office just t...
We have recently changed our datawindow savas methods to XLSX! from Excel8!
This works fine except for one report. It is an external datawindow and when we save it as XLSX! it then throws an error:
We are looking for an answer and haven't been able...
What are the best techniques for User ingestion of Spreadsheet data
- How-to
- Last updated 3 years ago
- Sivaprakash BKR replied 3 years ago
We are looking for the best techniques - and perhaps sample code which would allow users to import spreadsheet data into a datawindow.
This would have to be somewhat dynamic in that the format of the spreadsheet could change from one spreadsheet to ...
SaveAs to XLSX in PowerServer 2020
- Resolved
- Issue
- Last updated 3 years ago
- Chris Pollach @Appeon replied 3 years ago
We are trying to export a report to .xlsx format with a PB 2019 application using PowerServer 2020. Here is the GetFileSaveName call we are using for the dialog.
GetFileSaveName ( "Save As", ls_path, ls_file, "", "Excel with headers (*.xls),*.xls,Ex...
- Page :
- 1