<p>试试下面的方法</p>
<pre class="lang-py prettyprint-override"><code>
import random
import xlsxwriter
first_names = ['ABCD', 'EFGH', 'IJKL', 'MNOP', 'QRST', 'UVWX', 'YZ']
last_names = ['ABCD', 'EFGH', 'IJKL', 'MNOP', 'QRST', 'UVWX', 'YZ']
street_names = ['indralok', 'mindspace', 'marine drive', 'kora kendra', 'bamdstand', 'mount mary', 'milan', 'paris','dubai', 'dindoshi', 'magathane', 'arnala']
cities_names = ['mumbai', 'banglore', 'pune', 'lucknow', 'patna', 'goa', 'ahmedabad', 'sydney', 'melbourne', 'brisbane','perth']
states = ['AL', 'AK', 'AZ', 'AR', 'CA', 'CO', 'CT', 'DC', 'DE', 'FL', 'GA', 'HI', 'ID', 'IL', 'IN', 'IA', 'KS', 'KY','LA', 'ME', 'MD', 'MA', 'MI', 'MN', 'MS', 'MO', 'MT', 'NE', 'NV', 'NH', 'NJ', 'NM', 'NY', 'NC', 'ND', 'OH','OK', 'OR', 'PA', 'RI', 'SC', 'SD', 'TN', 'TX', 'UT', 'VT', 'VA', 'WA', 'WV', 'WI', 'WY']
N = 10
workbook = xlsxwriter.Workbook('output.xlsx')
worksheet = workbook.add_worksheet()
def get_random_value(input_list):
return input_list[random.randint(0, len(input_list)-1)]
worksheet.write(0, 0, "First Name")
worksheet.write(0, 1, "Last Name")
worksheet.write(0, 2, "Street")
worksheet.write(0, 3, "City")
worksheet.write(0, 4, "State")
for i in range(1,N+1):
worksheet.write(i, 0, get_random_value(first_names))
worksheet.write(i, 1, get_random_value(last_names))
worksheet.write(i, 2, get_random_value(street_names))
worksheet.write(i, 3, get_random_value(cities_names))
worksheet.write(i, 4, get_random_value(states))
workbook.close()
</code></pre>