Search found 5 matches

by JonPedersen
Tue Nov 01, 2016 11:34 am
Forum: XLSReadWritwII 6
Topic: Adding worksheets
Replies: 1
Views: 2393

Adding worksheets

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
by JonPedersen
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
by JonPedersen
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
by JonPedersen
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:...
by JonPedersen
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