# Excel data files read from azure pipeline **URL:** \ **Category:** Integrations\ **Tags:** azure, excel, integrations\ **Created:** [September 29, 2023, 7:27am UTC](https://forum.katalon.com/t/excel-data-files-read-from-azure-pipeline/97997 "2023-09-29T07:27:02Z")\ **Posts on this page:** 8\ **Page:** 1
**Author:** ![mallikarjun.patnam](https://dub1.discourse-cdn.com/katalon/user_avatar/forum.katalon.com/mallikarjun.patnam/32/23869_2.png) [@mallikarjun.patnam](https://forum.katalon.com/u/mallikarjun.patnam)\ **Post date:** [September 29, 2023, 7:27am UTC](https://forum.katalon.com/t/excel-data-files-read-from-azure-pipeline/97997/1 "2023-09-29T07:27:02Z")
I am getting following error when I try to use Excel data file and execute through azure pipeline. From katalon studio it is executing fine. Error-1: Reading excel data file java.lang.NoSuchMethodError: org.openxmlformats.schemas.spreadsheetml.x2006.main.impl.CTFontsImpl.getXmlObjectArray(Ljavax/xml/namespace/QName;[Lorg/apache/xmlbeans/XmlObject;)[Lorg/apache/xmlbeans/XmlObject; ``` at org.openxmlformats.schemas.spreadsheetml.x2006.main.impl.CTFontsImpl.getFontArray(CTFontsImpl.java:71) at org.apache.poi.xssf.model.StylesTable.readFrom(StylesTable.java:210) at org.apache.poi.xssf.model.StylesTable.(StylesTable.java:138) at org.apache.poi.ooxml.POIXMLFactory.createDocumentPart(POIXMLFactory.java:61) at org.apache.poi.ooxml.POIXMLDocumentPart.read(POIXMLDocumentPart.java:660) at org.apache.poi.ooxml.POIXMLDocument.load(POIXMLDocument.java:165) at org.apache.poi.xssf.usermodel.XSSFWorkbook.(XSSFWorkbook.java:278) at org.apache.poi.xssf.usermodel.XSSFWorkbookFactory.createWorkbook(XSSFWorkbookFactory.java:118) at org.apache.poi.xssf.usermodel.XSSFWorkbookFactory.create(XSSFWorkbookFactory.java:98) at org.apache.poi.xssf.usermodel.XSSFWorkbookFactory.create(XSSFWorkbookFactory.java:36) at org.apache.poi.ss.usermodel.WorkbookFactory.lambda$create$2(WorkbookFactory.java:199) at org.apache.poi.ss.usermodel.WorkbookFactory.wp(WorkbookFactory.java:295) at org.apache.poi.ss.usermodel.WorkbookFactory.create(WorkbookFactory.java:199) at org.apache.poi.ss.usermodel.WorkbookFactory.create(WorkbookFactory.java:163) at com.kms.katalon.core.testdata.reader.WorbookProvider.getExcelData(WorbookProvider.java:24) at com.kms.katalon.core.testdata.reader.ExcelFactory.getExcelData(ExcelFactory.java:31) at com.kms.katalon.core.testdata.reader.ExcelFactory.getExcelDataWithDefaultSheet(ExcelFactory.java:17) at com.kms.katalon.core.testdata.TestDataFactory.readExcelData(TestDataFactory.java:224) at com.kms.katalon.core.testdata.TestDataFactory.internallyfindTestData(TestDataFactory.java:150) at com.kms.katalon.core.testdata.TestDataFactory.findTestData(TestDataFactory.java:130) at com.kms.katalon.core.testdata.TestDataFactory$findTestData.callStatic(Unknown Source) at Smoke Users Setup.run(Smoke Users Setup:24) ``` Error-2: Reading Excel file using Excel Keywords plugin D:/a/1/s/Excel/PublishedContent.xlsx 2023-09-28 09:00:36.805 DEBUG testcase.Excel Update - 7: file = new java.io.File(publishFilePath) 2023-09-28 09:00:36.805 DEBUG testcase.Excel Update - 8: if (file.exists()) 2023-09-28 09:00:36.810 DEBUG testcase.Excel Update - 1: println(“File Exists”) File Exists 2023-09-28 09:00:36.814 DEBUG testcase.Excel Update - 10: sheetName = “Articles” 2023-09-28 09:00:36.815 DEBUG testcase.Excel Update - 11: publishFile = getWorkbook(publishFilePath) 2023-09-28 09:00:37.301 ERROR c.k.katalon.core.main.TestCaseExecutor - ? Test Cases/Practice/Excel Update FAILED. Reason: java.lang.NoSuchMethodError: org.openxmlformats.schemas.spreadsheetml.x2006.main.impl.CTNumFmtsImpl.getXmlObjectArray(Ljavax/xml/namespace/QName;[Lorg/apache/xmlbeans/XmlObject;)[Lorg/apache/xmlbeans/XmlObject; ``` at org.openxmlformats.schemas.spreadsheetml.x2006.main.impl.CTNumFmtsImpl.getNumFmtArray(CTNumFmtsImpl.java:71) at org.apache.poi.xssf.model.StylesTable.readFrom(StylesTable.java:201) at org.apache.poi.xssf.model.StylesTable.(StylesTable.java:138) at org.apache.poi.ooxml.POIXMLFactory.createDocumentPart(POIXMLFactory.java:61) at org.apache.poi.ooxml.POIXMLDocumentPart.read(POIXMLDocumentPart.java:660) at org.apache.poi.ooxml.POIXMLDocument.load(POIXMLDocument.java:165) at org.apache.poi.xssf.usermodel.XSSFWorkbook.(XSSFWorkbook.java:278) at org.apache.poi.xssf.usermodel.XSSFWorkbook.(XSSFWorkbook.java:299) at com.kms.katalon.keyword.excel.ExcelKeywords.getWorkbook(ExcelKeywords.groovy:115) at com.kms.katalon.keyword.excel.ExcelKeywords$getWorkbook.call(Unknown Source) at Excel Update.run(Excel Update:28) ``` ---
**Author:** ![Dave\_Evers](https://dub1.discourse-cdn.com/katalon/user_avatar/forum.katalon.com/dave_evers/32/435_2.png) [@Dave\_Evers](https://forum.katalon.com/u/Dave_Evers)\ **Post date:** [September 29, 2023, 4:24pm UTC](https://forum.katalon.com/t/excel-data-files-read-from-azure-pipeline/97997/2 "2023-09-29T16:24:44Z")
Welcome to the Katalon forum @mallikarjun.patnam. Please read this post so folks can help you. [[TIP] How To Help Us Help You!](http://forum.katalon.com/t/tip-how-to-help-us-help-you/12919)? ---
**Author:** ![grylion54](https://dub1.discourse-cdn.com/katalon/user_avatar/forum.katalon.com/grylion54/32/16265_2.png) [@grylion54](https://forum.katalon.com/u/grylion54)\ **Post date:** [September 29, 2023, 5:55pm UTC](https://forum.katalon.com/t/excel-data-files-read-from-azure-pipeline/97997/3 "2023-09-29T17:55:35Z")
> [@mallikarjun.patnam](#): > > java.lang.NoSuchMethodError The **error message** means you do not have a correct pathway to your method, “getWorkbook()” or you have not spelled the method name correctly. As @Dave_Evers has noted, we need more information to assist you beyond that. Personally, I think you need the Object that the method, “getWorkbook()”, is associated with as it is likely NOT a local method (i.e. in the Test Case you are running). ---
**Author:** ![kazurayam](https://dub1.discourse-cdn.com/katalon/user_avatar/forum.katalon.com/kazurayam/32/333_2.png) [@kazurayam](https://forum.katalon.com/u/kazurayam)\ **Post date:** [September 29, 2023, 10:09pm UTC](https://forum.katalon.com/t/excel-data-files-read-from-azure-pipeline/97997/4 "2023-09-29T22:09:40Z")
In the error message I found a fragment: > [@mallikarjun.patnam](#): > > javax/xml/namespace/QName This name reminds me of a previous discussion years ago: > [@Katalon 7.9.1 katalon fails working with web service and data files](http://forum.katalon.com/t/katalon-7-9-1-katalon-fails-working-with-web-service-and-data-files/53006/9): > > In my Katalon Studio 7.9.1 on Mac, I made a Test Case script import javax.xml.xpath.XPathConstants import javax.xml.namespace.QName URL u1 = XPathConstants.class.getResource("/" + XPathConstants.class.getName().replaceAll("\\.", "/") + ".class"); System.out.println(u1); URL u2 = QName.class.getResource("/" + QName.class.getName().replaceAll("\\.", "/") + ".class"); System.out.println(u2); println XPathConstants.NODE When I ran this, I got the following message: 2021-03-19 23:49:37.824 INF… I guess, you have some version conflict on XML processing libraries. > [@mallikarjun.patnam](#): > > I am getting following error when I try to use Excel data file and execute through azure pipeline. From katalon studio it is executing fine. I guess, in the classpath in the azure pipeline, you have some jar file(s) that causes this error. I just guess (I am not very sure), you might have a newer version of Apache Xercess (XML Parser) in the azure classpath which has the higher precedene to the Xercess jar bundled in Katalon Studio. Katalon Studio v8.6.x bundles very old version of Apache POI library, which is quite likely causes version conflicts with newer version of external libs like Xerces. It is impossible for me to investigate further a problem caused by jar’s version conflict remotely. If my guess is right, I think you would not be able to use Excel as data file for Katalon Tests in the Azure pipeline. **Alternatively you could convert the Excel into CSV text manually. You want to use the CSV as input source for Katalon tests**. Processing CSV would not involve any XML libraries. You would be able to workaround the original error. * * * I myself have a doubt about my guess above. I assumed that the process of Katalon Runtime Engine and the process of Azure Pipeline both run in a single Java VM sharing a single classpath. This is unlikely. If this is the case, it’s too stupid. I guess Azure pipeline should be able to fork a dedicated process for Katalon Runtime Engine so that no collision of jar versions should occur. ---
**Author:** ![kazurayam](https://dub1.discourse-cdn.com/katalon/user_avatar/forum.katalon.com/kazurayam/32/333_2.png) [@kazurayam](https://forum.katalon.com/u/kazurayam)\ **Post date:** [September 30, 2023, 12:33am UTC](https://forum.katalon.com/t/excel-data-files-read-from-azure-pipeline/97997/5 "2023-09-30T00:33:07Z")
Katalon released a new beta version v9.0.0 recently > **[Release v9.0.0.beta · katalon-studio/katalon-studio](https://github.com/katalon-studio/katalon-studio/releases/tag/v9.0.0.beta)** > > Enhancements > > Upgraded Eclipse IDE from version 4.16 to 4.27 (2023-03). > Upgraded Java from version 8 to 17. > Upgraded the Groovy compiler from version 2.4.2 to version 3.0.17. > Upgraded EGit from ver... It might be an idea to try this. Things may change. Watch your step! Some new errors may come up. ---
**Author:** ![mallikarjun.patnam](https://dub1.discourse-cdn.com/katalon/user_avatar/forum.katalon.com/mallikarjun.patnam/32/23869_2.png) [@mallikarjun.patnam](https://forum.katalon.com/u/mallikarjun.patnam)\ **Post date:** [September 30, 2023, 1:02pm UTC](https://forum.katalon.com/t/excel-data-files-read-from-azure-pipeline/97997/6 "2023-09-30T13:02:17Z")
Hi, Thanks for your suggestions. I too guess the same and tried to change/ import the poi versions from Katalon library management. But I didn’t find there any option. And Yes, I have existing azure builds for dev and azure agent machines. Using the same env. I will try to check with CSV file, but I have xlsx with multiple tabs. So I need to modify my scripts. Also I will try with new version of Katalon runtime engine (if available v9) ---
**Author:** ![kazurayam](https://dub1.discourse-cdn.com/katalon/user_avatar/forum.katalon.com/kazurayam/32/333_2.png) [@kazurayam](https://forum.katalon.com/u/kazurayam)\ **Post date:** [September 30, 2023, 10:02pm UTC](https://forum.katalon.com/t/excel-data-files-read-from-azure-pipeline/97997/7 "2023-09-30T22:02:07Z")
@mallikarjun.patnam I guess you use [`Maven@3`](https://learn.microsoft.com/azure/devops/pipelines/tasks/reference/maven-v3?view=azure-pipelines) task in your Azure Pipeline to run Katalon Runtime Engine. In your `azure-pipeline.yml` you would have a section that specifies various parameters to the `Maven@3` task. Among others there is a parameter named `jdkVersionOption`. Which value do you specify for `jdkVersionOption`? Katalon products of the current version v8.6.\* requires JDK 1.8. Therefore in the YAML you should specify ```auto jdkVersionOption: '1.8' ``` JDK bundles the Apache Xerces library ever since JDK SE 5 (19 years ago). JDK 8 bundles certain version of Xerces with whch Katalon products depend on. JDK 11 bundles newer Xerces, JDK 17 bundles even newer one. If you specify `1.11` or leave it as default in the YAML, I suppose, KRE would fail. It is quite likely that your test emits a strange message like `java.lang.NoSuchMethodError: org.openxmlformats.schemas.spreadsheetml.x2006.main.impl.CTFontsImpl.getXmlObjectArray(Ljavax/xml/namespace/QName;[Lorg/apache/xmlbeans/XmlObject;)[Lorg/apache/xmlbeans/XmlObject;` ---
**Author:** ![mallikarjun.patnam](https://dub1.discourse-cdn.com/katalon/user_avatar/forum.katalon.com/mallikarjun.patnam/32/23869_2.png) [@mallikarjun.patnam](https://forum.katalon.com/u/mallikarjun.patnam)\ **Post date:** [October 3, 2023, 9:03am UTC](https://forum.katalon.com/t/excel-data-files-read-from-azure-pipeline/97997/8 "2023-10-03T09:03:42Z")
Thanks @kazurayam I found the exact issue and it is solved. The project is having some external jars which results conflicts with internal jars. i removed them and working fine now.