XLSSpreadSheet Can it search in a sheet?
Posted: Thu Jan 12, 2017 9:18 am
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?
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;