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 | usefulcsv_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).
Can anyone let me now how we can print the data in all the sheets present in a single csv
file ?
Can anyone please share a bit of python code that process more than one sheet present in a single csv file ?