Discussions tagged Excel

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 ...
Hello all, we have a PB application that uses OLEObject to interface with an Excel sheet. This application is published with Appeon Web and used thru IWA, i works fine. We have to publish the same application with Appeon Mobile (for Ipad) so...
Hi all, First of i would like to thank the Appeon team for delivering PB2017 without any ( in our case ) bugs ! The migration process was easy and straightforward. After many years of being in the PB dark tunnel, we can finally see light again at ...
Hello to all I need to import in PB some data coming from some excel sheets. I do this: a cycle that is repeated N times with a FOR in which: I create, read and destroy excel. The problem is that excel in the task manager does not disappe...
Hello dear members of the Community ! My issue is the following : I need to be able to save the content of a DW in a .xlsx format. We are using Excel 2013 and Excel 2016. I’m working with a version 12.1 of PowerBuilder and migrating it to Power...
Hi, I use code and run, I can get what I want (Powerbuilder 10.5 and MS-Excel 2003) oleobject myoleobject, lole_Sheet myoleobject = CREATE OLEObject myoleobject.ConnectToNewObject("Excel.Application") myoleobject.Application.StandardFont =...
If I open an Excel file through PB 12.5 classic using the ShellExcuteW API it opens the file correctly. I type or change something in the file and close it without saving.  Excel does not detect a change and ask if I want to save. If I open the...
I'm wondering whether any of the PB experts here have ever considered trying to do a product that does what DW2XLS does, but better? I expect you’re familiar with it, but in case you aren’t, it’s at http://desta.com.ua/dw2xls/ - it exports DWs to nic...
  • Page :
  • 1