 |
BorlandTalk.com
Borland discussion newsgroups
|
| View previous topic :: View next topic |
| Author |
Message |
Brad Prendergast
Guest
|
 Posted: Mon Nov 28, 2005 1:20 pm Post subject: Re: Hiding columns |
 |
|
Aragorn <warcayac (AT) yahoo (DOT) com> wrote in message
<438b102c$1 (AT) newsgroups (DOT) borland.com>:
| Quote: | Hi dudes,
My app is using TExcelApplication, TExcelWorkBook and TExcelWorkSheet
components, I'm trying to hide certains columns in some worksheets
before saving them into a spreedsheet, my request is to get some help
for realizing this because this code doesnt work apparently:
procedure TSendForm.HideColumnsIn(Sheet: TExcelWorksheet);
begin
Sheet.Columns[1].Visible:= False;
end;
Delphi (7 Enterprise) raises a error message after setting
"Sheet.Columns[1]." statement.
Regards
Aragorn
|
Excelworksheet1.Cells.Item[r,c].EntireColumn.Hidden:= True;
--
Brad Prendergast
"The only difference between me and a madman is that I'm not mad." --
Salvador Dali (1904 - 1989)
|
|
| Back to top |
|
 |
Aragorn
Guest
|
| Posted: Mon Nov 28, 2005 2:18 pm Post subject: Hiding columns |
|
|
Hi dudes,
My app is using TExcelApplication, TExcelWorkBook and TExcelWorkSheet
components, I'm trying to hide certains columns in some worksheets before
saving them into a spreedsheet, my request is to get some help for realizing
this because this code doesnt work apparently:
procedure TSendForm.HideColumnsIn(Sheet: TExcelWorksheet);
begin
Sheet.Columns[1].Visible:= False;
end;
Delphi (7 Enterprise) raises a error message after setting
"Sheet.Columns[1]." statement.
Regards
Aragorn
|
|
| Back to top |
|
|
|
|
You cannot post new topics in this forum
You cannot reply to topics in this forum
You cannot edit your posts in this forum
You cannot delete your posts in this forum
You cannot vote in polls in this forum
|
|
FAQ
Search
Memberlist
Usergroups
Register
Profile
Log in to check your private messages
Log in
