Hi,
I have data in form of a web table in my application and I need to export that into excel for validating with the database. Please let me know the way to export that web table into an excel. Any help is appreciated.
Thanks
Vivek.
Export web table to excel
Re: Export web table to excel
I'm not sure I see how this is related to Ranorex specifically. Can you explain how you want to use Ranorex to do this?
If you are just wanting to validate the data, you should not export to Excel. Ranorex can be used, along with a data connector or straight connection to the database, to validate the values in the web table. As a matter of fact, that is what Ranorex is built for.
If you are just wanting to validate the data, you should not export to Excel. Ranorex can be used, along with a data connector or straight connection to the database, to validate the values in the web table. As a matter of fact, that is what Ranorex is built for.
Shortcuts usually aren't...
Re: Export web table to excel
Hi,
There is no built-in way to write excel files. Check this post with some links discussing possibility to write Excel files...
http://www.ranorex.com/forum/how-to-rea ... tml#p35286
There are many other posts about writing to Excel. Just use search.
What could be done without the need to use 3rd party Excel libraries, is using Ranorex CSV data connector, which allows also writing CSV files. You can find a sample code (using Ranorex CSV DataConnector) here:
http://www.ranorex.com/forum/writing-in ... tml#p34657
I would also suggest you to check this code sample for advanced validation of web table:
http://www.ranorex.com/forum/how-to-rea ... tml#p35286
In this particular sample, the web table is compared with previously created reference snapshot. But I'm sure you can replace the snapshot with data obtained form database. It would just require some more coding I think this particular code could help as well:
http://www.ranorex.com/support/user-gui ... html#c7787
There is no built-in way to write excel files. Check this post with some links discussing possibility to write Excel files...
http://www.ranorex.com/forum/how-to-rea ... tml#p35286
There are many other posts about writing to Excel. Just use search.
What could be done without the need to use 3rd party Excel libraries, is using Ranorex CSV data connector, which allows also writing CSV files. You can find a sample code (using Ranorex CSV DataConnector) here:
http://www.ranorex.com/forum/writing-in ... tml#p34657
I would also suggest you to check this code sample for advanced validation of web table:
http://www.ranorex.com/forum/how-to-rea ... tml#p35286
In this particular sample, the web table is compared with previously created reference snapshot. But I'm sure you can replace the snapshot with data obtained form database. It would just require some more coding I think this particular code could help as well:
http://www.ranorex.com/support/user-gui ... html#c7787
Pavel Kudrys
Ranorex explorer at Descartes Systems
Please add these details to your questions:
Ranorex explorer at Descartes Systems
Please add these details to your questions:
- Ranorex Snapshot. Learn how to create one >here<
- Ranorex xPath of problematic element(s)
- Ranorex version
- OS version
- HW configuration
-
- Posts: 31
- Joined: Mon Feb 22, 2016 7:21 pm
Re: Export web table to excel
Let me explain in more detail
I have a table in a web application and I need to compare those values with the database. I thought of exporting the table from web application to excel and then comparing the data in excel with database. Please let me know if there is any other easy way to do that.
Thanks
Vivek
I have a table in a web application and I need to compare those values with the database. I thought of exporting the table from web application to excel and then comparing the data in excel with database. Please let me know if there is any other easy way to do that.
Thanks
Vivek
Re: Export web table to excel
As I said, you should just use the Ranorex Validate class on the table directly, using the database data as your expected result. There is no need to export to CSV/XLS.
1. Create a module that validates the data for a given row, column, and data value.
2. Create a Test Case in your suite in the spot where you need to validate the data.
3. Create a SQL Data Connector for the new Test Case using a SQL Query that gets the expected row/column/value information.
4. Bind the module variables to the data connector values.
5. Run the test.
The new test case will loop over each row in the SQL query and pass that info to the module, which would validate that the information in the table is the same.
1. Create a module that validates the data for a given row, column, and data value.
2. Create a Test Case in your suite in the spot where you need to validate the data.
3. Create a SQL Data Connector for the new Test Case using a SQL Query that gets the expected row/column/value information.
4. Bind the module variables to the data connector values.
5. Run the test.
The new test case will loop over each row in the SQL query and pass that info to the module, which would validate that the information in the table is the same.
Shortcuts usually aren't...