How can I import tables of n and k data and use them in SCOUT or CODE?

Open the list of materials and generate a new object of type ‘Imported dielectric function’.

If you have a text file with 3 columns (like wavelength, n, k or energy, n, k) open the new object and execute the local command ‘Import’. In the file dialog you should set the file type to ‘n and k from data table (x,n,k)’. You will be asked to specify the spectral unit (nm, eV, 1/cm, …). After the data import you should use the menu command ‘Property/Refractive index’ to visulize the imported data.
If you have an Excel table of the data (a data block with columns of the spectral position, n and k), you can import the Excel table into the workbook. In the object tree view, right-click the workbook and use the ‘File/Open’ command of the workbook (or copy & paste from Excel directly). Select the cell in the workbook where you want to start reading the data – this should be the first spectral position (usually the first wavelength, wavenumber or energy value). Go back in the treeview to the material object that wants to read the data (right click on the corresponding treeview line) and execute the lcoal menu command ‘Workbook/ Import x,n,k’ of the material object.

When you are finished importing the data and you have adjusted the graphics of the object (set an appropriate title, …) you can enter the new material into the database. First right-click the treeview item ‘Optical constant database’ and then drag&drop the material from the treeview into the database window on the right side.