Corporate Taxprep 2022.1.2

Modify the Import and Export Settings of Excel Files

Corporate Taxprep allows you to modify the settings used during .xls* file import and export.

To modify these settings, proceed as follows:

  1. On the Tools menu, click Options and Settings.
  2. Under Import/Export, click XLS* Files .
  3. In the Worksheet box, enter the number of the worksheet used during the import or export.
    In the Position area:
    • in the Cell ID column box, enter the position of the column which will contain the cell number;
    • in the Value column box, enter the position of the column which will contain the cell value;
    • in the Old value column box, enter the position of the column which will contain the cell value from last year;
    • in the Cell name column box, enter the position of the column which will contain the cell name;
    • in the First row box, enter the line number where the first imported (or exported) data is to be entered; and
    • in the Last row box, enter the line number where the last imported data is to be entered (this step is optional).
  1. Click OK.