Page 1 of 1

Get Cell Value or Data from Spreadsheet

PostPosted: 11 Feb 2016 10:09
by 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.

Re: Get Cell Value or Data from Spreadsheet

PostPosted: 11 Feb 2016 11:28
by Alexander Bulei
Hi Wissem_B,

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


Unfortunately, there is no way :(

Best Regards.

Re: Get Cell Value or Data from Spreadsheet

PostPosted: 12 Feb 2016 15:28
by 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.

Re: Get Cell Value or Data from Spreadsheet

PostPosted: 15 Feb 2016 13:50
by Wissem_B
hi,
thank you very much i will try it :)
best regard