Get Cell Value or Data from Spreadsheet

Posted:
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

Posted:
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

Posted:
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

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