Search found 5 matches

by kayeng
Wed Dec 23, 2015 11:23 pm
Forum: XLSReadWritwII 6
Topic: XLSX with comments
Replies: 2
Views: 2167

Re: XLSX with comments

Hi Lars,

I have sent you an email with the xlsx file which didn't work.

Cheers,
Kaye.
by kayeng
Tue Dec 22, 2015 3:57 am
Forum: XLSReadWritwII 6
Topic: NameAsCell - missing in XLSReadWriteII 5?
Replies: 1
Views: 1801

NameAsCell - missing in XLSReadWriteII 5?

Hi,

In XLSReadWriteII 4, I was able to write this code:

Code: Select all

   XLS.NameAsCell["MyCellName'].NumberFormat := '[$£-809]#,##0.00;[RED]-[$£-809]#,##0.00'
In XLSReadWriteII 5, how do I obtain the cell by name and then apply the required format?

Thanks for your help.

Cheers,
Kaye.
by kayeng
Tue Dec 22, 2015 2:52 am
Forum: XLSReadWritwII 6
Topic: XLSX with comments
Replies: 2
Views: 2167

XLSX with comments

Hi, Just continuing my evaluation of XLSReadWriteII 5. I ran into the following issue: I am attempting to read an xlsx with comments in it like so: XLS.Filename := 'C:\XLSXWithComments.xlsx; XLS.Read; Doing this causes the XLSReadWriteII 5 to crash with the error: List Index out of bounds(0) If I ha...
by kayeng
Mon Dec 21, 2015 5:01 am
Forum: XLSReadWritwII 6
Topic: XLSReadWriteII 5 - cell number format and font style
Replies: 1
Views: 2102

XLSReadWriteII 5 - cell number format and font style

Hi, Just evaluating XLSReadWriteII 5 and have run into the following issue: Consider the following code: XLS.Add; XLS.Sheets[1].Name := 'Test new sheet'; XLS.Sheets[1].AsString[0, 1] := 'Dummy String for testing'; XLS.Sheets[1].Rows[1].FontStyle := [xfsItalic]; XLS.FileName := 'C:\DummyFileName.xlsx...
by kayeng
Mon Dec 21, 2015 4:57 am
Forum: XLSReadWritwII 6
Topic: XLS DB Read - formatting cells
Replies: 1
Views: 2395

XLS DB Read - formatting cells

Hi, I am in the process of evaluating XLSReadWriteII 5 and have run into the following issue: Consider the code below: TestDataset := TClientDataset.Create(nil); TestDataset.FieldDefs.Add('Name', ftString, 20); TestDataset.FieldDefs.Add('Address', ftString, 100); TestDataset.FieldDefs.Add('Balance',...