Defining and updating automatic imports
Defining imports
All XLSior automatic imports are defined on special worksheets called import sheets. Any sheet in your workbook whose name begins with X~Imp is assumed to be an import sheet.
You can add a new import sheet to your workbook by using the command XLSior > Import > Add Import Sheet. The command XLSior > Import > Add Import Sheets allows you to choose the number of sheets to add.
The new sheet (or sheets) will be added before the currently active sheet, and will be called something like X~Imp1, depending on the sheets that are already present in the workbook. You can rename the sheet to anything you like as long as the new name starts with X~Imp. The list of sheets on sheet X~Sheets will be updated each time you add an import sheet.
Import sheets are always protected, and cannot be unprotected by the user. The cells that you can edit are coloured light green.
You can specify one range from another workbook to be imported onto each import sheet. You should enter the workbook name, the name of the worksheet on which the range is to be found, and the range definition in the three cells at the top of the sheet.
The workbook name should usually include the full path, for example D:\Data\workbooks\source.xls. If it does not have a drive letter at the beginning it will be interpreted as a path starting in the same folder as the importing workbook. For example, if you are importing into workbook D:\Data\workbooks\destination.xls, and specify the workbook name as others\source.xls, XLSior will look for D:\Data\workbooks\others\source.xls.
The sheet name should be entered as a text string, and should refer to a sheet in the source workbook.
The range definition should be either a range of cells, such as A5:P122, or the name of named range to be found on the specified sheet. It is better practice to use a named range. The range definition should be entered as a text string.
The range must consist of a single area, and must have fewer than 65518 rows.
An easy way of entering this information is to use the XLSior > Import > Set Import Range command. A dialog will appear, inviting you to enter the range.
You can select any range in any open workbook in the usual way, using point and click, or you can type a range reference into the dialog. When you click OK the details of the range you selected will be entered in the three cells at the top of the import sheet.
You should also enter a description of what is being imported in the box to the right. This provides useful documentation to other users.
It is also good practice to make sure that the imported range includes information that states what the information is and on what basis it was calculated.
Updating imports
You can update a single import sheet by using the XLSior > Import > Update this Import Sheet command. This command will copy the values from the specified range to the area of the import sheet below the heading that says "Area below this row is imported information". It will also update the information just above that row that states when the last import was performed and what its source was.
You can update all import sheets in the workbook by using the XLSior > Import > Update all Import Sheets command.
You cannot update import sheets in a shared workbook.