FAQ & Knowledge Base

Welcome to our Knowledge Base. Search or browse through the topics below to find answers to your questions.

Categories: TreeSize | Show all categories

Automate Excel report

Question / 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?

Answer / Solution

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.