Hi Lars et al
Reading in an XLS which has a cell formatted as "november 7 2009" and a number formatted as "£100,231.05" - All I want is the numbers 40124 and 100231. How do I get it to ignore / strip off the excel formatting
Fang
Search found 3 matches
- Sat Nov 07, 2009 7:21 pm
- Forum: XLSReadWriteII 3/4/5
- Topic: Stripping out excel formats help
- Replies: 1
- Views: 2819
- Fri Jan 02, 2009 12:35 pm
- Forum: XLSReadWriteII 3/4/5
- Topic: Lastrow - xlsrw4 vs xlsrw2
- Replies: 3
- Views: 4038
Re: Lastrow - xlsrw4 vs xlsrw2
Hi Larsa
I tried this with both calcdimensions and caldimensionsex but copied the last attempt above - silly me
XLSRW2 v2 and v3 both work fine, XLSWR4 doesn't.
I will send you the spreadsheet separately - you try!
Fang
I tried this with both calcdimensions and caldimensionsex but copied the last attempt above - silly me
XLSRW2 v2 and v3 both work fine, XLSWR4 doesn't.
I will send you the spreadsheet separately - you try!
Fang
- Mon Dec 29, 2008 4:32 pm
- Forum: XLSReadWriteII 3/4/5
- Topic: Lastrow - xlsrw4 vs xlsrw2
- Replies: 3
- Views: 4038
Lastrow - xlsrw4 vs xlsrw2
Hi there I have a largish spreadsheet - 24,000 rows and ssemed to be getting wierd results - like 10,000 blank rows. so... I tried the paintcell example using xlsrw2 with the fllowing code: xls.Filename := edFilename.Text; showmessage(inttostr(xls.sheets[TabSet.TabIndex].LastRow)); xls.Read; TabSet....