RasterEdge XDoc.Excel for .NET allows C# programmers to integrate text search functionality into their Excel document management application. To be specific, using mature C#.NET APIs, programmers can achieve following aspects.
- Easy to search and find text content and get its location details
- Allow to search defined Excel file page or the whole document
- Support search Excel file with various search options, like whole Excel, ignore case, match string, etc.
The following C# coding example illustrates how to perform Excel text searching function in your .NET project, including setting search option, creating search result, and saving the result.
internal static void TestSearch(String fileName, String matchString, String cacheFile)
{
// Set search options.
RESearchOption option = new RESearchOption();
option.SetMatchString(matchString);
option.WholeWord = true;
option.IgnoreCase = true;
option.ContextExpansion = 30;
// It will create a cach file if your PDF document is never been searched before.
if (!File.Exists(fileName))
{
BaseDocument document = getBaseDocument(TestFilePath.InputFilePath + fileName);
document.CacheSearchInfo(TestFilePath.InputFilePath + cacheFile);
}
// Create search result.
SearchResult sResult = new SearchResult();
// Search and store the result in the entity of search structure.
BaseDocument.Search(TestFilePath.InputFilePath + cacheFile, option, sResult);
}
private static BaseDocument getBaseDocument(String filePath)
{
BaseDocument document = null;
if (filePath.EndsWith(".pdf"))
document = new PDFDocument(filePath);
else if (filePath.EndsWith(".docx"))
document = new DOCXDocument(filePath);
else if (filePath.EndsWith(".xlsx"))
document = new XLSXDocument(filePath);
else if (filePath.EndsWith(".pptx"))
document = new PPTXDocument(filePath);
else
{}
return document;
}
