FAQ & Knowledge Base

Herzlich Willkommen in unserer Wissensdatenbank. Nutzen Sie die Suchfunktion oder durchstöbern Sie unsere Kategorien, um Antworten auf Ihre Fragen zu erhalten.

Kategorien: TreeSize | Alle Kategorien anzeigen

Die folgenden Inhalte sind leider nicht auf Deutsch verfügbar.

Automate Excel report

Frage / Problem

I want to export my scan results into an Excel spreadsheet. The whole process of scan invoking and exporting should be automatic. How can I do this?

Antwort / Lösung

You can use command line paramaters to start a scan and automatically generate an Excel report.

For example:

You want to scan the drive C:\ and your installation directory of TreeSize is
"C:\Programs\JAMSoftware\TreeSize\TreeSize.exe"
Your directory for your reports is
"D:\My Company\Reports\TREESIZE\sheet1.xlsx",
with "sheet1.xlsx" as your sheet for reports.

In this case, the full command line would look like this: "C:\Programs\JAMSoftware\TreeSize\TreeSize.exe" /EXCEL "D:\MyCompany\Reports\TREESIZE\sheet1.xlsx" /SCAN "C:\"

Paths containing directory names with spaces must be embraced by double quotes, so it is a consistent and careful habit to double-quote all paths to avoid problems. Instead of retyping the command line every time you want to scan, you can save it into a .bat-file and start it by double-clicking.