Axolot Data

Hello,

Latest version gives me problems again inserting images! Previous version it works well.

Regards,
RJ

Hello,

I downloaded the latest version and removed all xlsread*.* files after deinstallation. Then I installed version 5.20.13 and now auto width and images word fine again. it must be some old source in my debug/ release dir. Strange but it works for me. So happy again!!

Regards,
RJ

I got the same problem with Delphi Xe5.

Also the same error when inserting an image.

Regards,
RJvV

I see we can download XLS for Delphi Xe4!

Hello Lars,

When can we expect a version that runs under Delphi xe4?

Regards,
Robert Jan van Vliet

I got this problem too.

The exception comes from this routine in xpgPXML:

procedure TXpgWriteXML.AddAttribute(const AName, AValue: AxUCString);
begin
AddAttr(AName);
AddAttr('="');
CopyToBufUTF8(AValue);
AddAttr('" ');
end;

Just download .02 and you get the .03 version!! Just some old tekst.

Great!

I am having 2 problems with the latest version:

1) In xvExcel97 the lastrow property doesnot got a value anymore;
2) In 64-bits I get the error that property Directwrite doesnot excist

Regards,
Robert Jan van Vliet

Lars I sent you mine excel-file.

The auto sizing of columns is not working correct in version 5. Anybody found a solution?

For anyone who has the same problem. I found the solution in de defaultformat. Very simple and fast!! You only have to change the defaultformat before writing the cells. Just an example how simple it is: // Create format F2 XLS.CmdFormat.BeginEdit(Nil); XLS.CmdFormat.Fill.BackgroundColor.RGB := $FF1...

Great!!

It is just your example. I excepted to see 3 formats in the excelfile, but I only see the green color format[color=$10F040][/color]: // Create first default format. // The sheet parameter of BeginFormat is Nil, as it's not assigned to any // particular woeksheet. XLS.CmdFormat.BeginEdit(Nil); XLS.Cm...

I try to implement the fastest method to format cells, but the example 'formatcells' shows only the format that is created al last. I moved 'F3' to the front and all the cells are not yellow anymore but red. So it donot listen to the if statements. That is a pitty because this method looks really go...