Search Through Microsoft Excel Speadsheets to Find Text, Keywords, Phrases or Regexp Matches
What You Can Do with PowerGREP
 |
With PowerGREP, you can quickly search for a piece of information through files and folders on your computer, including Microsoft Excel spreadsheets (XLS files). Simply type in a keyword or phrase in the Search box, select which folder PowerGREP should go through and which types of files are of interest. When you click the search button, PowerGREP will present you with a list of Excel spreadsheets and other files in which the text you entered in the search box was found. The list will show one line of context for each match. You can instantly inspect the entire context by double-clicking on the match in the results.
When you do not know in advance exactly what you are looking for, PowerGREP's rich regular expression support allows you to search for virtually anything by specifying the form of what you want, and let PowerGREP find the actual text matching that form.
With PowerGREP's collect data feature, you can extract data from Excel spreadsheets and other files and automatically save the extracted data into one or more new text files. You can group identical matches together and count them, producing informative statistics.
How PowerGREP Handles XLS Files
Microsoft Excel uses a proprietary file format to store its spreadsheets. There is no official documentation available. Because the file format is very complex, most applications that can handle Excel spreadsheets rely on Microsoft Excel itself.
Since PowerGREP needs to be able to search through a large number of files in a reasonable amount of time, running Microsoft Excel in the background is not an option. Instead, PowerGREP will open the XLS file directly, without the help of Excel, and extract the text from the file. Text formatting, formulas, images and other special content are ignored. Only the basic layout of workbooks, columns and rows is preserved. The extracted text is what PowerGREP searches through. When inspecting search matches inside PowerGREP, the built-in file editor will show the plain text version that PowerGREP actually searched through. You can always use the Edit button's drop-down menu to open the file in Microsoft Excel.
PowerGREP is not able to modify Excel spreadsheets. You cannot search-and-replace through XLS files using PowerGREP.
See PowerGREP in Action
There are four ways to see PowerGREP in action:
- Just sit back and watch the self-running demonstrations in your web browser.
- Take a look at the screen shots.
- Download the free evaluation version, which comes with full documentation.
- Buy PowerGREP now and try it risk-free with our 90-day unconditional money-back guarantee.
Read more about PowerGREP's features and benefits.
The Most Powerful GREP Tool for Windows
When to Use
Unique Abilities | All-in-One Tool
Widely Compatible
|
Page URL: http://www.powergrep.com/excel.html | Copyright © 2002-2007 Jan Goyvaerts. |