The Data Import from Excel dialog is the base dialog used to import different types of data (recurring holidays, one-time-dates, saints/namedays, saints/namedays exceptions and slogans) from an Excel file.

 

For any type of data being imported, the use of this dialog is the same:

 

1.Use the top half of the dialog to select an Excel file (the dialog accepts both the XLSX file extension as well as the traditional XLS file extension).

2.As soon as a file is selected, a preview of it is displayed in the bottom half of the dialog.

3.The preview's headers display the information that Q++Studio expects to find in each column.

4.Make sure the information in the selected Excel file matches.

5.Use the Start importing on row number option to set the line number (or row number) at which the import should start.

6.As you change this value in the spinner, the lines that will be imported are highlighted, while the lines above remain un-selected (see screenshot above).

7.If your Excel file contains a first row with titles, make sure that row is not included in the rows to be imported.

8.Use the Import only one column/Import all columns checkbox to determine 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).

9.Click on the IMPORT button.

 

Once importation is complete, a dialog will come up informing you of the number of recurring holidays successfully imported.

 

For more details relative to the importation of specific types of data, see the corresponding topics, each specifically related to the importation from Excel of a particular type of data: recurring holidays, one-time-dates, saints/namedays, saints/namedays exceptions and slogans.

 

---

Topic 170300, last updated on 18-Jan-2022