Tutorial: Index the contents of Excel files

To be able to index the contents of .xlsx files you must create a text extractor that gets the data from published .xlsx files and adds it to a search index.

Perform the following:

1. Download and extract the text-extractor-assemblies.zip file and add to your project’s bin folder the following assemblies:
   • Telerik.Windows.Documents.Spreadsheet.dll
   • Telerik.Windows.Documents.Spreadsheet.FormatProviders.OpenXml.dll
   • Telerik.Windows.Documents.Core.dll
2. Add a reference to each of the assemblies.
3. Build the project and open it.
4. Add the XlsxTextExtractor class to your project.
5. Use the following steps that guide you through the implementation of the class:
   1. Inherit from ITextExtractor.
   2. Define the private members.
   3. Get the mime type.
   4. Implement the GetText method of XlsxTextExtractor class.
   5. Implement the private method ExecuteDocumentAction.

      Use the following code sample:

6. In Sitefinity CMS backend, navigate to Administration » Settings » Advanced » DocumentService » ExtractorSettings » Create new.
7. In MimeType field, enter application/vnd.openxmlformats-officedocument.spreadsheetml.sheet
8. In ExtractorType field, enter SitefinityWebApp.XlsxTextExtractor, SitefinityWebApp
9. Save your changes and restart the application.
10. Create a search index for documents and reindex it.
    For more information, see Administration: Create search indexes.