FYI - I'm on version
XLSReadWriteII 4.00.45 using Delphi 7.
Search found 3 matches
- Thu Feb 17, 2011 3:33 am
- Forum: XLSReadWriteII 3/4/5
- Topic: Wrap doesn't work when writing to excel 2007
- Replies: 1
- Views: 2561
- Thu Feb 17, 2011 3:26 am
- Forum: XLSReadWriteII 3/4/5
- Topic: Wrap doesn't work when writing to excel 2007
- Replies: 1
- Views: 2561
Wrap doesn't work when writing to excel 2007
I'm using the following code to set the wrap property in Excel for all cells. This works fine when writing to exel97 sheets but doesn't work for excel2007. Do you have a fix for this? aXLS.Sheet[fNewSheetRefNumber].Range[ 0, 0, aXLS.Sheet[fNewSheetRefNumber].LastCol, aXLS.Sheet[fNewSheetRefNumber].L...
- Tue Jun 01, 2010 6:46 am
- Forum: XLSReadWriteII 3/4/5
- Topic: Convert number stored as text to number
- Replies: 0
- Views: 2826
Convert number stored as text to number
How can I convert a number stored as text to a number. I can do it in Excel but can't figure out a simple way to do it using XLSReadWriteII4. For now I'm just using XLS.Sheet[0].AsFloat[i,z] := StrToFloat(StringReplace(XLS.Sheet[0].asString[i,z], ',','',[rfReplaceAll])); and it works. I wonder it th...