New issue
Have a question about this project? Sign up for a free GitHub account to open an issue and contact its maintainers and the community.
By clicking “Sign up for GitHub”, you agree to our terms of service and privacy statement. We’ll occasionally send you account related emails.
Already on GitHub? Sign in to your account
excel xlsx file support #15
Comments
Hi @cjayswal have you already added support for xlsx in qaf? |
This feature is not in priority for now. Please let us know if it is must have feature. |
Hi @cjayswal in my case I receive XLSX file directly from business. I need to pick data from XLSX sheet and do the automation. But as XLSX is not supported I need to change the excel format to XLS. It is good to have support for XLSX too. Or else is there anyway to make custom implementation of XLSX for now. |
How do I upvote this issue ? |
You can click on emoji and select thumb up as upvote to comment. |
+1 for this feature to support xlsx |
This is a must have feature because of the xls format limitation of maximum 256 columns allowed. There are cases in which there are more than 256 columns of data needed and for that we need xlsx format. |
Upvoting on this once again . We are using qmetry with excel file as our data source.
|
Upvoting the support for this feature. Just ran into this XLS file's 256-column limitation on my current project - end-to-end test with voluminous test data. Hope this support will be implemented soon. |
Thanks @cjayswal for closing this. Is the fix available on current 3.0.0 version or it will be available on new version? |
This feature will be available with next release. |
Hi there! While waiting for the next release, you may want to try to manually add the necessary classes and dependencies to your project:
Note that I made this to work on my current project and you might encounter the "Label [tableName] for ending data range not found in sheet [sheetName]" error as you update your XLSX file and upon running a test. I simply did insert/delete a column before your data table in your XLSX data file to fix that error. Hope this helps! Thanks, @cjayswal and @amitbhoraniya for closing this issue! |
Thanks @darkzcythe. As you have started to use this feature, let us know if you find any issue. So we can fix it before next release. |
Thanks @darkzcythe for explaining. Do you have any git repo for the XLSX example. It would be great. |
Sure thing, @amitbhoraniya ! The only issue I am encountering, so far, as I have mentioned, is when I made change(s) or update(s) to the data in the xlsx test data file or on the data table, like add/remove a column or change a data in a cell or cells, the "Label [tableName] for ending data range not found in sheet [sheetName]" console error occurs when I run the XML test runner. Currently I have already 400+ columns of test data for a single test scenario (an end-to-end script) and is a separate data file from other tests (I kept the XLS data file for tests with 256 or below test data), so that those other tests will not be affected in case the said XLSX error occured. And when I encounter the said issue when I ran the test with the XLSX data file, I simply do:
which is kind of tedious and your test will be prone to error if ever you missed to do the given temporary fix. Hope you can provide a permanent fix for this. Thank you! @rupakgithub - Sorry but I don't have a public git repo to share this with you. Although, if you have an existing project - qaf framework, you can just follow the steps I have already given to try it out. |
@amitbhoraniya @cjayswal @reidleingod |
No description provided.
The text was updated successfully, but these errors were encountered: