XLSSpreadSheet Can it search in a sheet?

[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?

[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;

[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;