Thread

Skip Navigation LinksForums > SpiraTest Forums > SpiraTest Issues & Questi... > Excel exports don't provi...

Excel exports don't provide adequate formatting RSS Feed

Tuesday, October 7, 2014
Is there a way to export our raw data to excel?  I can only export summary data, and the formatting used when exporting via Reporting adds formatting to the file that makes it impossible to manipulate.
2 Replies
Adam SAdam S
re: Tammy Tollefson on Tuesday, October 7, 2014
Tuesday, October 7, 2014

Hi Tammy

You can use the MS-Excel 2003 format reports that don't contain as much of the rich text.

Otherwise I'd suggest using the custom reporting option to use a ESQL query to get the data you want in the format you want.

Regards

Adam

Tammy TollefsonTammy Tollefson
re: Adam S on Tuesday, October 7, 2014
Tuesday, October 7, 2014

Adam - 

Sorry, but I tried exporting to Excel 2003 .  The problem is that the data gets bundled into cells or added as separate lines that can't be filtered or sorted to retain all of the data for the record.  Plus, because it's summary data, we can't drill down to selected records.

Not being a SQL programmer, so am kind of at a loss as to how to get the data we need.

- Tammy

Tagged
Statistics
  • Started: 10/7/2014
  • Last Reply: 10/7/2014
  • Replies: 2
  • Views: 322
Powered by KronoDesk v1.1.0.15 | © Copyright Inflectra Corporation 2011-2016 | Licensed to Inflectra Corporation.