It's all about the answers!

Ask a question

Export standard report in Excel 2013 format doesn't work


Brian Mooney (11811) | asked Jul 31 '15, 10:49 a.m.

I am using RTC 5.0.1 and needs to export a standard report "Open vs. closed WI" into Excel format.

Steps:
Web Browser/Reports/Shared Reports.
Choose the report and open it. Press Export and choose Excel format.


I have used MicrosoftExcel 2013 and before it opens the files exported I got the error message: "The file you are trying to open,  "report-2.xls' is in a different format than specified by the file extension. Verify that the file is not corupted and is from a trusted source before opening the file., Do you want to open the file?"
Choosing option Yes I got the file opened in Excel but without any data but the table header.
I mention, I can see the report graph and can export the graph via a PDF or word, but when I choose to export to excel, it does not export data, just headers.  I can click on the graph and it takes me to the data and I can export from there, but on the main graph it shows multiple people and work items, it would be nice to see the report with everyones data.   

 
I have had other try this operation and they have gotten the same error.

I have read these other posts, I believe the 3rd link is the solution, but wanted to validate before I open a ticket with higher level of support.  I am not using a widget, just running a standard report  "Open vs. closed Work Items"

https://jazz.net/forum/questions/167887/export-standard-report-in-excel-format-doesnt-work

https://jazz.net/forum/questions/167832/cant-export-in-rqm-the-rtc-report-open-vs-closed-work-items-to-csv

https://jazz.net/jazz/web/projects/Rational%20Team%20Concert#action=com.ibm.team.workitem.viewWorkItem&id=296569


One answer



permanent link
Donald Nong (14.5k414) | answered Aug 02 '15, 10:24 p.m.
edited Aug 03 '15, 12:47 a.m.
I'm not sure it's defect or not, as the file you download is an XML file (even though it has the .xls suffix) of the Microsoft Office XML format, which is used in Office 2003 only.
https://en.wikipedia.org/wiki/Microsoft_Office_XML_formats
I try to open such a file in Excel View 2003 but it fails as well. I have not found a way to convert such a file to a more useful format, or a tool to open it properly.

P.S. I managed the find a machine with Excel 2003 and could open the export Excel file without any errors. Since it's a plain XML file, of course there are no graphs.

Your answer


Register or to post your answer.


Dashboards and work items are no longer publicly available, so some links may be invalid. We now provide similar information through other means. Learn more here.