从excel读取列数据，生成列表文件或者csv文件

import openpyxl
import matplotlib.pyplot as plt

import pandas as pd
import csv
import codecs


# col_range = ws['B:E']
# for col in col_range: # 打印BC两列单元格中的值内容
#     for cell in col:
#         print(len(col))
#         print(cell.value)
class Datatrans(object):
    def __init__(self):
        pass
    def excel_to_list(self, col):
        list1 = []
        for cell in col:
            list1.append(cell.value)
            list1 = list(filter(None, list1))
        print(list1)
        return list1
        
    
    def writer_csv(self, col):
        list = self.excel_to_list(col)
        name=['G']
        test=pd.DataFrame(columns=name,data=list)#数据有三列，列名分别为one,two,three
        print(test)
        test.to_csv('csv.csv',encoding='utf-8')
        print("保存文件成功，处理结束")
        
        
# list1 = []
# for cell in B:
#     list1.append(cell.value)
#     list1 = list(filter(None, list1))
# print(list1)
if __name__ == "__main__":
    wb = openpyxl.load_workbook('data1.xlsx')
    # sheets = wb.sheetnames
    ws = wb.active  # 当前活跃的表单
    B = ws['C']
    
    data = Datatrans()
    data.writer_csv(B)