Page 1 of 1

XLSSpreadSheet Can it search in a sheet?

Posted: Thu Jan 12, 2017 9:18 am
by User1
Hello. I have just downloaded XLSSpreadSheet. I can't find a way to search within sheets. Ctrl+F won't work. Can it search the document?

Re: XLSSpreadSheet Can it search in a sheet?

Posted: Mon Jan 16, 2017 8:26 am
by larsa
Hello

Use:

Code: Select all

  FXSS.XLSSheet.BeginFindText;

  while FXSS.XLSSheet.FindText('MyFindText') do begin
    FXSS.XLSSheet.GetFindData(Col,Row,TextPos,Text);

    ShowMessage('Found at ' + ColRowToRefStr(Col,Row) + ': ' + Text);
  end;

Re: XLSSpreadSheet Can it search in a sheet?

Posted: Mon Nov 22, 2021 6:28 pm
by hugvis
Hi
This is outdated. How is this done in Delphi 10.3.3 ?

FXSS.XLSSheet.BeginFindText;

while FXSS.XLSSheet.FindText('MyFindText') do begin
FXSS.XLSSheet.GetFindData(Col,Row,TextPos,Text);

ShowMessage('Found at ' + ColRowToRefStr(Col,Row) + ': ' + Text);
end;