Hi Lars,
I have sent you an email with the xlsx file which didn't work.
Cheers,
Kaye.
Search found 5 matches
- Wed Dec 23, 2015 11:23 pm
- Forum: XLSReadWritwII 6
- Topic: XLSX with comments
- Replies: 2
- Views: 2787
- Tue Dec 22, 2015 3:57 am
- Forum: XLSReadWritwII 6
- Topic: NameAsCell - missing in XLSReadWriteII 5?
- Replies: 1
- Views: 2296
NameAsCell - missing in XLSReadWriteII 5?
Hi,
In XLSReadWriteII 4, I was able to write this code:
In XLSReadWriteII 5, how do I obtain the cell by name and then apply the required format?
Thanks for your help.
Cheers,
Kaye.
In XLSReadWriteII 4, I was able to write this code:
Code: Select all
XLS.NameAsCell["MyCellName'].NumberFormat := '[$£-809]#,##0.00;[RED]-[$£-809]#,##0.00'
Thanks for your help.
Cheers,
Kaye.
- Tue Dec 22, 2015 2:52 am
- Forum: XLSReadWritwII 6
- Topic: XLSX with comments
- Replies: 2
- Views: 2787
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...
- Mon Dec 21, 2015 5:01 am
- Forum: XLSReadWritwII 6
- Topic: XLSReadWriteII 5 - cell number format and font style
- Replies: 1
- Views: 2631
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...
- Mon Dec 21, 2015 4:57 am
- Forum: XLSReadWritwII 6
- Topic: XLS DB Read - formatting cells
- Replies: 1
- Views: 2921
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',...