Axolot Data

Guest

Hello,

Help me!!!!

Cris

Guest

Hello,

Get the latest update of link:

http://www.axolot.com/components/f_downloadreg.htm

Guest

Hello,

This same problem occur with me ("wrong number of arguments for function ABS"), but I'm using a version 3.01.01 and is occur on unit XLSFuncEval2 and I'm using the formula -> (valor_411-ABS(valor_412))

Guest

larsa wrote:Hello

Yes, you where right. I have found the problem now. The fix will be included in the next update.

Lars Arvidsson

-----
Hello Lars Arvidsson,

I have the same problem with version 3.
Can you already tell when the bugfixed version will be available?

Clemens Lehnert

Guest

Hello,

Is it possible to use the pivot table with XLSReadWrite III 3.0 ?

best regards,
Raf

Guest

Hello!

I try to add ComboBox, here is my code:

Code: Select all

uses ControlObj2;

 with XLS.Sheets[0].ControlsObjects.ComboBoxes.Add do begin
   SourceArea := 'A6:A9';
   DestCell := 'B2';
 end;

When I am running the .exe-file I get an error: 'Unknown SBS formula'.
What's wrong?
Could you post a code sample?

Guest

I compile simple test program with demo-version 3.01.01a. ... XLS.FileName := 'test.xls'; XLS.Read; XLS.Write; ... File size is > 1Mb, with 15 or more worksheets. Read from file is very fast, < 1sec Write to file is very-very-very slow, > 2min!!! Why? If file contains formulas in some cells, result ...

Guest

How to read Formula in cell with reference on external xls-file?
AsFormula[col, row] returns
''??..\..\..\..\..\??..\..\..\..\..\..\?..\..\..\..\..\..\..\..\?..\?..\..\..\??..\..\..\..\..\..\..\..\..\..\?..\..\..\..\..\..\..\..\..\..\..\..\..\?..\..\..\???'#0'Sheet1'!$F$35'

Guest

Thank for reply

But can you help me a example how to done that problem.

Guest

Hello.
I try to test XLSReadWriteII 3.0 (testpackage).
I cannot install the package on our delphi 6.0
because we have another package which also
uses the ZLib (xtradev for Reportbuilder).

Any ideas?

thanks
mba-software

Guest

hi i need read excel cell then write to a text file with unicode. my procedure here : procedure ConvertToXML(sheetindex:Integer;xlsfile:String;outfile:String); var XLS:TXLSReadWriteII2; col,row:integer; ws:TStringList; begin XLS:=TXLSReadWriteII2.Create(nil); XLS.Filename:=xlsfile; XLS.Read; ws:=TSt...

Guest

Thanks, Larsa

I copy first with DoCopyCells as False, then use CopyCells, but only formulas are copied instead of values of formula...

Guest

Hello!

I'd like to copy columns from one sheet to other with formula in cells but copy only value of formula.

I use 'CopyColumns(SrcSheet, Col1, Col2, DestSheet, DestCol: integer; DoCopyCells: boolean = True)' but unsuccessfully.
Please, help me.

Thanks!

Guest

Hello! Why at opening a file there is a mistake? xls.Filename := 'c:\1.xls'; xls.Sheets[0].Name := 'A'; with xls.InternalNames.Add do begin BuiltInName := bnPrintArea; Definition := 'A!$D$4:$G$10'; end; xls.Sheets.Add; xls.Sheets[1].Name := 'S'; with xls.InternalNames.Add do begin BuiltInName := bnP...

Guest

Hi Lars, Just getting back into this issue... I did find the problem and can recreate it. It appears when you delete the default worksheet that is automatically created. This code will indeed cause that access violation in v3: with TXLSReadWriteII2.Create(Self) do try Sheets.Add.Name := 'test'; Shee...

Axolot Data

Search found 82 matches

Pivot table

How to add ComboBoxes properly?

Slow write

Formula with external reference

Installation Problem XLSReadWriteII 3.0

Read Excel cell and write to text with unicode ?

CopyColumns with cell value