Axolot Data

Is this for V4 (rather than V5). If so, I doubt that we will ever see a fix for it. In which case, any chance of a copy of the modified routine (I'm still using V4 under D7).

My e-mail is gerbilsoft <at> btinternet <dot> com.

is there anyway to do this easily - I was hoping for some function that's not obvious as it does recalculate for the functions below the row insert Does version 5 have an option to do this if version 4 does not I haven't got a clue about version 5 (but I doubt if it's fixed). I have, however, made ...

Im using the TXLSReadWriteII4 version 4.00.60 I have a total band at the top of the excel sheet e.g. Field A1 =Sum(F1:X1) I also have the same formula at Field Y1 e.g. =Sum(F1:X1) if I insert a new row at J1 the Formula range for Field A1 is not being updated where the Y1 Formula range and position...

EdwinGrimshaw wrote:d :Double;
....
d := XLS.Sheets[Sheet].Cell[x, y];
Ed

Try

d := XLS.Sheets[Sheet].AsFloat[x, y];
or .AsString[x,y];
.. .AsInteger[x,y];

I think what you want is (something like) ...
Hope that helps

I have a routine I've used for several years It's got a couple of non-general bits in it ... 1) I use a Raize SaveDialog to get specify where the file will be saved. (This can easily be replaced with a standard SaveDialog.) 2) I use my own MessageDialog (based on something from Delphi Informant in t...

The way I usually sort this sort of thing out is to go into Excel and record a macro doing what I want, then translate that into xlsReadWrite. For example, I just told Excel to use currency format on a cell and accepted the defaults. The resulting macro was: Selection.NumberFormat = "$#,##0.00&...

Looks like it *has* been fixed. The code to get he filename is now ...

function XLSGetTempFile: WideString;
begin
Result := TempFilePrefix + IntToStr(GetTickCount) + '.tmp';
end;

So that should give a different name each time it's called.

I had this problem and found it better to use PixelWidth, so I wrote the following function: function xlsPixelWidth(CharWidth: Double): Integer; begin // Returns an adjusted width for a work-around in xlsReadWrite Result := Trunc(7 * CharWidth) + 5; end; Then I simply use (for example) Columns[0].Pi...

Lars,

I E-mailed you last wek but haven't had a reply. Did you get the message?

Would you please send the update to me at

JoeGriffin <at> cix <dot> co <dot> uk

Thanks,

You must put quotes around names with spaces But how can I do that? I create the autofilter by calling ... xlsReadWriteII3.Sheet[0].AutoFilters.Add(0, 0, TotalCols - 1, RowCount - 1); At no point do I use the sheet name; that's provided by your code. Is there any chance you could release the .dpk f...

I've just hit a problem with Autofilter.. I have a sheet with a space in the sheet name "Kheops Orders". When I try to create an autofilter, I receive an error message : Error in formula Kheops Orders!$A$1:$K$2301 Unknown name KHEOPS. I have worked around it by using an underscore in the s...

Lars, Having updated to V 3.01, I spotted that the components still have a ComponentVersion of 3.00.7. I assume that this is a slip-up as the source does say 3.01. (D5, 6 & 7) Also, would it be possible for you to include the .dpk file with the source; it's the one item which is missing. Best re...