在Python中从另一个文件导入列表

Question

我在同一个目录下有两个文件:

func.py:

import openpyxl
def openText():
wb = openpyxl.load_workbook('/Users/*****/*****/****/****/*****/main/Sentences.xlsx')
sheet = wb["Sheet1"]
i = 2
Text = []
Row = sheet[f'A{i}'].value
while Row != None:
Text.append(Row)
i += 1
Row = sheet[f'A{i}'].value
return Text

main.py:

from func import Text
from func import openText
openText()
print[Text]

文本列表应该被导入，但是我得到这个错误:

cannot import name 'Text' from 'func'

Answer 1

在func.py文件中全局声明Text。在方法中添加语句global Text.

import openpyxl
Text = []
def openText():
wb = openpyxl.load_workbook('/Users/*****/*****/****/****/*****/main/Sentences.xlsx')
sheet = wb["Sheet1"]
i = 2
Row = sheet[f'A{i}'].value
global Text
while Row != None:
Text.append(Row)
i += 1
Row = sheet[f'A{i}'].value
return Text

在main.py文件中，调用openText，您将从func.py文件中获得相同的Text:

from func import Text
from func import openText
x=openText()
print(x)