Sybase NNTP forums - End Of Life (EOL)

The NNTP forums from Sybase - forums.sybase.com - are now closed.

All new questions should be directed to the appropriate forum at the SAP Community Network (SCN).

Individual products have links to the respective forums on SCN, or you can go to SCN and search for your product in the search box (upper right corner) to find your specific developer center.

Saving as HTMLTable problem (blank columns)

2 posts in DataWindow Last posting was on 2009-10-07 15:26:40.0Z
Oletros Posted on 2009-10-07 10:51:07.0Z
From: Oletros <gwydion@oletros.com>
Newsgroups: sybase.public.powerbuilder.datawindow
Subject: Saving as HTMLTable problem (blank columns)
Date: Wed, 7 Oct 2009 03:51:07 -0700 (PDT)
Organization: http://groups.google.com
Lines: 11
Message-ID: <1b3d5370-45a7-421d-9de1-e0c1e5a3221f@k41g2000vbt.googlegroups.com>
NNTP-Posting-Host: 217.126.123.61
Mime-Version: 1.0
Content-Type: text/plain; charset=ISO-8859-1
Content-Transfer-Encoding: quoted-printable
X-Trace: posting.google.com 1254912667 28285 127.0.0.1 (7 Oct 2009 10:51:07 GMT)
X-Complaints-To: groups-abuse@google.com
NNTP-Posting-Date: Wed, 7 Oct 2009 10:51:07 +0000 (UTC)
Complaints-To: groups-abuse@google.com
Injection-Info: k41g2000vbt.googlegroups.com; posting-host=217.126.123.61; posting-account=vLeD2AoAAAAKLwKAYhkj8cFYOB2e6HQO
User-Agent: G2/1.0
X-HTTP-UserAgent: Mozilla/5.0 (Windows; U; Windows NT 5.1; en-US) AppleWebKit/532.0 (KHTML, like Gecko) Chrome/4.0.210.0 Safari/532.0,gzip(gfe),gzip(gfe)
Path: forums-1-dub!forums-master!newssvr.sybase.com!news-sj-1.sprintlink.net!news-peer1.sprintlink.net!newsfeed.yul.equant.net!novia!news-out.readnews.com!transit3.readnews.com!postnews.google.com!k41g2000vbt.googlegroups.com!not-for-mail
Xref: forums-1-dub sybase.public.powerbuilder.datawindow:90064
Article PK: 409671

I have to export a datawindow to excel keeping formatting so I export
it as HTMLTable.

The problem is that I have to destroy some controls in the datawindow
because there are buttons and when I open the file in Excel I have
some blank colums.

How can I get ride of those columns?

Best regards,
Iñaki


"Jerry Siegel [TeamSybase]" <jNOsSPAMsiegel Posted on 2009-10-07 15:26:40.0Z
From: "Jerry Siegel [TeamSybase]" <jNOsSPAMsiegel@yahoo!.com>
Newsgroups: sybase.public.powerbuilder.datawindow
References: <1b3d5370-45a7-421d-9de1-e0c1e5a3221f@k41g2000vbt.googlegroups.com>
Subject: Re: Saving as HTMLTable problem (blank columns)
Lines: 29
X-Priority: 3
X-MSMail-Priority: Normal
X-Newsreader: Microsoft Outlook Express 6.00.2900.5843
X-RFC2646: Format=Flowed; Original
X-MimeOLE: Produced By Microsoft MimeOLE V6.00.2900.5579
NNTP-Posting-Host: vip152.sybase.com
X-Original-NNTP-Posting-Host: vip152.sybase.com
Message-ID: <4accb330$1@forums-1-dub>
Date: 7 Oct 2009 08:26:40 -0700
X-Trace: forums-1-dub 1254929200 10.22.241.152 (7 Oct 2009 08:26:40 -0700)
X-Original-Trace: 7 Oct 2009 08:26:40 -0700, vip152.sybase.com
X-Authenticated-User: TeamSybase
Path: forums-1-dub!not-for-mail
Xref: forums-1-dub sybase.public.powerbuilder.datawindow:90066
Article PK: 409670

You could use [copied from the DWSyntax tool]
<DW Control Name>.Modify( &
"destroy <optionally specify the keyword 'column'> <Columnname>")
//Example: dw_1.Modify("destroy column salary")
//OR
// dw_1.Modify("destroy salary")

or you might try setting the width to 0
--
Report Bugs to Sybase: http://case-express.sybase.com/cx/welcome.do
Product Enhancement Requests:
http://my.isug.com/cgi-bin/1/c/submit_enhancement


"Oletros" <gwydion@oletros.com> wrote in message
news:1b3d5370-45a7-421d-9de1-e0c1e5a3221f@k41g2000vbt.googlegroups.com...
I have to export a datawindow to excel keeping formatting so I export
it as HTMLTable.

The problem is that I have to destroy some controls in the datawindow
because there are buttons and when I open the file in Excel I have
some blank colums.

How can I get ride of those columns?

Best regards,
Iñaki