| | |
|---|
| | | local_time = time.strftime("%Y%m%dT%H%M%S", time.localtime(time.time())) |
|---|
| | | file_name = "{}/{}_{}.xls".format(dest_dir, code, local_time) |
|---|
| | | file_name_txt = "{}/{}_{}.txt".format(dest_dir, code, local_time) |
|---|
| | | openfile = open(file_name_txt, 'w') |
|---|
| | | try: |
|---|
| | | with open(file_name_txt, 'w') as openfile: |
|---|
| | | for data in datas: |
|---|
| | | openfile.write(json.dumps(data) + "\n") |
|---|
| | | finally: |
|---|
| | | openfile.close() |
|---|
| | | wb = xlwt.Workbook(encoding="utf-8") |
|---|
| | | ws = wb.add_sheet('sheet1') |
|---|
| | | ws.write(0, 0, '序号') |
|---|
| | |
|---|
| | | |
|---|
| | | |
|---|
| | | if __name__ == "__main__": |
|---|
| | | export_l2_excel("002765") |
|---|
| | | export_l2_excel("002178") |
|---|
