IMPLEMENTED - Exporting data in MS Excel format

This section allows you to vote for new features that may be implemented into Clarity.
Forum rules
You have to be logged in to be able to vote.
This section lists feature requests with polls. You can:
  • Vote for the feature to increase its priority and discuss how it should be implemented.
  • How to vote? Just log in to your forum account and the voting options will appear.
  • If you have not found your desired feature here, create a new thread for it.
  • You will not be able to create the poll yourself, but after the checking of the suggestion, we will create the poll for you.
We do take this poll seriously, however it is not the only source of priorities for the development.
Locked

Do you want us to implement the data export in MS Excel format?

Yes.
6
75%
No.
2
25%
 
Total votes: 8

User avatar
Daniel Mentlik
DataApex Support
DataApex Support
Posts: 353
Joined: Fri Mar 27, 2009 3:15 pm

IMPLEMENTED - Exporting data in MS Excel format

Post by Daniel Mentlik »

Microsoft Excel is one of the most widely used systems for calculation of simple results using spreadsheets. Clarity can now export its own data in ASCII format, which can be then imported into MS Excel. Being able to export the data from Clarity in the excel format from the start would simplify the process.

Do you want DataApex to include this feature? Vote in the poll and discuss the feature in this thread to fasten the process!

Internal issue tracking ID: 9939
Daniel Mentlí­k
DataApex

IFL
Posts: 14
Joined: Tue May 19, 2009 11:51 am

Re: Exporting data in MS Excel format

Post by IFL »

Hello,

if you are planing to implement Excel-export what is about OpenOffice Calc export files? Is this the same format?

Thank you.


Claus

User avatar
Petr Kohutek
DataApex Support
DataApex Support
Posts: 57
Joined: Fri Mar 27, 2009 3:15 pm
Location: Praha
Contact:

Re: Exporting data in MS Excel format

Post by Petr Kohutek »

Open Office Calc can usually open the MS Excel format. I have experienced problems only with complicated excel files containing macros.
Thank you for suggestion we will take Open Office Calc into consideration.
Petr Kohutek
DataApex

User avatar
Petr Kohutek
DataApex Support
DataApex Support
Posts: 57
Joined: Fri Mar 27, 2009 3:15 pm
Location: Praha
Contact:

Re: Exporting data in MS Excel format

Post by Petr Kohutek »

Together with the development of the Excel supporting features in Clarity we plan to prepare several examples of macros solving common tasks. You can use them freely and modify it to suit to your requirements. If you can, please share your improvements with others by posting the improvements back to the Clarity forum or to DataApex.

Please send us any
  • suggestions for solutions that you would like to do with Excel, we will try to address the most popular ones
  • Description of your Excel solutions - Examples of your excel sheets would be very helpful
  • Comments to our macros - let us know if it works, eventual problems, etc.
This feedback will help us to better design the planned Excel supporting features in Clarity.

First of the macros is available here: Excel - export Clarity result table, compare with limits
Petr Kohutek
DataApex

User avatar
Daniel Mentlik
DataApex Support
DataApex Support
Posts: 353
Joined: Fri Mar 27, 2009 3:15 pm

Re: Exporting data in MS Excel format

Post by Daniel Mentlik »

The issue was implemented in Clarity 3.0.2.244
Daniel Mentlí­k
DataApex

Locked