I am using python and i had a csv file with data in multiple sheets.
So we can read data from csv file using python as below
Suppose the data in data.csv file in sheet1 is below
what | are | you | doing | however
hello | that | would | be | useful
csv_file = "/home/user/csv_folder/data.csv"
for line in open(csv_file,'r'):
print line
..........
..........
The output for the above will be as below
"what are you doing however"
"hello that would be useful"
but in the same data.csv file, i had data in another sheet2 as below
This | will | be | second | sheet | data
That | would | lot | useful | now
Now what i am trying to do is to print the data which is present in another sheets(more than 1 sheets if present in a single csv file).