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.