Options Menu
Change language
This menu item allows you to change the display language used by ExcelPipe.
Start processing
Identical in function to the [Start] button in the lower half of the window.
Import Search/Replace List
Imports a list of search/replace pairs from Excel (.XLS files), Comma Separated Value (.CSV files) or Tab-delimited (.TAB files) formats. Note: Loading large lists from Excel is very slow - export your list to .CSV or .TAB and then import that instead.
You can import Unicode or special character replacements from Excel using this item. Note that some special characters may not display correctly - but the replacement will still occur correctly. The special characters are usually shown as question marks or hollow rectangles.
Columns required by the Import process:
| Find what |
Replace with |
Look in |
Match Case |
Match entire cell contents |
| The text to find. |
The text to replace it with. |
0 - Cells - look in each cell
1 - Hyperlink addresses - look inside hyperlink addresses. To change the displayed text, use the 'Cells' option above as well
2 - Shapes - inside the text of shapes and grouped shapes
3 - Headers - search inside the left, centre and right header of each sheet
4 - Footers - search inside the left, centre and right footer of each sheet
5 - Built in properties - inside Subject, Title, Author etc fields
6 - Custom properties - inside custom properties defined by the user
7 - Links (OLE and DDE) - inside links to external documents and databases. |
TRUE to match case
FALSE (default) to find both upper and lower case. |
TRUE to match only an entire cell
FALSE (default) to match anywhere inside a cell. |
| e.g. |
| تنانتانتا نتانتاهعغهع |
יעיעלחילחילח |
3 |
FALSE |
FALSE |
Export Search/Replace List
This option exports all of the search/replace terms in the grid to a new file, in Excel (.XLS files), Comma Separated Value (.CSV files) or Tab-delimited (.TAB files) formats.
This is useful if you've modified the search/replace pairs or search options and need to export them back to a file. It's also very handy for prototyping the information required to generate an Import file (see the option above).
|
