taki baaaaaardzo stary kawałek kodu mam do tego, może Ci się przyda :
procedure XlsWriteCellNumber(XlsStream: TStream; const ACol, ARow: Word;
const AValue: Double);
const
{$J+}
CXlsNumber: array[0..4] of Word = ($203, 14, 0, 0, 0);
{$J-}
begin
CXlsNumber[2] := ARow;
CXlsNumber[3] := ACol;
XlsStream.WriteBuffer(CXlsNumber, SizeOf(CXlsNumber));
XlsStream.WriteBuffer(AValue, 8);
end;
procedure XlsWriteCellLabel(XlsStream: TStream; const ACol, ARow: Word;
const AValue: string);
var
L: Word;
const
{$J+}
CXlsLabel: array[0..5] of Word = ($204, 0, 0, 0, 0, 0);
{$J-}
begin
L := Length(AValue);
CXlsLabel[1] := 8 + L;
CXlsLabel[2] := ARow;
CXlsLabel[3] := ACol;
CXlsLabel[5] := L;
XlsStream.WriteBuffer(CXlsLabel, SizeOf(CXlsLabel));
XlsStream.WriteBuffer(Pointer(AValue)^, L);
end;
function SaveAsExcelFile(AGrid: TJvDBUltimGrid; AFileName,Opis: string): Boolean;
const
{$J+} CXlsBof: array[0..5] of Word = ($809, 8, 00, $10, 0, 0); {$J-}
CXlsEof: array[0..1] of Word = ($0A, 00);
var
FStream: TFileStream;
I, J: Integer;
P:Pointer;
begin
Result := False;
FStream := TFileStream.Create(PChar(AFileName), fmCreate or fmOpenWrite);
try
CXlsBof[4] := 0;
FStream.WriteBuffer(CXlsBof, SizeOf(CXlsBof));
XlsWriteCellLabel(FStream,0,0,litery(Opis,polskieznakiXLS) );
for i := 0 to AGrid.Columns.Count - 1 do
begin
if Pos('_',AGrid.Columns.Items[i].FieldName)<>1 then
XlsWriteCellLabel(FStream, i, 1, AGrid.Columns.Items[i].Title.Caption);
end;
AGrid.DataSource.DataSet.DisableControls;
p:=AGrid.DataSource.DataSet.GetBookmark;
AGrid.DataSource.DataSet.First;
j:=2;
while not AGrid.DataSource.DataSet.Eof do
begin
for i := 0 to AGrid.Columns.Count - 1 do
if Pos('_',AGrid.Columns.Items[i].FieldName)<>1 then
begin
if (AGrid.Columns.Items[i].Field.DataType in [ftString,ftWideString,ftDateTime,ftDate,ftMemo]) then
XlsWriteCellLabel(FStream, I, J, trim(AGrid.Columns.Items[i].Field.AsString) )// DataSource.DataSet.Fields[i].AsString
else
XlsWriteCellNumber(FStream,I,J,AGrid.Columns.Items[i].Field.AsFloat);
end;
inc(j);
AGrid.DataSource.DataSet.Next;
end;
FStream.WriteBuffer(CXlsEof, SizeOf(CXlsEof));
Result := True;
finally
FStream.Free;
AGrid.DataSource.DataSet.GotoBookmark(p);
AGrid.DataSource.DataSet.FreeBookmark(p);
AGrid.DataSource.DataSet.EnableControls;
end;
end;