18 feb 2016
ArExcelReport version 2.4
24 jan 2016
ARWordReport version 2.3
Simple report templates
creation direct in MS Excel using its full formatting abilities.
MS Excel 97(SP2).. Excel 2013SP1.
ArExcelReport is freeware without source for non-commercial
See download section.
Note regarding MS Office Excel 2010 and MS Office Excel 2013.
(in case you got some Excel security messages during report generation, that should not happen with default ArExcelReport settings)
MS Office Excel 2010 and MS Office Excel 2013 allow external applications (which utilize COM automation) to open files from Office trusted locations only.
Since ARExcelReport make copy of each report template file in ARExcelReport.TemporaryPath folder before processing (initially this scenario was used to prevent multiuser/multithread simultaneous access to single template file), you should add your ARExcelReport.TemporaryPath to Excel`trusted locations list (or assign existing trusted location to ARExcelReport.TemporaryPath property). This single intermediate ARExcelReport folder make possible to use single trusted location to open report templates actually located across multiple different folders/network drives.
You can also use small OfficeSecurityTweaker utility to modify MS Office Excel Trusted Locations list on end-user computer. It may be used to add even Windows temporary path (%TEMP%) to MS Office Excel trusted locations list (while it is not possible from standard Excel settings UI).
OfficeSecurityTweaker supports command-line mode so you can include it into your setup projects.
OfficeSecurityTweaker Command-line example (see Readme.txt inside zip-archive):
OfficeSecurityTweaker.exe -app Word,Excel -path "%LOCALAPPDATA%\MyApp" -sub -all -descr "MyApp folder" -msg "Folder was added to Office Trusted locations"