Re: Delphi vraagje

Article View: be.comp.programming

Article #6692

Back to be.comp.programming Previous Next

#6692

From: SETKI: http://users.skynet.be/se...
Date: Mon, 25 Nov 2002 23:14

36 lines
1981 bytes

On Mon, 25 Nov 2002 10:33:38 GMT, "JVB" <jvbsoft.geenspam@pandora.be>
wrote:

>Om vanuit Delphi een Excel Worksheet te genereren gebruik ik de component
>ExcelWorksheet. Werkt prima.
>
>Vraag is nu : hoe kan ik vanuit Delphi de veldbreedte van een kolom op een
>gewenste breedte zetten ??

  zoiets als ...

   // Connect to the server TExcelApplication 
   XLApp.Connect; 

    // Add WorkBooks to the ExcelApplication 
   XLApp.WorkBooks.Add(xlWBatWorkSheet,0); 

   // Select the first WorkBook 
   WorkBk := XLApp.WorkBooks.Item[IIndex]; 

   // Define the first WorkSheet 
   WorkSheet := WorkBk.WorkSheets.Get_Item(1) as _WorkSheet; 

   // Customise the WorkSheet 
   WorkSheet.Name := 'Customers'; 
   Worksheet.Columns.Font.Bold := True; 
   Worksheet.Columns.HorizontalAlignment := xlRight; 
   WorkSheet.Columns.ColumnWidth := 14; 



greetings, Setki

--
Pratice your spanish (verbs, numbers, words, etc...) :
  http://users.skynet.be/setki/software

Technical Details

Message-ID: <ehb5uu8vur9nesp7cqt2ncuqjriqet4moc@4ax.com>

Path:

arc1-ca.pugleaf.net!archiver1.google.com!news1.google.com!sn-xit-02!sn-xit-03!sn-xit-01!sn-xit-08!supernews.com!news.tele.dk!news.tele.dk!small.news.tele.dk!skynet.be!skynet.be!louie!not-for-mail

References: <60nE9.18809$Ti2.2854@afrodite.telenet-ops.be>

Show Full Headers

Complete Article Headers

X-Google-Language: ENGLISH,ASCII-7-bit
X-Google-Thread: fcea4,27ffee25f34e4497
X-Google-Attributes: gidfcea4,public
X-Google-ArrivalTime: 2002-11-25 15:15:32 PST
Path: arc1-ca.pugleaf.net!archiver1.google.com!news1.google.com!sn-xit-02!sn-xit-03!sn-xit-01!sn-xit-08!supernews.com!news.tele.dk!news.tele.dk!small.news.tele.dk!skynet.be!skynet.be!louie!not-for-mail
From: "SETKI: http://users.skynet.be/setki/" <setki@skynet.be>
Newsgroups: be.comp.programming
Subject: Re: Delphi vraagje
Date: Tue, 26 Nov 2002 00:14:02 +0100
Reply-To: setki@skynet.be
Message-ID: <ehb5uu8vur9nesp7cqt2ncuqjriqet4moc@4ax.com>
References: <60nE9.18809$Ti2.2854@afrodite.telenet-ops.be>
X-Newsreader: Forte Agent 1.8/32.553
MIME-Version: 1.0
Content-Type: text/plain; charset=us-ascii
Content-Transfer-Encoding: 7bit
Lines: 36
Organization: -= Skynet Usenet Service =-
NNTP-Posting-Host: 217.136.128.93
X-Trace: 1038265872 reader0.news.skynet.be 86546 217.136.128.93
X-Complaints-To: abuse@skynet.be

Reply to Parent Message