read data from Excel and convert to JSON using groovy script in scriptrunner

[sgole]

i have readied  data from excel and store in List<List<String>> . the data is below .now i want to convert below data in json format ..how can i do that 

[sgole · Accepted solution]

thanks . i have solved myself by referring below link,'

https://www.dev2qa.com/convert-excel-to-json-in-java-example/

[Mehhss]

May I ask how did you read the excel data from Scriptrunner using groovy script?

[Nic Brough (Adaptavist)]

I am slightly unsure of what you are trying to do here. 

Your first line of code is reading a .csv file and you want the output in JSON format, I understand that, but what does this have to do with a REST endpoint?

Perhaps if you could explain what you're trying to do overall, rather than think of a specific solution or function you think may help, we can better guide you?

[sgole]

@Nic Brough (Adaptavist)  i have modified question please check