In this post Luca Spinelli and Ivan Aguilar from ClearPeaks indroduce us to the new export to Excel solution for Xcelsius using the Apache Tomcat (jsp) server.
If you have been searching for an export to Excel solution for Xcelsius using the Apache Tomcat (jsp) server, look no further.
ClearPeaks has developed a customized solution that any BI Developer can quickly and easily add to an Xcelsius dashboard. Export2Excel* will allow your end users to filter results by selecting part of their dashboard using the XML connection of Xcelsius. Essentially, this customized option adds flexibility to an Xcelsius dashboard for those users who want to look at data outside of the predefined dashboard components.
How to Configure Export2Excel
Follow the steps below to configure the Export2Excel solution in your Xcelsius dashboard:
1. Download the WAR file (Find the link at the end of this post)
2. Copy the ExportToExcelv2.war into your Tomcat webapps folder
3. Open the Data Manager
4. Add XML connection
5. Set the XML Data URL as http://<servername>:<port>/ExportToExcelv2/index.jsp
6. Check the “Enable Send” function. This will contain the range of cells that you choose to export.
7. Check the “Enable Load” function. Be sure that the Name is URLDummy (as highlighted in red in the screenshot below), and that the Range contains just one cell. This cell is the URL of the exported Excel file.
Note: Add a refresh connection and URL button on the Xcelsius dashboard to open this link
Demo:
As you will see in the image below, ClearPeaks has merged the functionalities of a refresh connection button and a URL button. As a result of this customized functionality, users can open an Excel file and begin their own analysis and comparisons if desired.
If you want to learn more about ClearPeaks and our BI solutions, please contact us at info@clearpeaks.com or visit us at www.clearpeaks.com.
* Copyright (C) 2009 ClearPeaks. This free solution can be used, published or redistributed with appropriate credit to ClearPeaks. Please see the terms and conditions of the General Public License within the “About ClearPeaks Export2Excel” tab of the file.
Hi Ann,
did you already download the latest version from our website (www.clariba.com)? By the way, if you face those issue with spacial characters then you should replace them in your excel. I know that it is a pity, but I will check whether we can do something and make it working.
One more thing, please keep in mind that it doesn’t work because the Xml file does not compile correctly (because it doesn’t allow us to use &…etc.)
I hope I can get back to you soon with some good news…in the meantime you need to use find(replace()) in excel I am sorry
!
Best Regards,
Luca
Clariba
luca.spinelli@clariba.com
Hi Luca,
i have tried with find and replace.Please check my expression.
=IF(ISERROR(FIND(“&”,C54,1)),C54,REPLACE(C54, FIND(“&”,C54,1),1,”%26″))
but instead of returning %26, it is returning %2526.
Thanks in advance
Regards
Ann
Hi ,
I have deployed export to excel in 4.5 and 2008 a few months back but facing problem when doing the same practice in Xcelsius SP3.jsp file is not populating any link to load. i can see my xml from data manager when configuring xml feed but same xml is not reaching to web server. Any ideas and yes i have made this change in jsp
String exported = (String) urlLine.readLine();
while (urlLine.ready()) { exported += (String) urlLine.readLine(); }
but still not working