How to get Row count of Excel attached and how to get data from excel sheet

[GANESH23]

Hi Team,

I want to get the row count on sheet wise from excel attached and also get the once column data from excel. 

can someone help me on this?

Thanks,

Ganesh

[asifnoor · Accepted solution]

Hello Ganesh,

Refer to this link which has sample code to check how to reach the csv/excel file.

Excel Parser 

CSV Parser 

Mark the comment as a correct answer and helpful if this has helped to solve the problem.

[Ankur Bawiskar]

@GANESH23 

you can use GlideExcel parser and read the rows

check this link

How to populate Manager field(reference type) and effective date from excel sheet when using Glide E... 

If my response helped please mark it correct and close the thread so that it benefits future readers.

[Ankur Bawiskar]

@GANESH23 

Thank you for marking my response as helpful.

As per new community feature you can mark multiple responses as correct.

If my response helped please mark it correct as well so that it benefits future readers.