# Facing java.lang.Error: Unresolved compilation problem: \*in Katalon version 8.6.6 while getting sheet details using Excel keywords **URL:** \ **Category:** Bug Report\ **Tags:** platform-bugs, excel, web-testing, bugs-report, katalon-studio\ **Created:** [August 21, 2023, 11:00am UTC](https://forum.katalon.com/t/facing-java-lang-error-unresolved-compilation-problem-in-katalon-version-8-6-6-while-getting-sheet-details-using-excel-keywords/94030 "2023-08-21T11:00:50Z")\ **Posts on this page:** 8\ **Page:** 1
**Author:** ![bharathi.a](https://dub1.discourse-cdn.com/katalon/user_avatar/forum.katalon.com/bharathi.a/32/24695_2.png) [@bharathi.a](https://forum.katalon.com/u/bharathi.a)\ **Post date:** [August 21, 2023, 11:00am UTC](https://forum.katalon.com/t/facing-java-lang-error-unresolved-compilation-problem-in-katalon-version-8-6-6-while-getting-sheet-details-using-excel-keywords/94030/1 "2023-08-21T11:00:51Z")
![image](https://europe1.discourse-cdn.com/katalon/original/3X/b/4/b4ffe8111e5a9d6712d19d1e5f1f3ec14de1dbca.png) ---
**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:** [August 21, 2023, 11:46am UTC](https://forum.katalon.com/t/facing-java-lang-error-unresolved-compilation-problem-in-katalon-version-8-6-6-while-getting-sheet-details-using-excel-keywords/94030/2 "2023-08-21T11:46:52Z")
![スクリーンショット 2023-08-21 20.37.12](https://europe1.discourse-cdn.com/katalon/optimized/3X/f/f/ffff77e8c70bade4f35c80ee1039dae34566f26c_2_690x38.png) I think this one line of code is wrong. [`ExcelWorksheets.getExcelSheet()`](https://github.com/katalon-studio/katalon-excel-keyword/blob/master/ExcelKeywords/Keywords/com/kms/katalon/keyword/excel/ExcelKeywords.groovy) implements `getExcelSheet()` method, which returns [org.apache.poi.ss.usermodel.Sheet](https://poi.apache.org/apidocs/dev/org/apache/poi/ss/usermodel/Sheet.html). But the `Sheet` object does not implements `getValue()` method. Therefore this line would not compile. Also I have a doubt about the last fragment: ```auto Report", 1), 0) ``` I think `,0)` is just invalid. ---
**Author:** ![bharathi.a](https://dub1.discourse-cdn.com/katalon/user_avatar/forum.katalon.com/bharathi.a/32/24695_2.png) [@bharathi.a](https://forum.katalon.com/u/bharathi.a)\ **Post date:** [August 21, 2023, 12:08pm UTC](https://forum.katalon.com/t/facing-java-lang-error-unresolved-compilation-problem-in-katalon-version-8-6-6-while-getting-sheet-details-using-excel-keywords/94030/3 "2023-08-21T12:08:40Z")
![image](https://europe1.discourse-cdn.com/katalon/optimized/3X/7/a/7af094a6c3d4b22afe5ee75a56aee9fb049148dd_2_689x42.png) the above is the exact line to assign value to the variable **sheet01** since i used the Excel keywords katalon plugin from the katalon plugin store no the apache POI for this code. this line of code will read the value that is stored in my Excel file using the data files in (Katalon) the last .getValue(“column Name”,row number) ---
**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:** [August 21, 2023, 12:13pm UTC](https://forum.katalon.com/t/facing-java-lang-error-unresolved-compilation-problem-in-katalon-version-8-6-6-while-getting-sheet-details-using-excel-keywords/94030/4 "2023-08-21T12:13:12Z")
It seems that you changed your code from the original to a new one. Do you still have “java.lang.Error: Unresolved compilation problem: \*in Katalon…” ? ---
**Author:** ![bharathi.a](https://dub1.discourse-cdn.com/katalon/user_avatar/forum.katalon.com/bharathi.a/32/24695_2.png) [@bharathi.a](https://forum.katalon.com/u/bharathi.a)\ **Post date:** [August 21, 2023, 12:18pm UTC](https://forum.katalon.com/t/facing-java-lang-error-unresolved-compilation-problem-in-katalon-version-8-6-6-while-getting-sheet-details-using-excel-keywords/94030/5 "2023-08-21T12:18:56Z")
still i’m getting the same error ![image](https://europe1.discourse-cdn.com/katalon/optimized/3X/b/0/b0b3220ed680b8db92e5ebbf9cd8e562f225574c_2_690x39.png) this is the code returned in my log viewer ![image](https://europe1.discourse-cdn.com/katalon/optimized/3X/9/e/9ebb23b5608a8d03603eb27edd37a3fe0f714e86_2_690x37.png) and this is the code available in my test cases script tab. it worked fine in Katalon 7.7.2 since the Chrome driver issue I updated to Katalon version 8.6.6 then I’m getting this issue. not only this some of the variable name’s cases(lowercase to uppercase the one under the profile’s manual view is different thean than the one in \ script view) also changed (Global variables) under my profile i even reloaded my plugins ![image](https://europe1.discourse-cdn.com/katalon/original/3X/8/a/8aca29dee7f1a2b4ee6a34e95bd67d70ca344ab8.png) ---
**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:** [August 21, 2023, 12:21pm UTC](https://forum.katalon.com/t/facing-java-lang-error-unresolved-compilation-problem-in-katalon-version-8-6-6-while-getting-sheet-details-using-excel-keywords/94030/6 "2023-08-21T12:21:12Z")
I can not guess what happend to you. I have no idea. If you remove the black paints that hides some string values so that we can read them, then it may give us better idea. These black paints disturbes others to guess at all. ---
**Author:** ![bharathi.a](https://dub1.discourse-cdn.com/katalon/user_avatar/forum.katalon.com/bharathi.a/32/24695_2.png) [@bharathi.a](https://forum.katalon.com/u/bharathi.a)\ **Post date:** [August 21, 2023, 12:32pm UTC](https://forum.katalon.com/t/facing-java-lang-error-unresolved-compilation-problem-in-katalon-version-8-6-6-while-getting-sheet-details-using-excel-keywords/94030/7 "2023-08-21T12:32:33Z")
> [@kazurayam](#): > > If you remove the black paints that hides some strin Thanks for the suggestion i got the solution for the issue ![image](https://europe1.discourse-cdn.com/katalon/original/3X/c/4/c4b0c37860581696880ed7ed1a393f027f0a034a.png) it should be in this format but after migrating katalon from 7.7.2 to 8.6.6 it converts the code from the above to this Don’t know this is a feature which tampering the code/script ![image](https://europe1.discourse-cdn.com/katalon/optimized/3X/0/c/0c60ff3b3039cfc01d9a5b12d57a185da1aed681_2_690x43.png) after removing the below method scripts are working fine. ![image](https://europe1.discourse-cdn.com/katalon/original/3X/f/4/f4e2ef9f268973491decc9e2a048fd796bfa37e5.png) ---
**Author:** ![bharathi.a](https://dub1.discourse-cdn.com/katalon/user_avatar/forum.katalon.com/bharathi.a/32/24695_2.png) [@bharathi.a](https://forum.katalon.com/u/bharathi.a)\ **Post date:** [August 21, 2023, 1:35pm UTC](https://forum.katalon.com/t/facing-java-lang-error-unresolved-compilation-problem-in-katalon-version-8-6-6-while-getting-sheet-details-using-excel-keywords/94030/8 "2023-08-21T13:35:10Z")
@ [Elly\_Tran](http://forum.katalon.com/u/Elly_Tran) I used Katalon studio 7.7.2 due to the chrome driver change I switched to 8.6.6 I’m facing the following issue when I open my project in Katalon studio 7.7.2 the script view shows the below code ![image](https://europe1.discourse-cdn.com/katalon/optimized/3X/1/e/1e5618e07a4e8dd6899815279bd2d4984416c2e3_2_690x32.png) when I open the same project file in Katalon studio 8.6.6 the script view shows the below code by default new version adds the **ExcelKeyword.getExcelSheet()** method to the existing code and it fails the scripts. ![image](https://europe1.discourse-cdn.com/katalon/original/3X/8/2/82dafd464903195079a66b1e9e690c7d9e7c6f3e.png) please use the following code to reproduce the same 1. create a project in 7.7.2 and save it in a test case 2. open the project file in 8.6.6 sheet01=**findTestData(**‘_path of Data File in data filesfolder_’**).getValue(**‘_columName_’,rowNumber **)** println(sheet01)