Firstly, you'll need to ensure :

1. You are on the min version of Analyse 5.5.3 and + to run automated scripts.

2.  You have a 📥 topline clone (e.g. C:\ProgramData\Askia\Clones\TPforScripts.xml)

Test your script

Go to the top menu, 'Automation' and create a new script:

Copy and paste the following 📥 script

(or double click on the below image to download it):

Save it and add it in your Script directory

You'll obtain the following output :

Create a portfolio

(by command line)

To create the portfolio automatically, you can run a  batch file from the command line using the /"automate:" parameter e.g. 

1. Analyse.exe  "c:\Qes\ex.qes" /"automate:c:\Scripts\CloneScript.txt"

Export to excel

(Via the command line)

Add the following command line to your batch file:

1.Analyse.exe "c:\Qes\ex.qes" /"automate:c:\Scripts\CloneScript_tag.txt"
2.Analyse.exe "C:\Qes\ex.qes" /exportexcel /"portfolio:C:\Qes\Tp.xml" /"output:C:\Qes\result.xls" /"logfile:C:\Qes\Log.txt"

You can generate 1 sheet by chapter (check your options in the Tools menu bar, Excel export)

You are welcome! Enjoy!!!