The goal of importation of one-time-dates from an Excel file is to :
•Import the specific date when it occurs.
To import One-Time-Dates from an Excel file, make sure your Excel file contains the information Q++Studio expects in the columns where it expects to find it :
•Column A : Date.
•Column B : Abbreviation.
•Column C : Symbol.
•Column D-E-F-... : One-Time-Date name (see the import dialog for more info).
When entering dates into your Excel file, make sure you enter a date as 1/1/2001 or 3-5-2001, not as free text. To be sure of using the proper format, make a copy of the Excel template file
located in your c:\qpp\Import\ folder, and use that copy to enter data (or do a cut/paste from another Excel file into that one.
Then use the More... button of the Holidays Manager, and select the Import from MS-Excel menu item.
The Data Import From Excel dialog then appears:
|1.||Select an Excel file (the dialog accepts both the XLSX file extension as well as the traditional XLS file extension).|
|2.||Use the preview to tell Q++Studio at which line to start the import (make sure you do not include title headers in the rows selected for import).|
|3.||IMPORTANT : If the dates you see in the preview are 4 years earlier than what you are expecting to see, then this is due to the way the Excel file was saved on the Macintosh. Click here for more information.|
|4.||Decide if you want to import the contents of only one specific column, or of all non-blank columns (in which case you should specify the text to be used to separate each column's text).|
|5.||Click on the IMPORT button.|
Once importation is complete, a dialog will come up informing you of the number of recurring holidays successfully imported.