Axolot Data

That is what I'm looking for.

Thanks
Zdenek

Ok.

How can I find that htere is nothing in cell?

Now I'm using

if not FindCell() then result:=Null

but I also need test for Blank Cell. How can I test if cell is blank?

Thanks
Zdenek

I think it should return Null as this is a purpose of Variant type.

Z

Hello, I have problem with AsVariant. If cell is clear, funtion returns value "1". I think the problem is in GetAsVariant: function TXLSWorksheet.GetAsVariant(ACol, ARow: integer): Variant; var Cell: TXLSCellItem; begin if FCells.FindCell(ACol,ARow,Cell) then begin case FCells.CellType(@Ce...

Sorry to be to late. Lot of another work. Here is code sample XLS.Insert(1); XLS.Sheets[0].Name:='Přehled pokladních operací'; XLS.Sheets[1].Name:='Definice pokladních operací'; XLS.Sheets[0].AsInteger[1,10]:=1; with XLS.Sheets[0].Hyperlinks.Add do begin Col1:=1; Col2:=1; Row1:=10; Row2:=10; Address...

I think it's not good behaviour. If I set Null to cell using AsVariant, cell should be cleared. Thats's why we use variants with nulls.

This should work directly like this:

XLS[].AsVariant[]:=Dataset.Fields[].AsVariant

Ok. So Is setting Version at runtime right approach?

If I remove quotes, it's still not working.

Hello,

If I set null to AsVariant(col,row), application raises exception and excel file is corrupted. AsVariant function should handle null state properly.

Thanks
Zdenek

Hello, I have this code in version 4 to create hyperlink to secont sheet (in one workbook): with XLS[0].Hyperlinks.Add do begin Col1:=1; Col2:=1; Row1:=Row0; Row2:=Row0; Address:='''Definice pokladních operací''!C100'; end; But with version 5, this hyperlnik do not work. If I click on it nothing hap...

Hello, I'm using excel97 format. If I set excel version on form (in component) to xvExcel97 and I want to start using BIFF, the BIFF is always nil. Also this happens after Clear call. I have to set Version=xvExcel97 at runtime to solve this: XLS.Clear; XLS.Version:=xvExcel97; //to create BIFF Is thi...

Hello,

I can not download 64bit version form XE2.

Thanks
Zdenek

Please add ShareIt link also.

Hello,

when assigning value to cell with AsVariant unicode strings are not stored:

XLS.Sheets[0].AsVariant[ACol,ARow]:= unicode string here

Problem is in SetAsVariant where unicode vartype is not tested. Ver 4.0.57

Thanks
Zdenek