Hi, I'm writing a test case for automting a DB process. Is there a way I can save the result from the query as Excel doument instead. By default the response is XML and with no column name in it
I have created a custom filter for this as I have also faced this issue.
Please give me your email id. I will share the same. That shud help.
Thanks Monika. Appriciate your help.
Here's my Id - email@example.com
Hi Monika, Thanks for the help. It worked
This is great community effort to help each other.
Can I bother both of you with a question? Would it be possible for you to share the specific use cases you guys had that required you to save the result set in csv file?
In my previous project also we faced the same situation where we need the complete result of sequel query in csv. For that we wrote a code in Scripted Step and used that to achieve our goal. But it would be good if there is some sort of check box in existing step or functionality that allow us to export result in csv or xls from query result.
Sure Arif. Thanks for the question.
I was creating a framework to test Stored Procedures, so for future reference/regression testing i need to to save result set in excel sheet for comparison.
Initially I wrote a code to do the same but because it was taking more execution time and needed to be reused , I ended up creating a custom filter.
Hope that answers your question.
I want export my project into excel or xml format instead of .dtt format in devtest, please could you help me for same
My email id : firstname.lastname@example.org
Thanks in advance for your help
My email id is
Hi Monika/Shijil, Can you share the custom filter and send it to Mukeshchippagiri@gmail.com
I have uploaded this at below link:"
LISA SDK: Filter to save Result Set in an Excel Sheet
Thanks for putting this here Monika for public use!
Thanks Monica, this is really helpful as I was looking this for my Project
While export my projects from devtest its exporting in .dtt format is there any option to export in excel or xml format so that I can use to import in testlink
Is there a way I can save the result from the SQL query to a Excel doument ? I am using Devtest v10.1.0 Version.
Tried above solution but its not working in Devtest v10.1.0.
my mail id - email@example.com
Retrieving data ...