519026 519026 519026 519026 jsonpgz({"fundcode":"519026","name":"海富通中小盘混合","jzrq":"2023-07-18","dwjz":"1.4806","gsz":"1.4598","gszzl":"-1.41","gztime":"2023-07-19 14:32"}); jsonpgz({"fundcode":"519026","name":"海富通中小盘混合","jzrq":"2023-07-18","dwjz":"1.4806","gsz":"1.4598","gszzl":"-1.41","gztime":"2023-07-19 14:32"}); jsonpgz({"fundcode":"519026","name":"海富通中小盘混合","jzrq":"2023-07-18","dwjz":"1.4806","gsz":"1.4598","gszzl":"-1.41","gztime":"2023-07-19 14:32"}); jsonpgz({"fundcode":"519026","name":"海富通中小盘混合","jzrq":"2023-07-18","dwjz":"1.4806","gsz":"1.4598","gszzl":"-1.41","gztime":"2023-07-19 14:32"}); [400015, '012043', 501012, '011925', '001630', '015073', '014162', '010125', '013841', '015755', '008280', '013491', '006229', '001856', '015755', '010952', '012414', '007491', 519026] [400015, '012043', 501012, '011925', '001630', '015073', '014162', '010125', '013841', '015755', '008280', '013491', '006229', '001856', '015755', '010952', '012414', '007491', 519026] [400015, '012043', 501012, '011925', '001630', '015073', '014162', '010125', '013841', '015755', '008280', '013491', '006229', '001856', '015755', '010952', '012414', '007491', 519026] [400015, '012043', 501012, '011925', '001630', '015073', '014162', '010125', '013841', '015755', '008280', '013491', '006229', '001856', '015755', '010952', '012414', '007491', 519026] 18 18 18 18 <Response [200]> <Response [200]> <Response [200]> <Response [200]> <Worksheet "Sheet1"> <Worksheet "Sheet1"> <Worksheet "Sheet1"> <Worksheet "Sheet1"> http://fundgz.1234567.com.cn/js/519026.js http://fundgz.1234567.com.cn/js/519026.js http://fundgz.1234567.com.cn/js/519026.js http://fundgz.1234567.com.cn/js/519026.js <openpyxl.workbook.workbook.Workbook object at 0x00000218F0AFC7F0> <openpyxl.workbook.workbook.Workbook object at 0x00000218F0AF1D90> <openpyxl.workbook.workbook.Workbook object at 0x00000218F0B0FA60> <openpyxl.workbook.workbook.Workbook object at 0x00000218F0B0FB50>
时间: 2023-07-24 07:15:06 浏览: 117
主动权益基金2021年年报分析:机构持有比例微升,全年业绩“奖勤罚懒”.pdf
根据你提供的信息,代码成功获取到了基金代码为519026的数据,并且返回了正确的结果。接下来,你可以使用以下代码将数据写入Excel表格的第二列:
```python
import openpyxl
# 打开Excel文件
workbook = openpyxl.load_workbook('基金记录.xlsx')
# 选择第一个工作表
sheet = workbook['Sheet1']
# 将数据写入第二列
data = [519026, 519026, 519026, 519026] # 假设这是获取到的基金数据
for i in range(len(data)):
sheet.cell(row=i+1, column=2).value = data[i]
# 保存修改后的Excel文件
workbook.save('基金记录.xlsx')
# 关闭Excel文件
workbook.close()
```
请确保代码中的`'基金记录.xlsx'`是你实际保存数据的Excel文件名,并且文件已经存在于当前工作目录中。运行以上代码后,应该能够将基金代码写入Excel表格的第二列。
如果你仍然遇到问题,请提供更多关于你的代码和错误信息的信息,以便我能够更好地帮助你解决问题。
阅读全文