Hi,
How do you add a worksheet and give it a name, and how do you know how many worksheets there are in the workbook?
best
Jon
Search found 5 matches
- Tue Nov 01, 2016 11:34 am
- Forum: XLSReadWritwII 6
- Topic: Adding worksheets
- Replies: 1
- Views: 2393
- Fri Apr 29, 2011 4:36 am
- Forum: XLSReadWriteII 3/4/5
- Topic: Colors
- Replies: 3
- Views: 4648
Re: Colors
Hi,
Found a solution. It works if I for example use xc30 instead of xc1. From reading the code it seems that values less than 8 are not valid.
(see line 2305 in XLSReadWriteII4.pas)
best
Jon
Found a solution. It works if I for example use xc30 instead of xc1. From reading the code it seems that values less than 8 are not valid.
(see line 2305 in XLSReadWriteII4.pas)
best
Jon
- Fri Apr 29, 2011 2:10 am
- Forum: XLSReadWriteII 3/4/5
- Topic: Colors
- Replies: 3
- Views: 4648
Re: Colors
Hi again,
Yes, I have tried that - it does compile and changes the palette, but does not have any effect on the colors in the spreadsheet.
jon
Yes, I have tried that - it does compile and changes the palette, but does not have any effect on the colors in the spreadsheet.
jon
- Fri Apr 22, 2011 7:12 am
- Forum: XLSReadWriteII 3/4/5
- Topic: Colors
- Replies: 3
- Views: 4648
Colors
Hi, I am trying to modify the colors of the cell. I had thought the following code would do the trick: ExcelColorPalette[1]:=$00F1E5DB; // light blue with XLSCMI.Sheet[0] do Begin AsString[0,0]:=CountryEdit.Text; Cell[0,0].FontSize:=16; Cell[0,0].FontStyle:=[xfsBold]; Cell[0,0].FillPatternForeColor:...
- Sat Apr 02, 2011 2:13 pm
- Forum: XLSReadWriteII 3/4/5
- Topic: Problems installing in Delphi XE
- Replies: 1
- Views: 4481
Problems installing in Delphi XE
Hi,
I have problems installing the components in Delphi XE Enterprise, windows 7, 64 Bit.
When I install, there are no bpl files, and nothing installed into the IDE
best
Jon
I have problems installing the components in Delphi XE Enterprise, windows 7, 64 Bit.
When I install, there are no bpl files, and nothing installed into the IDE
best
Jon