Discussions tagged Excel

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...
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...
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...
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.  ...
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 ...
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...
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 ...
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...
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 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 ...
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...
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...
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?   ...
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