Hi, Moshe -

http://desta.com.ua/dw2xls/

Regards, John

I'm not aware of a way to do this in PowerBuilder itself, but there are third-party products that do this, such as DW2XLS.

If your are going to use the Desta dw2xls libraries:

- when you plan on using it for powerserver, than you'll have to manually replace all longlong and longptr variables to long / ulong. At least that was the case the last time I did a migration to powerserver. Maybe by now powerserver supports these datatypes? Not sure about that.

Here's an alternative way suggested by Eduardo G:

https://community.appeon.com/index.php/qna/q-a/replacement-for-dw2xls-for-exporting-dws-to-formatted-excel#reply-4973

I'm having a worked out version of what Eduardo G. says. I'm not sure if that code was originally his or someone else's (it surely wasn't mine), but I had to make a few modifications to it. Can't remember why.

Let me know if you need it when you're not going to use dw2xls. 

The solution "I" have is slower but might be good enough of what you need it for and also dw2xls is not perfect with freeform datawindows, works great though for Grid type dw's.

Okay,

I've made a small sample application (pb 2017 r3). This does not use dw2xls of Desta.

See attached. Unzip and add the target to one of your workspaces.

The code can be cleaned up quite a bit, I had to rip it out of our pfc classes and our own.

You need Office/Excel to be installed on your PC.

I'm using the temp folder of windows for the output of the file.

Hope it serves anyone.

I've taken out the previous attachment and here is an improved, cleaner version: See attached.

The previous version pretended to take out any images, but there was a " too much, so I've also corrected that one.

TODO: include images (which I do not have the time for at this point, but I'm pretty sure it can be done).

Should get some sleep.

regards,

MiguelL

NOTE: I do want to state that I think dw2xls is a better solution, unless Appeon does something useful with it in a future.