MatthewB
Occasional Contributor
Joined 4 years ago
User Profile
User Widgets
Contributions
Not able to grab data from Excel using TestComplete with wrapped text using Excel.Open("filename")..
We are using the Excel.Open("FileName").SheetByIndex(0).Cell("A",6).Value to grab data from excel. The method works overall, but does not capture the wrapped text from Excel. The result of the data gets only the top row of data in the cell if the data has multiple rows within the cell due to format wrapping. https://s3.amazonaws.com/webtocasefiles/2023/df50c321-d7a4-01b4-c9a0-3b2a829a6f9f/2023_05_09-11_49_36_666/excelissue.mp4?AWSAccessKeyId=AKIAILZDL6PV2PCURZRA&Expires=1770013186&Signature=GBZ9WeGGTp0bTutP5NyxxLPuD%2Fw%3D https://s3.amazonaws.com/webtocasefiles/2023/df50c321-d7a4-01b4-c9a0-3b2a829a6f9f/2023_05_11-12_19_12_914/excelissuenew.mp4?AWSAccessKeyId=AKIAILZDL6PV2PCURZRA&Expires=1770187774&Signature=5KJMXKJV0BMv%2B2XvPg2Alz4LSHg%3D I also want to include that we are not using the full version of Excel. We are only using the runtime available from Microsoft: https://urldefense.com/v3/__https://support.microsoft.com/en-us/office/download-and-install-microsoft-365-access-runtime-185c5a32-8ba9-491e-ac76-91cbe3ea09c9__;!!LYp-Ckqeseg!RnQdRJpIZ_U3BXwueZnyhZzwK1WbfXTY1vJbK_jyYaWyXmatNdV0bKgcbRZOc3PgTEaO4hOey4O-vGNPpD-ytTU$ <https://urldefense.com/v3/__https://support.microsoft.com/en-us/office/download-and-install-microsoft-365-access-runtime-185c5a32-8ba9-491e-ac76-91cbe3ea09c9__;!!LYp-Ckqeseg!RnQdRJpIZ_U3BXwueZnyhZzwK1WbfXTY1vJbK_jyYaWyXmatNdV0bKgcbRZOc3PgTEaO4hOey4O-vGNPpD-ytTU$ > We are also referring to the example provided in the SmartBear documentation: https://urldefense.com/v3/__https://support.smartbear.com/testcomplete/docs/testing-with/working-with-external-data-sources/excel/read.html__;!!LYp-Ckqeseg!RnQdRJpIZ_U3BXwueZnyhZzwK1WbfXTY1vJbK_jyYaWyXmatNdV0bKgcbRZOc3PgTEaO4hOey4O-vGNPELd9-Fc$ <https://urldefense.com/v3/__https://support.smartbear.com/testcomplete/docs/testing-with/working-with-external-data-sources/excel/read.html__;!!LYp-Ckqeseg!RnQdRJpIZ_U3BXwueZnyhZzwK1WbfXTY1vJbK_jyYaWyXmatNdV0bKgcbRZOc3PgTEaO4hOey4O-vGNPELd9-Fc$ > Specifically, the section about Excel Object.
