AdvGridWorkbook programmatically

Hello!

How can i access single cell in AdvGridWorkbook so i can fill it completly programmatically, cell by cell? I tried  AdvGridWorkbook.Grid.Cells[i,j]:=value but it retourn empty grid on export.

Witch method should I use?




What export method do you use?

I've retested this here with a default TAdvGridWorkbook on the form with the code:
begin
  AdvGridWorkbook1.Grid.Cells[1,1] := 'test';
end;
and this fills the grid cell as expected.

My bad, i didnt set Row count And Column Count in code. So nothing vas visible.