Discussions tagged Excel
How to change the delimiter from comma to other special character using powerbuilder
- Resolved
- Issue
- Last updated 1 year ago
- mike S 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 1 year ago
- John Fauss replied 1 year 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 1 year ago
- Gordon Weil replied 1 year 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 2 years ago
- Danish Ahamed LiakathAli replied 2 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 2 years ago
- René Ullrich replied 2 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 2 years ago
- Olan Knight replied 2 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 2 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...
Hi.
We have a function that saves the content of a datawindow to Excel using this code:
try
ll_return = dw_saveas.SaveAs(ls_xls, XLSX!, true)
catch (Throwable th) messagebox("",th.GetMessage())
end try
The datawindow has about 180.000 r...
Hello ,
Doe's anyone have an idea how to save dw to excel with out changing the format ?
like : colors , grouped and so on
or a 3'rd party tool
Thanks...
Huge default width of columns in excel12-export of datawindow.
- Resolved
- Issue
- Last updated 3 years ago
- John Fauss replied 3 years ago
Hi.
I am using PB 2017 R3 Build 1858.
When exporting a datawindow to excel12 the width of the string-columns is huge (254,29), regardless of whether the column contains onbly short texts. When using excel8 for export the columns are only 10,71 wide...
Powerbuilder 2017 R2 Citrix ODBC
- Resolved
- How-to
- Last updated 4 years ago
- Prasad Pati replied 4 years ago
Powerbuilder application deployed to Citrix works great, except connecting to Excel file. I am using ODBC to connect to excel file to import data into datawindow, this works great on desktop but in Citrix client C: drive becomes \\Client\c$. getting ...
Exporting datawindow presentation layer to excel
- How-to
- Last updated 4 years ago
- Miguel Leeuwe replied 3 years ago
Hello.
Is there any (easy) way to export the presentation layer of a datawindow preferably as excel. I have searched around and haven't managed to find anything that gives you an export of "what you see" on the datawindow. My next try is probably go...
Connecting and populating an Excel template
- Advice
- Last updated 4 years ago
- René Ullrich replied 4 years ago
Hello,
I was wondering if there is another way to connect to and populate an Excel spreadsheet other than the way below...
OLEObject lole_xlapp
// Create the oleobject variable xlapp lole_xlApp = Create OLEObject
// Connect to Excel and che...
PB 2017 R2, Build 1756
Hello PB Community,
I have the OLE code to paste the contents of a datawindow to an Excel spreadsheet (thank you to all the examples available online!)
I want to copy multiple datawindows into the same worksheet, but p...
excel chart format of line and fill
- Issue
- Last updated 5 years ago
- Michael Kramer replied 5 years ago
hi,
i'm creating an excel-sheet with an chart, no problem so far. im also creating a chart in it and i want to change the default color for the legend-objects.
the problem is that i found no way how it works, maybe anyone can help me?
...
Excel file not closing on disconnect
- Resolved
- Issue
- Last updated 5 years ago
- Dennis Little replied 5 years ago
All,
I'm opening an excel file and grabbing some cell info using ole. The excel file isn't closing. It isn't displayed in the menu tray. The only way I know it's open is to try and open it. Then I get the locked message saying ...
- Page :
- 1