Forum Discussion

kbhaskar's avatar
kbhaskar
Occasional Contributor
8 years ago

how to read or write data from particular sheet in a workbook of excel

hey hi team    can anyone suggest me how to get a particular value from particular sheet in an excel    thanks in advance
shankar_r's avatar
shankar_r
Community Hero
8 years ago

Hi,

 

You refer below links.

 

For Write

For Read

 

Let me know if you want to achieve specific scenario with Excel

kbhaskar's avatar
kbhaskar
Occasional Contributor
8 years ago

scenario

 

for example there is workbook with three sheets orders,product id's and users, here i need to get or set data to sheet of product id's and i know activesheet but the product id's sheet is inactive.

 

thanks for replying