Hi Mathews,

Following are a couple of Code Samples found on CodeXchange relating to Excel:

Create Spreadsheet From DataWindow Using OLE

Excel through OLE Automation Demo

And, perhaps, this article is what you are looking for:

https://community.appeon.com/index.php/articles-blogs/tips-tricks-techniques-articles/17-powerbuilder/190-exporting-datawindows-to-excel-html-without-loosing-format

I hope this helps.

Regards,

Greetings, Mathews - 

Here's another option you may wish to consider:

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

Regards, John

If your goal is to provide a way to "export" multiple kinds/styles DW's into Excel spreadsheets (i.e., a general-purpose solution), then no, there's no quick and easy (and free!) answer. As Armeen has indicated, if it was trivial, everyone would just do it.

If, however, you need to do this for a single or very small number of DW's where each export is very nearly the same (limited differences in the data content), then you might consider starting with a pre-defined "template" spreadsheet that already contains the company logo, headers, fonts, formatting, etc. Use OLE/PowerScript to open the starting spreadsheet, populate the data values into their pre-determined cells in the spreadsheet, even insert & populate rows, then perform a Save As. This is still not a trivial task, but it's a lot simpler than coding a general-purpose solution from scratch.

This may not be a feasible solution for your needs, but I'll throw the idea out there in case it might help.

Best wishes, John

(Edited)

What do you mean "you can't get through"? The links work fine for me...

I think the last link that Govinda provided might solve your problem, though it does NOT save images, but it might solve your problem. To solve the problem of the images, you could modify the code yourself. It's not a very fast solution (Desta's dw2xls library is faster, does export images but it's not free, though not very expensive I think it's around 600 dollars or similar)(The link to Bruce's example does not manage any images).

In the past I made a sample app in PB 2017, see: https://community.appeon.com/index.php/qna/q-a/save-dw-to-excel?limitstart=0#reply-19249 In "responses (5)" you'll see a zipped attachment of my sample application which you can download.

regards.

The below link as work for me finally.

https://community.appeon.com/index.php/articles-blogs/tips-tricks-techniques-articles/17-powerbuilder/190-exporting-datawindows-to-excel-html-without-loosing-format

Small thing remaining how can i enable pop up where user can save to preferred location path.

What is there is the pre-defined path.