#!/usr/bin/python3.6
# -*- coding: utf-8 -*-
# @Time    : 2021/9/3 16:32
# @Author  : LXH
# @File    : excel_read.py

from openpyxl import load_workbook

class ReadExcel():
    def __init__(self, excel_path, sheetName):
        self.wb = load_workbook(excel_path)
        self.sheet = self.wb[sheetName]

    def getDataFromSheet(self):
        datalist = []
        for line in self.sheet:

            datalist.append(line[0].value)
        datalist.pop(0)
        return datalist

# if __name__ == '__main__':
#     excel_path = './../data_manage/test.xlsx'
#     sheetName = 'data_new'
#     re = ReadExcel(excel_path,sheetName)
#     print(re.getDataFromSheet())
41f78ed1c1a2c5e90522e6c79e478f593511ebd4
<mask token>


class ReadExcel:
    <mask token>
    <mask token>

<mask token>


class ReadExcel:
    <mask token>

    def getDataFromSheet(self):
        datalist = []
        for line in self.sheet:
            datalist.append(line[0].value)
        datalist.pop(0)
        return datalist

<mask token>


class ReadExcel:

    def __init__(self, excel_path, sheetName):
        self.wb = load_workbook(excel_path)
        self.sheet = self.wb[sheetName]

    def getDataFromSheet(self):
        datalist = []
        for line in self.sheet:
            datalist.append(line[0].value)
        datalist.pop(0)
        return datalist

from openpyxl import load_workbook


class ReadExcel:

    def __init__(self, excel_path, sheetName):
        self.wb = load_workbook(excel_path)
        self.sheet = self.wb[sheetName]

    def getDataFromSheet(self):
        datalist = []
        for line in self.sheet:
            datalist.append(line[0].value)
        datalist.pop(0)
        return datalist

#!/usr/bin/python3.6
# -*- coding: utf-8 -*-
# @Time    : 2021/9/3 16:32
# @Author  : LXH
# @File    : excel_read.py

from openpyxl import load_workbook

class ReadExcel():
    def __init__(self, excel_path, sheetName):
        self.wb = load_workbook(excel_path)
        self.sheet = self.wb[sheetName]

    def getDataFromSheet(self):
        datalist = []
        for line in self.sheet:

            datalist.append(line[0].value)
        datalist.pop(0)
        return datalist

# if __name__ == '__main__':
#     excel_path = './../data_manage/test.xlsx'
#     sheetName = 'data_new'
#     re = ReadExcel(excel_path,sheetName)
#     print(re.getDataFromSheet())