to export datawindow into excel as it is on the screen

News group sybase.public.powerbuilder.general

to export datawindow into excel as it is on the screen 2009-06-26 11:48
Hi all,

Please anybody can give help to export a datawindow to excel as in same layout
appear on screen .

With thanks

Pol
---== Posted via the PFCGuide Web Newsreader ==---
http://www.pfcguide.com/_newsgroups/group_list.asp
Menu
Re: to export datawindow into excel as it is on the screen 2009-06-26 12:49
Check out DW2XLS from Desta at http://desta.com.ua/dw2xls/

Arthur


>Hi all,
>
>Please anybody can give help to export a datawindow to excel as in
>same layout appear on screen .
>
>With thanks
>
>Pol
>---== Posted via the PFCGuide Web Newsreader ==---
>http://www.pfcguide.com/_newsgroups/group_list.asp
Re: to export datawindow into excel as it is on the screen 2009-06-29 16:22
Is it can use as free. If then what I have to do to work with my exe file.
I am using polwerbuilder 11.2

Please let m know


in sybase.public.powerbuilder.general
>Check out DW2XLS from Desta at http://desta.com.ua/dw2xls/
>
>Arthur
>
>
>>Hi all,
>>
>>Please anybody can give help to export a datawindow to excel as in
>>same layout appear on screen .
>>
>>With thanks
>>
>>Pol
>>---== Posted via the PFCGuide Web Newsreader ==---
>>http://www.pfcguide.com/_newsgroups/group_list.asp
>
Re: to export datawindow into excel as it is on the screen 2009-06-30 09:19
If by layout you mean the entire coloring, sizing etc, I agree with Arthur
about DW2XLS. It's worth the money. We've also managed to run this PBL with
.NET webform target. The output and the performance are very acceptable.

If you just want to export the data as it is on the screen (eg. meaningful
headers, computed columns, dddw display values and so on), and you're
talking of a netive PB application, you could experiment with SaveAsAscii /
SaveAsFormattedText to export DW contents into a text file and then to
implement OLE to Excel and to "instruct" excel to open this text file and
save it as a XLS.

I've recently added an ISUG enhancement request for a native support in
PowerBuilder about this feature. Someone could think furthermore about some
"XLS export specification" within each DW object and about the possibility
to choose/define if each cell should be exported as a value or as an Excel
formula. End users would like this!

Dig the forums (this one, .NET webform one) about similar discussions - you
might find different approaches.

Good luck
Ivaylo


>On 26 Jun 2009 03:49:47 -0700,
>Is it can use as free. If then what I have to do to work with my exe file.
>I am using polwerbuilder 11.2
>
>Please let m know
>
>
>in sybase.public.powerbuilder.general
>>Check out DW2XLS from Desta at http://desta.com.ua/dw2xls/
>>
>>Arthur
>>
>>
>>>Hi all,
>>>
>>>Please anybody can give help to export a datawindow to excel as in
>>>same layout appear on screen .
>>>
>>>With thanks
>>>
>>>Pol
>>>---== Posted via the PFCGuide Web Newsreader ==---
>>>http://www.pfcguide.com/_newsgroups/group_list.asp
>>
Re: to export datawindow into excel as it is on the screen 2009-06-29 19:42
It's not free but the costs are very low and pay off.

Arthur




>On 26 Jun 2009 03:49:47 -0700,
>Is it can use as free. If then what I have to do to work with my exe
>file.  I am using polwerbuilder 11.2
>
>Please let m know
>
>
> in sybase.public.powerbuilder.general
>>Check out DW2XLS from Desta at http://desta.com.ua/dw2xls/
>>
>>Arthur
>>
>>
>>>Hi all,
>>>
>>>Please anybody can give help to export a datawindow to excel as in
>>>same layout appear on screen .
>>>
>>>With thanks
>>>
>>>Pol
>>>---== Posted via the PFCGuide Web Newsreader ==---
>>>http://www.pfcguide.com/_newsgroups/group_list.asp
>>
Re: to export datawindow into excel as it is on the screen 2009-06-30 10:46
What is the price for that application. Just let me know

With thnaks

Polachan

in sybase.public.powerbuilder.general
>It's not free but the costs are very low and pay off.
>
>Arthur
>
>
>
>
>>On 26 Jun 2009 03:49:47 -0700,
>>Is it can use as free. If then what I have to do to work with my exe
>>file.  I am using polwerbuilder 11.2
>>
>>Please let m know
>>
>>
>> in sybase.public.powerbuilder.general
>>>Check out DW2XLS from Desta at http://desta.com.ua/dw2xls/
>>>
>>>Arthur
>>>
>>>
>>>>Hi all,
>>>>
>>>>Please anybody can give help to export a datawindow to excel as in
>>>>same layout appear on screen .
>>>>
>>>>With thanks
>>>>
>>>>Pol
>>>>---== Posted via the PFCGuide Web Newsreader ==---
>>>>http://www.pfcguide.com/_newsgroups/group_list.asp
>>>
>
to export datawindow into excel as it is on... 2009-06-26 11:48
Re: to export datawindow into excel as it is on... 2009-06-26 12:49
Re: to export datawindow into excel as it is on... 2009-06-29 16:22
Re: to export datawindow into excel as it is on... 2009-06-30 09:19
Re: to export datawindow into excel as it is on... 2009-06-29 19:42
Re: to export datawindow into excel as it is on... 2009-06-30 10:46