XLSSpreadSheet Can it search in a sheet?

Questions and answers on how to use XLSSpreadSheet.
Post Reply
User1
Posts: 1
Joined: Thu Jan 12, 2017 9:12 am

XLSSpreadSheet Can it search in a sheet?

Post 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?
larsa
Site Admin
Posts: 926
Joined: Mon Jun 27, 2005 9:30 pm

Re: XLSSpreadSheet Can it search in a sheet?

Post 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;
Lars Arvidsson, Axolot Data
hugvis
Posts: 7
Joined: Mon Nov 22, 2021 6:23 pm

Re: XLSSpreadSheet Can it search in a sheet?

Post 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;
Post Reply