Axolot Data

Hi, I have an issue opening xls files (excel97-2003 format), I am getting a strange error of Missing Password and XLSX files are read OK without any issue. I have tried to open with a specific version by setting the version: SampleWorkbook:= TXLSReadWriteII5.Create(Nil); SampleWorkbook.Filename := '...

Hi Lars,

I upgraded to the latest version and it all works fine.

Thanks
Allan

Hi, I am receiving an #Value response to a formula when one of the cells is blank. Book.Sheets[0].asformula[1,1] := 'D1+E1'; sRatePrice := Book.Sheets[0].Calculate(1, i); When either D1 or E1 is blank I get the error via sRatePrice, if both are valid numerics then the formula calculates as expected....

Hi, I am trying to perform a VLookup referring to another workbook and getting uknown sheet name The lookup contents is VLOOKUP(B4,"[MAPPING.xlsx]"MAP!$N$2:$O$52,2,FALSE) It doesn't seem to recognise the sheet MAP but it is definately there? Is my lookup definition incorrect? Thanks Allan

Hi, I have a multi-threaded application which reads a series of CSV's (sometimes the same file in separate threads) , does some calcs and propagates results to oracle db. I am receiving E4003 exception when I am setting the asformularef to the required formula The exception does not occur everytime ...