I have a Excel name "CCP_MARGIN_2017-09-11_risk_cpm_stg.xlsx" in C drive. I am reading it and using

Hi,

are u sure about your file name, I had this type of problem when my file name or sheetname cross length (~36 char) .

I am using "openpyxl " module to work with Excel file and I found its really helpful and compatible with excel-

here are the sample, may help you

#---------------------------------------------------------------------------

import openpyxl

def openmyExcel():

workbookObj = openpyxl.load_workbook("C:\TC_Python\Test1.xlsx")

worksheetobj = workbookObj.get_sheet_by_name('Sheet1')

rowcout = worksheetobj.max_row

colCount = worksheetobj.max_column

Log.Message(rowcout)

Log.Message(colCount)

#-----------------------------------------------------------------------------

def readCellData():

workbookobj = openpyxl.load_workbook("C:\TC_Python\Test1.xlsx")

worksheetObj = workbookobj.get_sheet_by_name("Sheet1")

rowcount = worksheetObj.max_row

colcount = worksheetObj.max_column

for introw in range(1,rowcount):

celldata = worksheetObj.cell(row = introw ,column =1).value

Log.Message(celldata)

#-----------------------------------------------------------------------------

def readAlldatainExcel():

wbo = openpyxl.load_workbook("C:\TC_Python\Test1.xlsx")

wso = wbo.get_sheet_by_name("Sheet1")

intAllRow = wso.max_row

intAllCol = wso.max_column

for introw in range(1, intAllRow):

for intcol in range(1,intAllCol):

mydata= wso.cell(row= introw, column = intcol).value

#Log.Message(mydata)

if (mydata == None):

break

Log.Message(mydata)

#----------------------------------------------------------------------------------

def writeinExcel():

wbo = openpyxl.load_workbook("C:\TC_Python\Test1.xlsx")

wso = wbo.get_sheet_by_name("Sheet1")

intAllRow = wso.max_row

intAllCol = wso.max_column

for introw in range(1, intAllRow):

for intcol in range(1,intAllCol):

wso['A1'] = introw

mydata= wso.cell(row= introw, column = intcol).value

Log.Message(mydata)

if (mydata == None):

break

Log.Message(mydata)

#----------------------------------------------------------------------------------

def getSheetName():

wbo = openpyxl.load_workbook("C:\TC_Python\Test1.xlsx")

wso = wbo.get_sheet_names()

for shname in wso:

Log.Message(shname)