Is it possible to read from different sheets in a csv file?

Hi,

Suppose I have a csv file which has 5 sheets , like excel.
Is it possible to read data from different sheets ?
Thanks a lot

For a particular function , I want to read data from one sheet and for other function I want to read data from another sheet.

@ulrich could you please advise on this? Thanks a lot in advance

A CSV file only has one sheet. Or do you mean two CSV files?

Hi,
Two csv files should also solve the purpose , but how?

By uisng two different readCSV commands?

Yes it’s possibile, you must change the csv to read before use COL command.

Okay , Thank you so much
@newuserkantu @ulrich
Also can we map data in different CSV files using a common global variable?
Thanks