Get Cell Value or Data from Spreadsheet

[Wissem_B]

Hi there,
i used in my Project a Spreadsheet , i want to read the Data from Cells but i don't know how? is it Possible to solve that without export/Import solution?
thank you for your help.

[Alexander Bulei]

Hi Wissem_B,

is it Possible to solve that without export/Import solution?

Unfortunately, there is no way

Best Regards.

[Alexander Bulei]

Hi Wissem_B,

You can get the cell values by using the BrowserParams.

Example:

Code: Select all

procedure TFORMTEST.IWAppFormCreate(Sender: TObject);
begin
  with IWCGJQButton1.JQButtonOptions.OnClick.BrowserParams.Add do
  begin
    ServerName:= 'cellval';
    BrowserScript:= IWCGJQSpreadSheet1.jsGetCellValue(2,2,-1);
  end;
end;

Best Regards.

[Wissem_B]

hi,
thank you very much i will try it
best regard