Python_ImportData_Excel

#!/usr/bin/env python
# -*- coding: utf-8 -*-
# @Time    : 2017/1/16 15:45
# @Author  : Albert
# @Site    :
# @File    : DataSource.py
# @Software: PyCharm Community Edition
# Function:  get value of col in excel file
#eg cols=4 rows=5

#######################################
import pyautogui
import time
import openpyxl

################define ####################

class Data_Resource():
#############get the path of excel and sheet name
   def GetFileData(FilePath, SheetName):
      Name_Excel_File = FilePath
      Name_Excel_sheet1 = SheetName

      print(FilePath,SheetName)
      return (Name_Excel_File, Name_Excel_sheet1)
########TEST01####

# Data_Location.GetFileData(‘adsf‘,0,0)

   def GetRowNumber(RowNumber,ColNumber):
      print(RowNumber,ColNumber)
      return (RowNumber,ColNumber)

   def Data_Openpyxl_Action(Name_Excel_File, Name_Excel_sheet1):
      global wb, current
      wb = openpyxl.load_workbook(Name_Excel_File)
      current = wb.get_sheet_by_name(Name_Excel_sheet1)
      print(current)
      return(wb,current)

# ####################open data source  ,  excel######################################

   def Data_GetColvalue(Datalist,RowNumber,j):
      #列准 行多一位...
      for i in range(1, RowNumber+1, 1):
         Datalist.append(str(current.cell(row=i, column=j).value))
      print(Datalist)
      return (Datalist)

   def Data_GetAllvalue(Datalist2,RowNumber,ColNumber):
      #列准 行多一位...
      for j in range(1,ColNumber,1):
         for i in range(1, RowNumber+1, 1):
            Datalist2.append(str(current.cell(row=i, column=j).value))
      print(Datalist2)
      return (Datalist2)


   def Dataprint1(RowNumber,Datalist):
      for i in range(RowNumber):
         print(‘######################‘)
         print(Datalist[i])
      return (Datalist)
   def Dataprint2(Datalist2):
         print(Datalist2)
         return (Datalist2)


################_init_.py#############

from  DataSource import *


FilePath=r‘G:\Person_Code\Python\Data2017_excel\Data2017.xlsx‘
SheetName=‘Userinfor‘
Datalist=[]
Datalist2=[]
# print(FilePath,‘/‘,SheetName)

Fileinfor=Data_Resource.GetFileData(FilePath,SheetName)
print(Fileinfor)
Data_Resource.GetRowNumber(5,4)
Data_Resource.Data_Openpyxl_Action(FilePath,SheetName)
# Data_Resource.Data_GetColvalue(Datalist,6,4)
Data_Resource.Data_GetAllvalue(Datalist2,5,5)
# Data_Resource.Dataprint1(5,Datalist)
Data_Resource.Dataprint2(5,5,Datalist2)

Python_ImportData_Excel

原文：http://www.cnblogs.com/albertzz1987/p/6344187.html