Search
 
SCRIPT & CODE EXAMPLE
 
CODE EXAMPLE FOR PYTHON

Reading Excel and other Microsoft Office files

#read excel

pd.read_excel('/content/drive/My Drive/Site sharing/PSD Resources/Values.xls',index_col=None,header=0) #last two attributes are not compulsary

#attributes given after comma after filename
# if index_col given 0 then it will take 0th coloumn as its label so keeping it none will automatically print coloumn index as 0 ,1,2,3...
# if header will be given 1 then it will take 1st row data as its label,
  #if it is given 0 then it will take its respective row name as in excel file
Source by kadamjay.rf.gd #
 
PREVIOUS NEXT
Tagged: #Reading #Excel #Microsoft #Office #files
ADD COMMENT
Topic
Name
5+3 =