Axolot Data

Hi,

any news on this issue?

Just a plain and simple ADO connection var SampleDataset: TADODataset; begin SampleDataset := TADODataSet.Create(nil); SampleDataset.ConnectionString := Format('Provider=Microsoft.ACE.OLEDB.12.0;Data Source=%s;Extended Properties="Excel 12.0;HDR=No;IMEX=1;ImportMixedTypes=Text;FirstRowHasNames=...

Any news on this issue?

Hi Lars,

Yes, that works.

Hi Lars, That also will give an error. Here is the code: function TInterfaceDefinition.CSV_To_XLS(const AFileName: String; const ADelimiter: Char): String; var FileContents: TStringList; i, j: Integer; LineContents: TStringList; XLS: TXLSReadWriteII5; begin Result := GetWindowsTempDir + GiveGuid(Tru...

Hi, I'm running on 5.10.25 I have created an Excel2007 xlsx file with XLSReadWriteII5 like so: XLS := TXLSReadWriteII5.Create(nil); try // somestuff for i := 0 to Pred(FileContents.Count) do begin for j := 0 to Pred(LineContents.Count) do XLS[0].AsString[j,i] := LineContents[j]; end; XLS.Calculate; ...