# Excel data files read from azure pipeline

**URL:** <https://forum.katalon.com/t/excel-data-files-read-from-azure-pipeline/97997>\
**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:** 1\
**Showing post:** 4

<div class="post-metadata">

**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")

</div>

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.

---

_[View the full topic](https://forum.katalon.com/t/excel-data-files-read-from-azure-pipeline/97997)._