Axolot Data

Hi Lars, Ken is totally right. After many hours of debugging, i found out that the 3-d party DBMS components I was using were the one that eventually made the whole mess. These were handling input Unicode data such way that when it war retrieved back from the DB and passed to XLSRWII, it wasn't able...

Hi Larsa, I got it.. I will give you an example... So suppose that the value stored in the DB is :'Þessi bíll er mjög fljótur og hættulegur í þessum þrönga götu' Now, Delphi has already parsed and put this value to the AdoQ.Fields[fcol].AsString variable (this can be verified by either putting the c...

Hi Larsa, The value of AdoQ.Fields[fcol].AsString is the one that has been stored to the relative table of the DB. What I mean is that, if you put a watch on AdoQ's value you would see that Delphi parses the value correctly no matter if the field is nvarchar or ntext. However, XLS can not write AdoQ...

Hi, I am using Delphi XE10 on windows7 and I've built an application in which I try to create an xls file with XLSReadWriteII 5 component. Specifically I am reading data that has been stored previously in an sql table and exporting it to a xls file. Now, while everything works fine with ASCII charac...

In my initial post / request for help, I wanted to say that with the project I am building the user can extract the data from specific tables of one of his Databases and export them to an xlsx file that is created with the XLSReadWriteII 5 component.

Hi, I am creating a project with Delphi 7, MSSql 2000 in which the user is able to draw the content of a database and export it in an xlsx file. Now, I put in a form an XLSReadWriteII 5 object (which I named XLappSun) and execute the following code in order to create the xlsx file: XLappSun.Clear; T...