Axolot Data

Thanks, I foundi it....

Thanks in Advance..

I've never worked with streams, so I need a little help here on how to initiate from a standard TTable or TdataSet.

Thanks in Advance...

Here is Delphi Code. It is a passed in procedure ( We have a lot of excel exports, so it was refactored down to a single line call and have one routine do all of the coding) LOGO is a Global varible: Procedure LoadPic(var aXLS: TXLSReadWriteII4; var cl, rw, ImgWid, ImgHgt, ts : Integer); var ii, jj,...

Hello everyone.

How do you add a picture from a dataset graphic field?

The help and forum search only shows how to from a load from file perspective.

Thanks in Advance...

Can someone convert this to delphi code please?

[Red] is one and [Green] is the other except [Green] is more akin to Lime once it gets to the Excel Sheet.

So what are my options?

TIA

Okay I've got reproduceable Delphi Code: unit fMain; interface uses Windows, Messages, SysUtils, Variants, Classes, Graphics, Controls, Forms, Dialogs, StdCtrls, XLSReadWriteII4, DB, DBClient; type TMain = class(TForm) XLS: TXLSReadWriteII4; btnExport: TButton; dlgExcelExport: TSaveDialog; procedure...

This is my last procedure before XLS.Write call Delphi Code procedure TfrmXlsPBA.LoadOrderFormulas; var OrdNumRef, SpotRef, CostRef, GrpRef1, GrpRef2, Formula : string; OrdStartRef, OrdEndRef, TrueRef : string; begin XLS.BeginUpdate; OrdStartRef := ColRowToRefStr(0, StartRow, false, false); //GETS A...

I did not try the VB code. It was from an online translator.

Now the Delphi Code does work and I will be using it.

thanks!

And here is the Delphi Code FYI: Logo is a Global function elsewhere which returns the entire path and file name procedure LoadTheLogoNew(var aXLS: TXLSReadWriteII4; c1, r1, c2, r2, ts : Integer); var xlSht : TSheet; msoPict : TMSOPicture; picID : integer; drwPict : TDrwPicture; begin if UpperCase(E...

I deleted the VB code since I can not verify it's workability, but one could easily create a VB Code from the Delphi code a lot easier then from the C++ code; After using the online C++ to VB converter, it was easier to convert to Delphi from the VB code. http://converter.telerik.com <------ tries t...

Now if some one can convert that to Either Delphi code or Visual Basic code....

I need help with this as well. And I see there is no answer yet.

finally got it

colrow1 := ColRowToRefStr(holdcol1, row, false, false);
colrow2 := ColRowToRefStr(holdcol2, row, false, false);
ref := colrow1 + '/' + colrow2;
XLS.Sheets[0].AsFormula[col, row] := ref;