How to get X1 to index numbers in Excel spreadsheets

You've got questions? We think we have some answers!

Moderator: Mods

How to get X1 to index numbers in Excel spreadsheets

Postby Kenward » Fri Mar 07, 2008 2:38 am

After much wailing and gnashing of teeth over this issue, it turns out that you can persuade X1 to index Excel spreadsheets in a way that lets you search for numbers. You just have to perform a minor trick that involves the IFilter technology that is behind a lot of indexing.

Here is the word, slightly edited, "from the horse's mouth":

In its default state, X1 can index Excel files that have cells formatted using the general format and not cells that have been formatted using the number or currency format (for example).

However, X1 has the ability to utilize IFilters. Installing MS Office, should also install a related IFilter for Excel. Telling X1 to use the MS Office IFilter may solve this issue; however, because there are different versions of the IFilter installed, this solution may not always work.

This is the IFilter in question and its location:

c:\windows\system32\offfilt.dll
(X1 users have reported finding various versions of offfilt.dll)


To tell X1 to index your Excel files using the installed iFilter, perform these steps:

<OL><LI>In X1, go to Tools > Options > Files > More Indexing Options > Specify File Types

<LI>In the "Additionally index all files with these extensions:" dialog, enter: XLS

<LI>Click Close, Close then OK

<LI>At this point, X1 needs to reindex the XLS files, so you've got several options:

- 4a. Move the applicable files to a new/different folder and update your file index; move the files back to the original folder and update your file index a second time

OR

- 4b. Rename the folder(s) where these XLS files reside and update your file index; rename the folder back to the original and update your file index a second time

OR

- 4c. Clear and rebuild your index - note, that rebuilding include files + emails
</OL>
Once these XLS files have been reindexed, you should then be able to perform searches against your Excel files that have cells formatted using the number/currency format (for example).

Please note: you must be running build 3377 or higher of X1 for these steps to work


As usual, please provide any feedback on whether this works for you. And feel free to suggest improvements or new ways of achieving the same task.
Last edited by Kenward on Fri Mar 07, 2008 11:52 am, edited 1 time in total.
MK
X1 Search 8.5.2 - Build 6001si (64-bit)
Windows 10 Pro 64-bit | Windows 10 Home 32-bit
No, I have nothing to do with X1, just a user since 2004.
Kenward
X1 Guru
X1 Guru
 
Posts: 4099
Joined: Tue Apr 20, 2004 2:35 am
Location: UK

Postby w0qj » Fri Mar 07, 2008 9:10 am

Thanks to Kenward for yet another great "Sticky"!

The original source quoted was based on MS Office'2003:
http://forums.x1.com/viewtopic.php?t=3602&start=0

***If anyone finds anymore tips on this, or find any discrepency, please also state what version of Office and Windows are you using. Thanks!
Rgds / Mr. Wong

"It is what X1 can do with the information found that is important."
w0qj
X1 Guru
X1 Guru
 
Posts: 1183
Joined: Wed Jun 16, 2004 3:53 am
Location: Hong Kong


Return to Questions and Answers

Who is online

Users browsing this forum: No registered users and 20 guests