Why doesn't the JTSMon Visualizer handle bigger data sets even when I use Excel 2010 and above ?
I get an "Runtime Error 1004 Excel cannot insert the sheets into the destination workbook, because it contains fewer rows and columns" when I have JTSMon data with more than 255 samples (about a week and a half of hourly data). This happens even when I am using Microsoft Excel 2007 or above which can handle more columns of data.
One answer
The problem is that the JTSMon Visualizer is packaged as an "xls" file that is compatible with Excel 2003 and above so by default it creates a new output spreadsheet with the 255-column limit.
This has been fixed under workitem 326340 "JTSMon: Runtime error 1004 on creating workbook with Excel 2010 and above" by saving the new file out and rereading it back with the larger data limit.
The modified JTSMon VIsualizer is included in an updated version of the main JTSMon package on the deployment wiki. Just redownload the main zip package ( https://jazz.net/wiki/pub/Deployment/JTSMonFAQ/JTSMon_5.0.0_RTC4.0.2GA.zip) and the updated version of the Visualizer is included. The new Visualizer is labeled with a September 29 2014 version even though the main package has not been updated otherwise.
This has been fixed under workitem 326340 "JTSMon: Runtime error 1004 on creating workbook with Excel 2010 and above" by saving the new file out and rereading it back with the larger data limit.
The modified JTSMon VIsualizer is included in an updated version of the main JTSMon package on the deployment wiki. Just redownload the main zip package ( https://jazz.net/wiki/pub/Deployment/JTSMonFAQ/JTSMon_5.0.0_RTC4.0.2GA.zip) and the updated version of the Visualizer is included. The new Visualizer is labeled with a September 29 2014 version even though the main package has not been updated otherwise.