I use TRNSYS17 and I manage to get my results on excel via Type65 (Output/Online Plotter/Online Plotter With File/User-Supplid Units). Then, by double cliking in the type you can enter the path of your excel files in "External Files". I hope it can help,