Md Faruk Hossen Khan Report post Posted July 24, 2020 (edited) Hi, XLS export is not working in our application( We used Fusion chart version: 3.11.3) in Exact. Only partial data is being exported. I debugged and found that the getCSVData method is returning partial data. Moreover, the getJson and GetXmlData methods are returning full data. Attached is the code extract from the project and the exported file(Xls). The project extract is very simple, you can see my code here as well : <html xmlns="http://www.w3.org/1999/xhtml"> <head runat="server"> <title></title> <script type="text/javascript" src="Scripts/jquery-3.4.1.js"></script> <script type="text/javascript" src="Scripts/FusionChartsXT/fusioncharts.js"></script> <script type="text/javascript" src="Scripts/FusionChartsXT/fusioncharts.gantt.js"></script> <script type="text/javascript" src="Scripts/FusionChartsXT/fusioncharts.widgets.js"></script> <script type="text/javascript"> //<![CDATA[ $(function () { FusionCharts.setCurrentRenderer('javascript'); var chart_WBSGantt = new FusionCharts("Gantt", "WBSGantt", "100%", "272", "0", "0", "", "noScale", "EN"); chart_WBSGantt.setDataXML("<chart canvasBgColor='FFFFFF' ganttLineAlpha='100' logEnabled='1' legendShadow='0' showPlotBorder='0' gridBorderAlpha='100' exportMode='client' thousandSeparator=',' showAlternateVGridColor='0' outputDateFormat='dd-mm-yyyy' canvasBorderThickness='1' showValues='1' bgcolor='ffffff' dateFormat='yyyy/mm/dd' paletteColors='5499c6,f5d249,79e7e6,eb994e,ea5fb4,75cb81,a569bd,ed5756,94bfdb,f8e187,aef1f0,f2bf90,f29bd0,a8deb0,c6a1d6,f39695,2674a8,ebbd05,32c6c4,e57816,d73497,47b656,823e9f,e14040' animation='0' imageSave='1' formatNumberScale='0' showTaskNames='1' legendBgAlpha='0' showAlternateHGridColor='0' exportAtClient='1' exportEnabled='1' exportAction='download' decimalSeparator='.' showBorder='0' flatScrollBars='1' taskBarFillMix='{color}' exportFileName='Graph' showShadow='0' ganttLineColor='CCCCCC' ganttPaneDuration='3' ganttPaneDurationUnit='m' canvasBorderColor='c6c6c6' gridBorderColor='C6C6C6' exportAtClientSide='1' plotGradientColor='' legendBorderAlpha='0' baseFont='Arial' exportFormats='PNG=Export as PNG|JPG=Export as JPG|PDF=Export as PDF|SVG=Export as SVG|XLS=Export as XLS'><categories valign='bottom' fontColor='232323' fontSize='12' align='center' color='000000' font='Arial' headerBgColor='E5E5E5' bgColor='E5E5E5'><category start='2020/07/01 00:00:00' end='2020/07/31 00:00:00' name='Jul 2020' /><category start='2020/08/01 00:00:00' end='2020/08/31 00:00:00' name='Aug 2020' /><category start='2020/09/01 00:00:00' end='2020/09/30 00:00:00' name='Sep 2020' /><category start='2020/10/01 00:00:00' end='2020/10/31 00:00:00' name='Oct 2020' /><category start='2020/11/01 00:00:00' end='2020/11/30 23:59:00' name='Nov 2020' /></categories><categories headerBgColor='E5E5E5' bgColor='E5E5E5' align='center' valign='bottom' fontColor='232323' font='Arial' fontSize='10' color='000000'><category start='2020/07/01 00:00:00' end='2020/07/05 00:00:00' name='Week 27' /><category start='2020/07/06 00:00:00' end='2020/07/12 00:00:00' name='Week 28' /><category start='2020/07/13 00:00:00' end='2020/07/19 00:00:00' name='Week 29' /><category start='2020/07/20 00:00:00' end='2020/07/26 00:00:00' name='Week 30' /><category start='2020/07/27 00:00:00' end='2020/08/02 00:00:00' name='Week 31' /><category start='2020/08/03 00:00:00' end='2020/08/09 00:00:00' name='Week 32' /><category start='2020/08/10 00:00:00' end='2020/08/16 00:00:00' name='Week 33' /><category start='2020/08/17 00:00:00' end='2020/08/23 00:00:00' name='Week 34' /><category start='2020/08/24 00:00:00' end='2020/08/30 00:00:00' name='Week 35' /><category start='2020/08/31 00:00:00' end='2020/09/06 00:00:00' name='Week 36' /><category start='2020/09/07 00:00:00' end='2020/09/13 00:00:00' name='Week 37' /><category start='2020/09/14 00:00:00' end='2020/09/20 00:00:00' name='Week 38' /><category start='2020/09/21 00:00:00' end='2020/09/27 00:00:00' name='Week 39' /><category start='2020/09/28 00:00:00' end='2020/10/04 00:00:00' name='Week 40' /><category start='2020/10/05 00:00:00' end='2020/10/11 00:00:00' name='Week 41' /><category start='2020/10/12 00:00:00' end='2020/10/18 00:00:00' name='Week 42' /><category start='2020/10/19 00:00:00' end='2020/10/25 00:00:00' name='Week 43' /><category start='2020/10/26 00:00:00' end='2020/11/01 00:00:00' name='Week 44' /><category start='2020/11/02 00:00:00' end='2020/11/08 00:00:00' name='Week 45' /><category start='2020/11/09 00:00:00' end='2020/11/15 00:00:00' name='Week 46' /><category start='2020/11/16 00:00:00' end='2020/11/22 00:00:00' name='Week 47' /><category start='2020/11/23 00:00:00' end='2020/11/29 00:00:00' name='Week 48' /><category start='2020/11/30 00:00:00' end='2020/11/30 23:59:00' name='Week 49' /></categories><categories valign='bottom' fontColor='232323' fontSize='10' isBold='0' align='center' color='000000' font='Arial' headerBgColor='E5E5E5' bgColor='E5E5E5'><category start='2020/07/01 00:00:00' end='2020/07/02 00:00:00' name='Wed 1' /><category start='2020/07/02 00:00:00' end='2020/07/03 00:00:00' name='Thu 2' /><category start='2020/07/03 00:00:00' end='2020/07/04 00:00:00' name='Fri 3' /><category start='2020/07/04 00:00:00' end='2020/07/05 00:00:00' name='Sat 4' /><category start='2020/07/05 00:00:00' end='2020/07/06 00:00:00' name='Sun 5' /><category start='2020/07/06 00:00:00' end='2020/07/07 00:00:00' name='Mon 6' /><category start='2020/07/07 00:00:00' end='2020/07/08 00:00:00' name='Tue 7' /><category start='2020/07/08 00:00:00' end='2020/07/09 00:00:00' name='Wed 8' /><category start='2020/07/09 00:00:00' end='2020/07/10 00:00:00' name='Thu 9' /><category start='2020/07/10 00:00:00' end='2020/07/11 00:00:00' name='Fri 10' /><category start='2020/07/11 00:00:00' end='2020/07/12 00:00:00' name='Sat 11' /><category start='2020/07/12 00:00:00' end='2020/07/13 00:00:00' name='Sun 12' /><category start='2020/07/13 00:00:00' end='2020/07/14 00:00:00' name='Mon 13' /><category start='2020/07/14 00:00:00' end='2020/07/15 00:00:00' name='Tue 14' /><category start='2020/07/15 00:00:00' end='2020/07/16 00:00:00' name='Wed 15' /><category start='2020/07/16 00:00:00' end='2020/07/17 00:00:00' name='Thu 16' /><category start='2020/07/17 00:00:00' end='2020/07/18 00:00:00' name='Fri 17' /><category start='2020/07/18 00:00:00' end='2020/07/19 00:00:00' name='Sat 18' /><category start='2020/07/19 00:00:00' end='2020/07/20 00:00:00' name='Sun 19' /><category start='2020/07/20 00:00:00' end='2020/07/21 00:00:00' name='Mon 20' /><category start='2020/07/21 00:00:00' end='2020/07/22 00:00:00' name='Tue 21' /><category start='2020/07/22 00:00:00' end='2020/07/23 00:00:00' name='Wed 22' /><category start='2020/07/23 00:00:00' end='2020/07/24 00:00:00' name='Thu 23' /><category start='2020/07/24 00:00:00' end='2020/07/25 00:00:00' name='Fri 24' /><category start='2020/07/25 00:00:00' end='2020/07/26 00:00:00' name='Sat 25' /><category start='2020/07/26 00:00:00' end='2020/07/27 00:00:00' name='Sun 26' /><category start='2020/07/27 00:00:00' end='2020/07/28 00:00:00' name='Mon 27' /><category start='2020/07/28 00:00:00' end='2020/07/29 00:00:00' name='Tue 28' /><category start='2020/07/29 00:00:00' end='2020/07/30 00:00:00' name='Wed 29' /><category start='2020/07/30 00:00:00' end='2020/07/31 00:00:00' name='Thu 30' /><category start='2020/07/31 00:00:00' end='2020/08/01 00:00:00' name='Fri 31' /><category start='2020/08/01 00:00:00' end='2020/08/02 00:00:00' name='Sat 1' /><category start='2020/08/02 00:00:00' end='2020/08/03 00:00:00' name='Sun 2' /><category start='2020/08/03 00:00:00' end='2020/08/04 00:00:00' name='Mon 3' /><category start='2020/08/04 00:00:00' end='2020/08/05 00:00:00' name='Tue 4' /><category start='2020/08/05 00:00:00' end='2020/08/06 00:00:00' name='Wed 5' /><category start='2020/08/06 00:00:00' end='2020/08/07 00:00:00' name='Thu 6' /><category start='2020/08/07 00:00:00' end='2020/08/08 00:00:00' name='Fri 7' /><category start='2020/08/08 00:00:00' end='2020/08/09 00:00:00' name='Sat 8' /><category start='2020/08/09 00:00:00' end='2020/08/10 00:00:00' name='Sun 9' /><category start='2020/08/10 00:00:00' end='2020/08/11 00:00:00' name='Mon 10' /><category start='2020/08/11 00:00:00' end='2020/08/12 00:00:00' name='Tue 11' /><category start='2020/08/12 00:00:00' end='2020/08/13 00:00:00' name='Wed 12' /><category start='2020/08/13 00:00:00' end='2020/08/14 00:00:00' name='Thu 13' /><category start='2020/08/14 00:00:00' end='2020/08/15 00:00:00' name='Fri 14' /><category start='2020/08/15 00:00:00' end='2020/08/16 00:00:00' name='Sat 15' /><category start='2020/08/16 00:00:00' end='2020/08/17 00:00:00' name='Sun 16' /><category start='2020/08/17 00:00:00' end='2020/08/18 00:00:00' name='Mon 17' /><category start='2020/08/18 00:00:00' end='2020/08/19 00:00:00' name='Tue 18' /><category start='2020/08/19 00:00:00' end='2020/08/20 00:00:00' name='Wed 19' /><category start='2020/08/20 00:00:00' end='2020/08/21 00:00:00' name='Thu 20' /><category start='2020/08/21 00:00:00' end='2020/08/22 00:00:00' name='Fri 21' /><category start='2020/08/22 00:00:00' end='2020/08/23 00:00:00' name='Sat 22' /><category start='2020/08/23 00:00:00' end='2020/08/24 00:00:00' name='Sun 23' /><category start='2020/08/24 00:00:00' end='2020/08/25 00:00:00' name='Mon 24' /><category start='2020/08/25 00:00:00' end='2020/08/26 00:00:00' name='Tue 25' /><category start='2020/08/26 00:00:00' end='2020/08/27 00:00:00' name='Wed 26' /><category start='2020/08/27 00:00:00' end='2020/08/28 00:00:00' name='Thu 27' /><category start='2020/08/28 00:00:00' end='2020/08/29 00:00:00' name='Fri 28' /><category start='2020/08/29 00:00:00' end='2020/08/30 00:00:00' name='Sat 29' /><category start='2020/08/30 00:00:00' end='2020/08/31 00:00:00' name='Sun 30' /><category start='2020/08/31 00:00:00' end='2020/09/01 00:00:00' name='Mon 31' /><category start='2020/09/01 00:00:00' end='2020/09/02 00:00:00' name='Tue 1' /><category start='2020/09/02 00:00:00' end='2020/09/03 00:00:00' name='Wed 2' /><category start='2020/09/03 00:00:00' end='2020/09/04 00:00:00' name='Thu 3' /><category start='2020/09/04 00:00:00' end='2020/09/05 00:00:00' name='Fri 4' /><category start='2020/09/05 00:00:00' end='2020/09/06 00:00:00' name='Sat 5' /><category start='2020/09/06 00:00:00' end='2020/09/07 00:00:00' name='Sun 6' /><category start='2020/09/07 00:00:00' end='2020/09/08 00:00:00' name='Mon 7' /><category start='2020/09/08 00:00:00' end='2020/09/09 00:00:00' name='Tue 8' /><category start='2020/09/09 00:00:00' end='2020/09/10 00:00:00' name='Wed 9' /><category start='2020/09/10 00:00:00' end='2020/09/11 00:00:00' name='Thu 10' /><category start='2020/09/11 00:00:00' end='2020/09/12 00:00:00' name='Fri 11' /><category start='2020/09/12 00:00:00' end='2020/09/13 00:00:00' name='Sat 12' /><category start='2020/09/13 00:00:00' end='2020/09/14 00:00:00' name='Sun 13' /><category start='2020/09/14 00:00:00' end='2020/09/15 00:00:00' name='Mon 14' /><category start='2020/09/15 00:00:00' end='2020/09/16 00:00:00' name='Tue 15' /><category start='2020/09/16 00:00:00' end='2020/09/17 00:00:00' name='Wed 16' /><category start='2020/09/17 00:00:00' end='2020/09/18 00:00:00' name='Thu 17' /><category start='2020/09/18 00:00:00' end='2020/09/19 00:00:00' name='Fri 18' /><category start='2020/09/19 00:00:00' end='2020/09/20 00:00:00' name='Sat 19' /><category start='2020/09/20 00:00:00' end='2020/09/21 00:00:00' name='Sun 20' /><category start='2020/09/21 00:00:00' end='2020/09/22 00:00:00' name='Mon 21' /><category start='2020/09/22 00:00:00' end='2020/09/23 00:00:00' name='Tue 22' /><category start='2020/09/23 00:00:00' end='2020/09/24 00:00:00' name='Wed 23' /><category start='2020/09/24 00:00:00' end='2020/09/25 00:00:00' name='Thu 24' /><category start='2020/09/25 00:00:00' end='2020/09/26 00:00:00' name='Fri 25' /><category start='2020/09/26 00:00:00' end='2020/09/27 00:00:00' name='Sat 26' /><category start='2020/09/27 00:00:00' end='2020/09/28 00:00:00' name='Sun 27' /><category start='2020/09/28 00:00:00' end='2020/09/29 00:00:00' name='Mon 28' /><category start='2020/09/29 00:00:00' end='2020/09/30 00:00:00' name='Tue 29' /><category start='2020/09/30 00:00:00' end='2020/10/01 00:00:00' name='Wed 30' /><category start='2020/10/01 00:00:00' end='2020/10/02 00:00:00' name='Thu 1' /><category start='2020/10/02 00:00:00' end='2020/10/03 00:00:00' name='Fri 2' /><category start='2020/10/03 00:00:00' end='2020/10/04 00:00:00' name='Sat 3' /><category start='2020/10/04 00:00:00' end='2020/10/05 00:00:00' name='Sun 4' /><category start='2020/10/05 00:00:00' end='2020/10/06 00:00:00' name='Mon 5' /><category start='2020/10/06 00:00:00' end='2020/10/07 00:00:00' name='Tue 6' /><category start='2020/10/07 00:00:00' end='2020/10/08 00:00:00' name='Wed 7' /><category start='2020/10/08 00:00:00' end='2020/10/09 00:00:00' name='Thu 8' /><category start='2020/10/09 00:00:00' end='2020/10/10 00:00:00' name='Fri 9' /><category start='2020/10/10 00:00:00' end='2020/10/11 00:00:00' name='Sat 10' /><category start='2020/10/11 00:00:00' end='2020/10/12 00:00:00' name='Sun 11' /><category start='2020/10/12 00:00:00' end='2020/10/13 00:00:00' name='Mon 12' /><category start='2020/10/13 00:00:00' end='2020/10/14 00:00:00' name='Tue 13' /><category start='2020/10/14 00:00:00' end='2020/10/15 00:00:00' name='Wed 14' /><category start='2020/10/15 00:00:00' end='2020/10/16 00:00:00' name='Thu 15' /><category start='2020/10/16 00:00:00' end='2020/10/17 00:00:00' name='Fri 16' /><category start='2020/10/17 00:00:00' end='2020/10/18 00:00:00' name='Sat 17' /><category start='2020/10/18 00:00:00' end='2020/10/19 00:00:00' name='Sun 18' /><category start='2020/10/19 00:00:00' end='2020/10/20 00:00:00' name='Mon 19' /><category start='2020/10/20 00:00:00' end='2020/10/21 00:00:00' name='Tue 20' /><category start='2020/10/21 00:00:00' end='2020/10/22 00:00:00' name='Wed 21' /><category start='2020/10/22 00:00:00' end='2020/10/23 00:00:00' name='Thu 22' /><category start='2020/10/23 00:00:00' end='2020/10/24 00:00:00' name='Fri 23' /><category start='2020/10/24 00:00:00' end='2020/10/25 00:00:00' name='Sat 24' /><category start='2020/10/25 00:00:00' end='2020/10/26 00:00:00' name='Sun 25' /><category start='2020/10/26 00:00:00' end='2020/10/27 00:00:00' name='Mon 26' /><category start='2020/10/27 00:00:00' end='2020/10/28 00:00:00' name='Tue 27' /><category start='2020/10/28 00:00:00' end='2020/10/29 00:00:00' name='Wed 28' /><category start='2020/10/29 00:00:00' end='2020/10/30 00:00:00' name='Thu 29' /><category start='2020/10/30 00:00:00' end='2020/10/31 00:00:00' name='Fri 30' /><category start='2020/10/31 00:00:00' end='2020/11/01 00:00:00' name='Sat 31' /><category start='2020/11/01 00:00:00' end='2020/11/02 00:00:00' name='Sun 1' /><category start='2020/11/02 00:00:00' end='2020/11/03 00:00:00' name='Mon 2' /><category start='2020/11/03 00:00:00' end='2020/11/04 00:00:00' name='Tue 3' /><category start='2020/11/04 00:00:00' end='2020/11/05 00:00:00' name='Wed 4' /><category start='2020/11/05 00:00:00' end='2020/11/06 00:00:00' name='Thu 5' /><category start='2020/11/06 00:00:00' end='2020/11/07 00:00:00' name='Fri 6' /><category start='2020/11/07 00:00:00' end='2020/11/08 00:00:00' name='Sat 7' /><category start='2020/11/08 00:00:00' end='2020/11/09 00:00:00' name='Sun 8' /><category start='2020/11/09 00:00:00' end='2020/11/10 00:00:00' name='Mon 9' /><category start='2020/11/10 00:00:00' end='2020/11/11 00:00:00' name='Tue 10' /><category start='2020/11/11 00:00:00' end='2020/11/12 00:00:00' name='Wed 11' /><category start='2020/11/12 00:00:00' end='2020/11/13 00:00:00' name='Thu 12' /><category start='2020/11/13 00:00:00' end='2020/11/14 00:00:00' name='Fri 13' /><category start='2020/11/14 00:00:00' end='2020/11/15 00:00:00' name='Sat 14' /><category start='2020/11/15 00:00:00' end='2020/11/16 00:00:00' name='Sun 15' /><category start='2020/11/16 00:00:00' end='2020/11/17 00:00:00' name='Mon 16' /><category start='2020/11/17 00:00:00' end='2020/11/18 00:00:00' name='Tue 17' /><category start='2020/11/18 00:00:00' end='2020/11/19 00:00:00' name='Wed 18' /><category start='2020/11/19 00:00:00' end='2020/11/20 00:00:00' name='Thu 19' /><category start='2020/11/20 00:00:00' end='2020/11/21 00:00:00' name='Fri 20' /><category start='2020/11/21 00:00:00' end='2020/11/22 00:00:00' name='Sat 21' /><category start='2020/11/22 00:00:00' end='2020/11/23 00:00:00' name='Sun 22' /><category start='2020/11/23 00:00:00' end='2020/11/24 00:00:00' name='Mon 23' /><category start='2020/11/24 00:00:00' end='2020/11/25 00:00:00' name='Tue 24' /><category start='2020/11/25 00:00:00' end='2020/11/26 00:00:00' name='Wed 25' /><category start='2020/11/26 00:00:00' end='2020/11/27 00:00:00' name='Thu 26' /><category start='2020/11/27 00:00:00' end='2020/11/28 00:00:00' name='Fri 27' /><category start='2020/11/28 00:00:00' end='2020/11/29 00:00:00' name='Sat 28' /><category start='2020/11/29 00:00:00' end='2020/11/30 00:00:00' name='Sun 29' /><category start='2020/11/30 00:00:00' end='2020/11/30 23:59:00' name='Mon 30' /></categories><processes headerFontColor='232323' valign='bottom' headertext='WBS' headerAlign='left' fontColor='232323' fontSize='10' align='center' color='000000' headerVAlign='bottom' font='Arial' headerfont='Arial' headerBgColor='E5E5E5' headerfontSize='10' bgColor='E5E5E5'><process id='Project' name=' Foeodmagazin' bgColor='FFFFFF' fontColor='232323' vAlign='center' align='left' /><process id='f955e7b5-b7ab-48ed-a2c3-47e94882107c' name=' test' bgColor='FFFFFF' fontColor='232323' vAlign='center' align='left' /><process id='0ec1a50f-69b5-4fae-948e-e53b574428c3' name=' test' bgColor='FFFFFF' fontColor='232323' vAlign='center' align='left' /><process id='2d353581-a490-418f-aa45-ce2fca949a4d' name=' Test2' bgColor='FFFFFF' fontColor='232323' vAlign='center' align='left' /><process id='540c2998-e343-47fb-8690-39d8d3aa0768' name=' test1' bgColor='FFFFFF' fontColor='232323' vAlign='center' align='left' /><process id='' name=' ' bgColor='FFFFFF' fontColor='232323' vAlign='center' align='left' /></processes><datatable /><tasks><task toolText='Budgeted (Start date): 01-07-2020{br}Budgeted (End date): 30-11-2020{br}Budgeted (Hours): 990.00{br}' start='2020/07/01 00:00:00' label='' end='2020/11/30 23:59:00' color='757575' topPadding='8' showAsGroup='1' height='8' id='CBudget/0.3/' processId='Project' borderColor='757575' /><task toolText='Budgeted (Start date): 01-07-2020{br}Budgeted (End date): 30-11-2020{br}Budgeted (Hours): 900.00{br}' link='javascript:{ShowLightBox('ProProjectWBS.aspx?BCAction=13&ID=f955e7b5-b7ab-48ed-a2c3-47e94882107c&_Division_=116477','False',885,500);}' start='2020/07/01 00:00:00' label='' end='2020/11/30 23:59:00' color='757575' topPadding='8' showAsGroup='1' height='8' id='CBudget/1/' processId='f955e7b5-b7ab-48ed-a2c3-47e94882107c' borderColor='757575' /><task toolText='Budgeted (Start date): 01-07-2020{br}Budgeted (End date): 30-07-2020{br}Budgeted (Hours): 400.00{br}' link='javascript:{ShowLightBox('ProProjectWBS.aspx?BCAction=13&ID=0ec1a50f-69b5-4fae-948e-e53b574428c3&_Division_=116477','False',1070,680);}' start='2020/07/01 00:00:00' label='' end='2020/07/30 23:59:00' color='757575' topPadding='8' height='8' id='CBudget/1/1/' processId='0ec1a50f-69b5-4fae-948e-e53b574428c3' borderColor='757575' /><task toolText='Budgeted (Start date): 31-07-2020{br}Budgeted (End date): 30-11-2020{br}Budgeted (Hours): 500.00{br}' link='javascript:{ShowLightBox('ProProjectWBS.aspx?BCAction=13&ID=2d353581-a490-418f-aa45-ce2fca949a4d&_Division_=116477','False',1070,680);}' start='2020/07/31 00:00:00' label='' end='2020/11/30 23:59:00' color='757575' topPadding='8' height='8' id='CBudget/1/2/' processId='2d353581-a490-418f-aa45-ce2fca949a4d' borderColor='757575' /><task toolText='Budgeted (Start date): 25-07-2020{br}Budgeted (End date): 29-08-2020{br}Budgeted (Hours): 90.00{br}' link='javascript:{ShowLightBox('ProProjectWBS.aspx?BCAction=13&ID=540c2998-e343-47fb-8690-39d8d3aa0768&_Division_=116477','False',1070,680);}' start='2020/07/25 00:00:00' label='' end='2020/08/29 23:59:00' color='757575' topPadding='8' height='8' id='CBudget/2/' processId='540c2998-e343-47fb-8690-39d8d3aa0768' borderColor='757575' /></tasks><milestones /><trendlines><line start='2020/07/23 12:00:00' end='2020/07/23 12:00:00' isTrendZone='0' color='47B656' displayValue='Today' thickness='2' alpha='100' /><line start='2020/07/04 00:00:00' end='2020/07/05 00:00:00' isTrendZone='1' color='E3E3E3' displayValue=' ' alpha='50' /><line start='2020/07/05 00:00:00' end='2020/07/06 00:00:00' isTrendZone='1' color='E3E3E3' displayValue=' ' alpha='50' /><line start='2020/07/11 00:00:00' end='2020/07/12 00:00:00' isTrendZone='1' color='E3E3E3' displayValue=' ' alpha='50' /><line start='2020/07/12 00:00:00' end='2020/07/13 00:00:00' isTrendZone='1' color='E3E3E3' displayValue=' ' alpha='50' /><line start='2020/07/18 00:00:00' end='2020/07/19 00:00:00' isTrendZone='1' color='E3E3E3' displayValue=' ' alpha='50' /><line start='2020/07/19 00:00:00' end='2020/07/20 00:00:00' isTrendZone='1' color='E3E3E3' displayValue=' ' alpha='50' /><line start='2020/07/25 00:00:00' end='2020/07/26 00:00:00' isTrendZone='1' color='E3E3E3' displayValue=' ' alpha='50' /><line start='2020/07/26 00:00:00' end='2020/07/27 00:00:00' isTrendZone='1' color='E3E3E3' displayValue=' ' alpha='50' /><line start='2020/08/01 00:00:00' end='2020/08/02 00:00:00' isTrendZone='1' color='E3E3E3' displayValue=' ' alpha='50' /><line start='2020/08/02 00:00:00' end='2020/08/03 00:00:00' isTrendZone='1' color='E3E3E3' displayValue=' ' alpha='50' /><line start='2020/08/08 00:00:00' end='2020/08/09 00:00:00' isTrendZone='1' color='E3E3E3' displayValue=' ' alpha='50' /><line start='2020/08/09 00:00:00' end='2020/08/10 00:00:00' isTrendZone='1' color='E3E3E3' displayValue=' ' alpha='50' /><line start='2020/08/15 00:00:00' end='2020/08/16 00:00:00' isTrendZone='1' color='E3E3E3' displayValue=' ' alpha='50' /><line start='2020/08/16 00:00:00' end='2020/08/17 00:00:00' isTrendZone='1' color='E3E3E3' displayValue=' ' alpha='50' /><line start='2020/08/22 00:00:00' end='2020/08/23 00:00:00' isTrendZone='1' color='E3E3E3' displayValue=' ' alpha='50' /><line start='2020/08/23 00:00:00' end='2020/08/24 00:00:00' isTrendZone='1' color='E3E3E3' displayValue=' ' alpha='50' /><line start='2020/08/29 00:00:00' end='2020/08/30 00:00:00' isTrendZone='1' color='E3E3E3' displayValue=' ' alpha='50' /><line start='2020/08/30 00:00:00' end='2020/08/31 00:00:00' isTrendZone='1' color='E3E3E3' displayValue=' ' alpha='50' /><line start='2020/09/05 00:00:00' end='2020/09/06 00:00:00' isTrendZone='1' color='E3E3E3' displayValue=' ' alpha='50' /><line start='2020/09/06 00:00:00' end='2020/09/07 00:00:00' isTrendZone='1' color='E3E3E3' displayValue=' ' alpha='50' /><line start='2020/09/12 00:00:00' end='2020/09/13 00:00:00' isTrendZone='1' color='E3E3E3' displayValue=' ' alpha='50' /><line start='2020/09/13 00:00:00' end='2020/09/14 00:00:00' isTrendZone='1' color='E3E3E3' displayValue=' ' alpha='50' /><line start='2020/09/19 00:00:00' end='2020/09/20 00:00:00' isTrendZone='1' color='E3E3E3' displayValue=' ' alpha='50' /><line start='2020/09/20 00:00:00' end='2020/09/21 00:00:00' isTrendZone='1' color='E3E3E3' displayValue=' ' alpha='50' /><line start='2020/09/26 00:00:00' end='2020/09/27 00:00:00' isTrendZone='1' color='E3E3E3' displayValue=' ' alpha='50' /><line start='2020/09/27 00:00:00' end='2020/09/28 00:00:00' isTrendZone='1' color='E3E3E3' displayValue=' ' alpha='50' /><line start='2020/10/03 00:00:00' end='2020/10/04 00:00:00' isTrendZone='1' color='E3E3E3' displayValue=' ' alpha='50' /><line start='2020/10/04 00:00:00' end='2020/10/05 00:00:00' isTrendZone='1' color='E3E3E3' displayValue=' ' alpha='50' /><line start='2020/10/10 00:00:00' end='2020/10/11 00:00:00' isTrendZone='1' color='E3E3E3' displayValue=' ' alpha='50' /><line start='2020/10/11 00:00:00' end='2020/10/12 00:00:00' isTrendZone='1' color='E3E3E3' displayValue=' ' alpha='50' /><line start='2020/10/17 00:00:00' end='2020/10/18 00:00:00' isTrendZone='1' color='E3E3E3' displayValue=' ' alpha='50' /><line start='2020/10/18 00:00:00' end='2020/10/19 00:00:00' isTrendZone='1' color='E3E3E3' displayValue=' ' alpha='50' /><line start='2020/10/24 00:00:00' end='2020/10/25 00:00:00' isTrendZone='1' color='E3E3E3' displayValue=' ' alpha='50' /><line start='2020/10/25 00:00:00' end='2020/10/26 00:00:00' isTrendZone='1' color='E3E3E3' displayValue=' ' alpha='50' /><line start='2020/10/31 00:00:00' end='2020/11/01 00:00:00' isTrendZone='1' color='E3E3E3' displayValue=' ' alpha='50' /><line start='2020/11/01 00:00:00' end='2020/11/02 00:00:00' isTrendZone='1' color='E3E3E3' displayValue=' ' alpha='50' /><line start='2020/11/07 00:00:00' end='2020/11/08 00:00:00' isTrendZone='1' color='E3E3E3' displayValue=' ' alpha='50' /><line start='2020/11/08 00:00:00' end='2020/11/09 00:00:00' isTrendZone='1' color='E3E3E3' displayValue=' ' alpha='50' /><line start='2020/11/14 00:00:00' end='2020/11/15 00:00:00' isTrendZone='1' color='E3E3E3' displayValue=' ' alpha='50' /><line start='2020/11/15 00:00:00' end='2020/11/16 00:00:00' isTrendZone='1' color='E3E3E3' displayValue=' ' alpha='50' /><line start='2020/11/21 00:00:00' end='2020/11/22 00:00:00' isTrendZone='1' color='E3E3E3' displayValue=' ' alpha='50' /><line start='2020/11/22 00:00:00' end='2020/11/23 00:00:00' isTrendZone='1' color='E3E3E3' displayValue=' ' alpha='50' /><line start='2020/11/28 00:00:00' end='2020/11/29 00:00:00' isTrendZone='1' color='E3E3E3' displayValue=' ' alpha='50' /><line start='2020/11/29 00:00:00' end='2020/11/30 00:00:00' isTrendZone='1' color='E3E3E3' displayValue=' ' alpha='50' /></trendlines><legend><item label='Baseline' color='757575' /><item label='Frozen baseline' color='CCCCCC' /><item label='Planning' color='C0E299' /><item label='Realisation' color='789556' /></legend></chart>"); chart_WBSGantt.render("WBSGanttDiv"); }); //]]> </script> <!-- END Script Block for Chart WBSGantt --> </head> <body> <form id="form1" runat="server"> <!-- START Script Block for Chart WBSGantt --> <div id="WBSGanttDiv"> Chart. </div> </form> </body> </html> FusionChartGantSimple.zip Graph.xls Edited July 24, 2020 by Md Faruk Hossen Khan Share this post Link to post Share on other sites
Ayan Bhadury Report post Posted July 24, 2020 Hi, Please upgrade to the latest version of FusionCharts 3.15.2 to export the chart data in xlsx format- http://jsfiddle.net/7fj5cdto/ Please note only tasks data will be exported. Share this post Link to post Share on other sites
Md Faruk Hossen Khan Report post Posted July 24, 2020 Hello Ayan, Thanks for your reply. I have the following questions : 1. Is it possible to export xls or fix the getCSVData method in the version 3.11.3 ? Is there any workaround? Please suggest. 2. Our code is bit dynamically generated, in my question I have given the generated code!!!! Thus, it is a bit tricky to upgrade. If we upgrade to the latest version of FusionChart in our application, does it only requires to replace the latest js files or also need to change the integration code? Share this post Link to post Share on other sites
Ayan Bhadury Report post Posted July 24, 2020 Hi, Sorry in order to export the chart in xlsx you need to upgrade to the latest version 3.15.2 For the other query yes you need to replace the library files with the latest version, also the code which you are using are flash-based and few of the methods are now deprecated, please refer the above sample above you need to use the code accordingly, also here is a glimpse what you need to modify 1 - Methods like setCurrentRenderer, setDataXml is now deprecated. 2 - Passing the parameters as shown in the snippet below has been now changed var chart_WBSGantt = new FusionCharts("Gantt", "WBSGantt", "100%", "224", "0", "0", "", "noScale", "EN" ); Instead, it now passes the parameters in an object like manner under the ready method, which is shown in step 3 3 - Finally based on all the above points please check this modified demo which will work at your end with the latest version 3.15.2 - http://jsfiddle.net/7fj5cdto/ With this above example, you would be able to export the charts in the xlsx format as well. Hope this helps. Thanks, Ayan Share this post Link to post Share on other sites
Md Faruk Hossen Khan Report post Posted July 28, 2020 Hi Ayan, Thanks for your suggestions. After upgrade, the xls export for Gantt chart works :). But other charts are not rendering. I did some research and found that when I am using <script type="text/javascript" src="//cdn.fusioncharts.com/fusioncharts/latest/fusioncharts.js"></script> the chart is rendering but when using the local fusioncharts.js it is not rendering. fusioncharts.js ----> we got from FusionChart, please see the attached 'fusionwidgets-xt-ol.zip' that we received from fusion chart I am attaching my source code extract as well. fusionwidgets-xt-ol.zip FusionStackedColumn2DLine.zip Share this post Link to post Share on other sites
Md Faruk Hossen Khan Report post Posted July 29, 2020 Hi, Continuing my research, I downloaded the trial version of the fusion chart and used these with our application( Exact online application). It seemed to work fine. Thus, it seems that the attached licensed fusion chart js files(that my colleague Leo van Houwelingen received from fusion charts) have some problem. I noticed our licensed version has fewer files than the trial one. It also does not contain fusioncharts.charts.js How can I get the correct version of the fusion chart js files? Share this post Link to post Share on other sites
Ayan Bhadury Report post Posted July 29, 2020 Hi, You need to include the necessary lib files to render charts, for example, to render column chart - fusioncharts.js, fusioncharts.charts.js is required Similarly, for Gantt you need the following fusioncharts.js, fusioncharts.widgets.js & fusioncharts.gantt.js Please note based on your license you would get the lib files accordingly, if you do not have purchase FusionChartsXT you will not get fusioncharts.charts.js, please drop a mail to [email protected] for more details. Share this post Link to post Share on other sites
