import xlrd
from xlrd import open_workbook


class ExcelOperations(object):
    def __init__(self, *selected_test_case_values):
        self._selected_test_case_values=selected_test_case_values

    def __str__(self):
        return (" TestCaseid = {0}".format(self._selected_test_case_values))

workBook=open_workbook('C:/Users/rahul.mishra/Desktop/clearcare_new/Excel_Input.xlsx')
for sheet in workBook.sheets():
    if sheet.name != "RestClientData":
        continue
    numberOfRows=sheet.nrows
    numberOfColumns=sheet.ncols
    # data processing logic
    values = []
    for row in range(1, numberOfRows):
        value_list = []
        for col in range(1, numberOfColumns):
            # import pdb;pdb.set_trace()
            value=(sheet.cell(row,col).value)
            try:
                value=float(value)
                value_list.append(value)
            except ValueError:
                value_list.append(value)
            # finally:
            #     values.append(value)

        # item=ExcelOperations(*values)
        values.append(value_list)

#printing the items from list
for item in values:
    # import pdb;pdb.set_trace()
    print(item)
import xlrd
from xlrd import open_workbook


class ExcelOperations(object):
    def __init__(self, *selected_test_case_values):
        self._selected_test_case_values=selected_test_case_values

    def __str__(self):
        return (" TestCaseid = {0}".format(self._selected_test_case_values))

workBook=open_workbook('C:/Users/rahul.mishra/Desktop/clearcare_new/Excel_Input.xlsx')
for sheet in workBook.sheets():
    if sheet.name != "RestClientData":
        continue
    numberOfRows=sheet.nrows
    numberOfColumns=sheet.ncols
    # data processing logic
    values = []
    for row in range(1, numberOfRows):
        value_list = []
        for col in range(1, numberOfColumns):
            # import pdb;pdb.set_trace()
            value=(sheet.cell(row,col).value)
            try:
                value=float(value)
                value_list.append(value)
            except ValueError:
                value_list.append(value)
            # finally:
            #     values.append(value)

        # item=ExcelOperations(*values)
        values.append(value_list)

#printing the items from list
for item in values:
    # import pdb;pdb.set_trace()
    print(item)
# data processing logic # import pdb;pdb.set_trace() # finally: #     values.append(value) # item=ExcelOperations(*values) #printing the items from list # import pdb;pdb.set_trace()