Python读取Json字典写入Excel表格的方法

文章主要为大家详细介绍了Python读取Json字典写入Excel表格的方法,具有一定的参考价值,感兴趣的小伙伴们可以参考一下

需求:

因需要将一json文件中大量的信息填入一固定格式的Excel表格,单纯的复制粘贴肯定也能完成,但是想偷懒一下,于是借助Python解决问题。

环境:

Windows7 +Python2.7 +Xlwt

具体分析:

原始文件为json列表,列表中有多个字典,生成Excel文件需要将列表中的字典的键值按键对应排列,也就是说,所有为“XX”的键对应的值写在一列,且每个字典中的不同键的键值保证在同一行。

解决思路是,读取json文件,然后遍历字典的键和值,读完第一个字典并写入Excel后换行,读取第二个字典。

代码:

1

2

3

4

5

6

7

8

9

10

11

12

13

14

15

16

17

18

19

20

21

22

23

24

25

26

27

28

29

30

31

32

33

34

35

36

37

38

39

40

41

42

43

44

# -*- coding: utf-8 -*-

importxlwt

importjson


# 创建excel工作表

workbook =xlwt.Workbook(encoding='utf-8')

worksheet =workbook.add_sheet('sheet1')


# 设置表头

worksheet.write(0, 0, label='NAME')

worksheet.write(0, 1, label='LEN')

worksheet.write(0, 2, label='ID')

worksheet.write(0, 3, label='OTHER')



# 读取json文件

with open('test.json', 'r') as f:

 data =json.load(f)


# 将json字典写入excel

# 变量用来循环时控制写入单元格,感觉有更好的表达方式

val1 =1

val2 =1

val3 =1

val4 =1

forlist_item indata:

 forkey, value inlist_item.items():

  ifkey =="NAME":

   worksheet.write(val1, 0, value)

   val1 +=1

  elifkey =="LEN":

   worksheet.write(val2, 1, value)

   val2 +=1

  elifkey =="ID":

   worksheet.write(val3, 2, value)

   val3 +=1

  elifkey =="OTHER":

   worksheet.write(val4, 3, value)

   val4 +=1

  else:

   pass


# 保存

workbook.save('OK.xls')

辅助文件:

1

2

3

4

5

6

7

8

9

10

11

12

13

14

15

16

17

18

19

20

21

22

23

24

25

26

27

28

29

30

31

32

33

34

35

36

37

38

39

40

test.json


[

  {

   "OTHER": "code",

   "NAME": "whc",

   "LEN": 100,

   "ID": "01-0001"

  },

  {

   "OTHER": "house",

   "NAME": "ikd",

   "LEN": 200,

   "ID": "01-0002"

  },

  {

   "OTHER": "thank",

   "NAME": "qxf",

   "LEN": 300,

   "ID": "01-0003"

  },

  {

   "OTHER": "music",

   "NAME": "kmn",

   "LEN": 400,

   "ID": "01-0004"

  },

  {

   "OTHER": "big",

   "NAME": "vbf",

   "LEN": 500,

   "ID": "01-0005"

  },

  {

   "OTHER": "over",

   "NAME": "wsr",

   "LEN": 600,

   "ID": "01-0006"

  }

]

结果示例:

ok.xls

其它说明:

1、以上代码直接生成结果与图中示例对齐方式不同,可在代码中加入格式控制。

2、实际使用的过程中列表字典中还包含了字典,同样进入遍历即可。

3、代码很简陋,希望各位提意见帮忙改进。

以上就是本文的全部内容,希望对大家的学习有所帮助

https://vk.com/topic-231169012_54125818

https://vk.com/topic-231169012_54125835

https://vk.com/topic-231169012_54125847

https://vk.com/topic-231169012_54125862

https://vk.com/topic-231169012_54125874

https://vk.com/topic-231169012_54125889

https://vk.com/topic-231169012_54125902

https://vk.com/topic-231169012_54125910

https://vk.com/topic-231169012_54125922

https://vk.com/topic-231169012_54125931

https://vk.com/topic-231169012_54125938

https://vk.com/topic-231169012_54125948

https://vk.com/topic-231169012_54125955

https://vk.com/topic-231169012_54125965

https://vk.com/topic-231169012_54125976

https://vk.com/topic-231169012_54125987

https://vk.com/topic-231169012_54125999

https://vk.com/topic-231169012_54126010

https://vk.com/topic-231169012_54126020

https://vk.com/topic-231169012_54126029

https://vk.com/topic-231169012_54126039

https://vk.com/topic-231169012_54126063

https://vk.com/topic-231169012_54126073

https://vk.com/topic-231169012_54126085

https://vk.com/topic-231169012_54126096

https://vk.com/topic-231169012_54126101

https://vk.com/topic-231169012_54126112

https://vk.com/topic-231169012_54126123

https://vk.com/topic-231169012_54126130

https://vk.com/topic-231169012_54126140

https://vk.com/topic-231169012_54126146

https://vk.com/topic-231169012_54126153

https://vk.com/topic-231169012_54126162

https://vk.com/topic-231169012_54126170

https://vk.com/topic-231169012_54126179

https://vk.com/topic-231169012_54126190

https://vk.com/topic-231169012_54126205

https://vk.com/topic-231169012_54126212

https://vk.com/topic-231169012_54126225

https://vk.com/topic-231169012_54126236

https://vk.com/topic-231169012_54126243

https://vk.com/topic-231169012_54126253

https://vk.com/topic-231169012_54128507

https://vk.com/topic-231169012_54128521

https://vk.com/topic-231169012_54128549

https://vk.com/topic-231169012_54128579

https://vk.com/topic-231169012_54128597

https://vk.com/topic-231169012_54128630

https://vk.com/topic-231169012_54128653

https://vk.com/topic-231169012_54128674

https://vk.com/topic-231169012_54128689

https://vk.com/topic-231169012_54128705

https://vk.com/topic-231169012_54128722

https://vk.com/topic-231169012_54128742

https://vk.com/topic-231169012_54128764

https://vk.com/topic-231169012_54128781

https://vk.com/topic-231169012_54128833

https://vk.com/topic-231169012_54128861

https://vk.com/topic-231169012_54128890

https://vk.com/topic-231169012_54128911

https://vk.com/topic-231169012_54128952

https://vk.com/topic-231169012_54128983

https://vk.com/topic-231169012_54129008

https://vk.com/topic-231169012_54129048

https://vk.com/topic-231169012_54129081

https://vk.com/topic-231169012_54129112

https://vk.com/topic-231169012_54129145

https://vk.com/topic-231169012_54129182

https://vk.com/topic-231169012_54129207

https://vk.com/topic-231169012_54129231

https://vk.com/topic-231169012_54129251

https://vk.com/topic-231169012_54129269

https://vk.com/topic-231169012_54129276

https://vk.com/topic-231169012_54129291

https://vk.com/topic-231169012_54129300

https://vk.com/topic-231169012_54129307

https://vk.com/topic-231169012_54129321

https://vk.com/topic-231169012_54129327

https://vk.com/topic-231169012_54129338

https://vk.com/topic-231169012_54129343

https://vk.com/topic-231169012_54129353

https://vk.com/topic-231169012_54129370

https://vk.com/topic-231169012_54129377

https://vk.com/topic-231169012_54129396

https://vk.com/topic-231169012_54129409

https://vk.com/topic-231169012_54129421

https://vk.com/topic-231169012_54129432

https://vk.com/topic-231169012_54129444

https://vk.com/topic-231169012_54129459

https://vk.com/topic-231169012_54129471

https://vk.com/topic-231169012_54129488

https://vk.com/topic-231169012_54129493

https://vk.com/topic-231169012_54129565

https://vk.com/topic-231169012_54129582

https://vk.com/topic-231169012_54129603

https://vk.com/topic-231169012_54129621

https://vk.com/topic-231169012_54129635

https://vk.com/topic-231169012_54129654

https://vk.com/topic-231169012_54129666

https://vk.com/topic-231169012_54129676

https://vk.com/topic-231169012_54129690

https://vk.com/topic-231169012_54129708

https://vk.com/topic-231169012_54129726

https://vk.com/topic-231169012_54129742

https://vk.com/topic-231169012_54129766

https://vk.com/topic-231169012_54129792

https://vk.com/topic-231169012_54129818

https://vk.com/topic-231169012_54129840

https://vk.com/topic-231169012_54129859

https://vk.com/topic-231169012_54129874

https://vk.com/topic-231169012_54129890

https://vk.com/topic-231169012_54129911

https://vk.com/topic-231169012_54129930

https://vk.com/topic-231169012_54129953

https://vk.com/topic-231169012_54129977

https://vk.com/topic-231169012_54129992

https://vk.com/topic-231169012_54130011

https://vk.com/club231169012?from=groups

https://vk.com/club230870556?from=groups

https://vk.com/topic-231169012_54130035

https://vk.com/topic-231169012_54130052

https://vk.com/topic-231169012_54130066

https://vk.com/topic-231169012_54130078

https://vk.com/topic-231169012_54130090

https://vk.com/topic-231169012_54130102

https://vk.com/topic-231169012_54130116

https://vk.com/topic-231169012_54130123

https://vk.com/topic-231169012_54130137

https://vk.com/topic-231169012_54130147

https://vk.com/topic-231169012_54130159

https://vk.com/topic-231169012_54130164

https://vk.com/topic-231169012_54130173

https://vk.com/topic-231169012_54130184

https://vk.com/topic-231169012_54130190

https://vk.com/topic-231169012_54130199

https://vk.com/topic-231169012_54130209

https://vk.com/topic-231169012_54130215

https://vk.com/topic-231169012_54130223

https://vk.com/topic-231169012_54130233

https://vk.com/topic-231169012_54130240

https://vk.com/topic-231169012_54130242

https://vk.com/topic-231169012_54130254

https://vk.com/topic-231169012_54130262

https://vk.com/topic-231169012_54130269

https://vk.com/topic-231169012_54130282

https://vk.com/topic-231169012_54130314

https://vk.com/topic-231169012_54130331

https://vk.com/topic-231169012_54130331

https://vk.com/topic-231169012_54130492

https://vk.com/topic-231169012_54130519

https://vk.com/topic-231169012_54130540

https://vk.com/topic-231169012_54128521

https://vk.com/topic-231169012_54130560

https://vk.com/topic-231169012_54130610

https://vk.com/topic-231169012_54130628

https://vk.com/topic-231169012_54130643

https://vk.com/topic-231169012_54130664

https://vk.com/topic-231169012_54130682

https://vk.com/topic-231169012_54130700

https://vk.com/topic-231169012_54130734

https://vk.com/topic-231169012_54130757

https://vk.com/topic-231169012_54130775

https://vk.com/topic-231169012_54130799

https://vk.com/topic-231169012_54130819

https://vk.com/topic-231169012_54130835

https://vk.com/topic-231169012_54130837

https://vk.com/topic-231169012_54130844

https://vk.com/topic-231169012_54130852

https://vk.com/topic-231169012_54130991

https://vk.com/topic-231169012_54130859

https://vk.com/topic-231169012_54130879

https://vk.com/topic-231169012_54130896

https://vk.com/topic-231169012_54130905

https://vk.com/topic-231169012_54130911

https://vk.com/topic-231169012_54130920

https://vk.com/topic-231169012_54130936

https://vk.com/topic-231169012_54130942

https://vk.com/topic-231169012_54130953

https://vk.com/topic-231169012_54130963

https://vk.com/topic-231169012_54130970

https://vk.com/topic-231169012_54131016

https://vk.com/topic-231171290_54432416

https://vk.com/topic-231171290_54432430

https://vk.com/topic-231171290_54432451

https://vk.com/topic-231171290_54432461

https://vk.com/topic-231171290_54440001

https://vk.com/topic-231171290_54440016

https://vk.com/topic-231171290_54440025

https://vk.com/topic-231171290_54440039

https://vk.com/topic-231171290_54440050

https://vk.com/topic-231171290_54440074

https://vk.com/topic-231171290_54440085

https://vk.com/topic-231171290_54440097

https://vk.com/topic-231171290_54440097

https://vk.com/topic-231171290_54440130

https://vk.com/topic-231171290_54440155

https://vk.com/topic-231171290_54440242

https://vk.com/topic-231171290_54440286

https://vk.com/topic-231171290_54440352

https://vk.com/topic-231171290_54440368

https://vk.com/topic-231171290_54440386

https://vk.com/topic-231171290_54440404

https://vk.com/topic-231171290_54440425

https://vk.com/topic-231171290_54440437

https://vk.com/topic-231171290_54440447

https://vk.com/topic-231171290_54440461

https://vk.com/topic-231171290_54440473

https://vk.com/topic-231171290_54440483

https://vk.com/topic-231171290_54440503

https://vk.com/topic-231171290_54440517

https://vk.com/topic-231171290_54440527

https://vk.com/topic-231171290_54440544

https://vk.com/topic-231171290_54440558

https://vk.com/topic-231171290_54440570

https://vk.com/topic-231171290_54440586

https://vk.com/topic-231171290_54440602

https://vk.com/topic-231171290_54440620

https://vk.com/topic-231171290_54440633

https://vk.com/topic-231171290_54440644

https://vk.com/topic-231171290_54440653

https://vk.com/topic-231171290_54440662

https://vk.com/topic-231171290_54440673

https://vk.com/topic-231171290_54440679

https://vk.com/topic-231171290_54440691

https://vk.com/topic-231171290_54440706

https://vk.com/topic-231171290_54440717

https://vk.com/topic-231171290_54440735

https://vk.com/topic-231171290_54440748

https://vk.com/topic-231171290_54440762

https://vk.com/topic-231171290_54440772

https://vk.com/topic-231171290_54440787

https://vk.com/topic-231171290_54440796

https://vk.com/topic-231171290_54440804

https://vk.com/topic-231171290_54440816

https://vk.com/topic-231171290_54440828

https://vk.com/topic-231171290_54440843

https://vk.com/topic-231171290_54440849

https://vk.com/topic-231171290_54440854

https://vk.com/topic-231171290_54440865

https://vk.com/topic-231171290_54440875

https://vk.com/topic-231171290_54440881

https://vk.com/topic-231171290_54440889

https://vk.com/topic-231171290_54440900

https://vk.com/topic-231171290_54440905

https://vk.com/topic-231171290_54440913

https://vk.com/topic-231171290_54440921

https://vk.com/topic-231171290_54440931

https://vk.com/topic-231171290_54440939

https://vk.com/topic-231171290_54440946

https://vk.com/topic-231171290_54440954

https://vk.com/topic-231171290_54440960

https://vk.com/topic-231171290_54440967

https://vk.com/topic-231171290_54440970

https://vk.com/topic-231171290_54440976

https://vk.com/topic-231171290_54440980

https://vk.com/topic-231171290_54440985

https://vk.com/topic-231171290_54440992

https://vk.com/topic-231171290_54440999

https://vk.com/topic-231171290_54441006

https://vk.com/topic-231171290_54441008

https://vk.com/topic-231171290_54441013

https://vk.com/topic-231171290_54441021

https://vk.com/topic-231171290_54441025

https://vk.com/topic-231171290_54441029

https://vk.com/topic-231171290_54441037

https://vk.com/topic-231171290_54441042

https://vk.com/topic-231171290_54441045

https://vk.com/topic-231171290_54441051

https://vk.com/topic-231171290_54441057

https://vk.com/topic-231171290_54441061

https://vk.com/topic-231171290_54441073

https://vk.com/topic-231171290_54441078

https://vk.com/topic-231171290_54441082

https://vk.com/topic-231171290_54441086

https://vk.com/topic-231171290_54441091

https://vk.com/topic-231171290_54441095

https://vk.com/topic-231171290_54441098

https://vk.com/topic-231171290_54441104

https://vk.com/topic-231171290_54441110

https://vk.com/topic-231171290_54441116

https://vk.com/topic-231171290_54441121

https://vk.com/topic-231171290_54441128

https://vk.com/topic-231171290_54441136

https://vk.com/topic-231171290_54441140

https://vk.com/topic-231171290_54441146

https://vk.com/topic-231171290_54441156

https://vk.com/topic-231171290_54441160

https://vk.com/topic-231171290_54441165

https://vk.com/topic-231171290_54441176

https://vk.com/topic-231171290_54441184

https://vk.com/topic-231171290_54441190

https://vk.com/topic-230870556_53696434

https://vk.com/topic-230870556_53696695

https://vk.com/topic-230870556_53696742

https://vk.com/topic-230870556_53696776

https://vk.com/topic-230870556_53696845

https://vk.com/topic-230870556_53696896

https://vk.com/topic-230870556_53696935

https://vk.com/topic-230870556_53696957

https://vk.com/topic-230870556_53696983

https://vk.com/topic-230870556_53697009

https://vk.com/topic-230870556_53697044

https://vk.com/topic-230870556_53697073

https://vk.com/topic-230870556_53697089

https://vk.com/topic-230870556_53697116

https://vk.com/topic-230870556_53697124

https://vk.com/topic-230870556_53697136

https://vk.com/topic-230870556_53697150

https://vk.com/topic-230870556_53697160

https://vk.com/topic-230870556_53697171

https://vk.com/topic-230870556_53697183

https://vk.com/topic-230870556_53697187

https://vk.com/topic-230870556_53697205

https://vk.com/topic-230870556_53697211

https://vk.com/topic-230870556_53697222

https://vk.com/topic-230870556_53701920

https://vk.com/topic-230870556_53701991

https://vk.com/topic-230870556_53702003

https://vk.com/topic-230870556_53702131

https://vk.com/topic-230870556_53702144

https://vk.com/topic-230870556_53702169

https://vk.com/topic-230870556_53702189

https://vk.com/topic-230870556_53702203

https://vk.com/topic-230870556_53702214

https://vk.com/topic-230870556_53702228

https://vk.com/topic-230870556_53702243

https://vk.com/topic-230870556_53702289

https://vk.com/topic-230870556_53702301

https://vk.com/topic-230870556_53702314

https://vk.com/topic-230870556_53702323

https://vk.com/topic-230870556_53702333

https://vk.com/topic-230870556_53702345

https://vk.com/topic-230870556_53702356

https://vk.com/topic-230870556_53702368

https://vk.com/topic-230870556_53702377

https://vk.com/topic-230870556_53702390

https://vk.com/topic-230870556_53702399

https://vk.com/topic-230870556_53702410

https://vk.com/topic-230870556_53702414

https://vk.com/topic-230870556_53702417

https://vk.com/topic-230870556_53702459

https://vk.com/topic-230870556_53702469

https://vk.com/topic-230870556_53702478

https://vk.com/topic-230870556_53702487

https://vk.com/topic-230870556_53702496

https://vk.com/topic-230870556_53702504

https://vk.com/topic-230870556_53702518

https://vk.com/topic-230870556_53702529

https://vk.com/topic-230870556_53702540

https://vk.com/topic-230870556_53702546

https://vk.com/topic-230870556_53702556

https://vk.com/topic-230870556_53702563

https://vk.com/topic-230870556_53702566

https://vk.com/topic-230870556_53702575

https://vk.com/topic-230870556_53702580

https://vk.com/topic-230870556_53702588

https://vk.com/topic-230870556_53702596

https://vk.com/topic-230870556_53702600

https://vk.com/topic-230870556_53702605

https://vk.com/topic-230870556_53702611

https://vk.com/topic-230870556_53702615

https://vk.com/topic-230870556_53702616

https://vk.com/topic-230870556_53702652

https://vk.com/topic-230870556_53702655

https://vk.com/topic-230870556_53702659

https://vk.com/topic-230870556_53702662

https://vk.com/topic-230870556_53702668

https://vk.com/topic-230870556_53702672

https://vk.com/topic-230870556_53702675

https://vk.com/topic-230870556_53702681

https://vk.com/topic-230870556_53702684

https://vk.com/topic-230870556_53702687

https://vk.com/topic-230870556_53702693

https://vk.com/topic-230870556_53702696

https://vk.com/topic-230870556_53702703

https://vk.com/topic-230870556_53702709

https://vk.com/topic-230870556_53702714

https://vk.com/topic-230870556_53702720

https://vk.com/topic-230870556_53702721

https://vk.com/topic-230870556_53702727

https://vk.com/topic-230870556_53702732

https://vk.com/topic-230870556_53702747

https://vk.com/topic-230870556_53702754

https://vk.com/topic-230870556_53702759

https://vk.com/topic-230870556_53702771

https://vk.com/topic-230870556_53702782

https://vk.com/topic-230870556_53702793

https://vk.com/topic-230870556_53702803

https://vk.com/topic-230870556_53702814

https://vk.com/topic-230870556_53702823

https://vk.com/topic-230870556_53702835

https://vk.com/topic-230870556_53702849

https://vk.com/topic-230870556_53702863

https://vk.com/topic-230870556_53702906

https://vk.com/topic-230870556_53702924

https://vk.com/topic-230870556_53702943

https://vk.com/topic-230870556_53702957

https://vk.com/topic-230870556_53702971

https://vk.com/topic-230870556_53702981

https://vk.com/topic-230870556_53702993

https://vk.com/topic-230870556_53703003

https://vk.com/topic-230870556_53703016

https://vk.com/topic-230870556_53703036

https://vk.com/topic-230870556_53703079

https://vk.com/topic-230870556_53703090

https://vk.com/topic-230870556_53703094

https://vk.com/topic-230870556_53703114

https://vk.com/topic-230870556_53703129

https://vk.com/topic-230870556_53703142

https://vk.com/topic-230870556_53703152

https://vk.com/topic-230870556_53703541

https://vk.com/topic-230870556_53703557

https://vk.com/topic-230870556_53703630

https://vk.com/topic-230870556_53742801

https://vk.com/topic-230870556_53742818

https://vk.com/topic-230870556_53742838

https://vk.com/topic-230870556_53742844

https://vk.com/topic-230870556_53742886

https://vk.com/topic-230870556_53742905

https://vk.com/topic-230870556_53742929

https://vk.com/topic-230870556_53742951

https://vk.com/topic-230870556_53742969

https://vk.com/topic-230870556_53742977

https://vk.com/topic-230870556_53742988

https://vk.com/topic-230870556_53743011

https://vk.com/topic-230870556_53743060

https://vk.com/topic-230870556_53743087

https://vk.com/topic-230870556_53743106

https://vk.com/topic-230870556_53743124

https://vk.com/topic-230870556_53743174

https://vk.com/topic-230870556_53743194

https://vk.com/topic-230870556_53743222

https://vk.com/topic-230870556_53743248

https://vk.com/topic-230870556_53743314

https://vk.com/topic-230870556_53743342

https://vk.com/topic-230870556_53743363

https://vk.com/topic-230870556_53743382

https://vk.com/topic-230870556_53743403

https://vk.com/topic-230870556_53743423

https://vk.com/topic-230870556_53743440

https://vk.com/topic-230870556_53743469

https://vk.com/topic-230870556_53743491

https://vk.com/topic-230870556_53743516

https://vk.com/topic-230870556_53743532

https://vk.com/topic-230870556_53743549

https://vk.com/topic-230870556_53743572

https://vk.com/topic-230870556_53743593

https://vk.com/topic-230870556_53743614

https://vk.com/topic-230870556_53743636

https://vk.com/topic-230870556_53743650

https://vk.com/topic-230870556_53743678

https://vk.com/topic-230870556_53743700

https://vk.com/topic-230870556_53743724

https://vk.com/topic-230870556_53743739

https://vk.com/topic-230870556_53743749

https://vk.com/topic-230870556_53743758

https://vk.com/topic-230870556_53743771

https://vk.com/topic-230870556_53743786

https://vk.com/topic-230870556_53743812

https://vk.com/topic-230870556_53743816

https://vk.com/topic-230870556_53743830

https://vk.com/topic-230870556_53743849

https://vk.com/topic-230870556_53744338

https://vk.com/topic-230870556_53744356

https://vk.com/topic-230870556_53744375

https://vk.com/topic-230870556_53744388

https://vk.com/topic-230870556_53744398

https://vk.com/topic-230870556_53744414

https://vk.com/topic-230870556_53744436

https://vk.com/topic-230870556_53744454

https://vk.com/topic-230870556_53744469

https://vk.com/topic-230870556_53744491

https://vk.com/topic-230870556_53744508

https://vk.com/topic-230870556_53744533

https://vk.com/topic-230870556_53744567

https://vk.com/topic-230870556_53744591

https://vk.com/topic-230870556_53744611

https://vk.com/topic-230870556_53744623

https://vk.com/topic-230870556_53744643

https://vk.com/topic-230870556_53744668

https://vk.com/topic-230870556_53744679

https://vk.com/topic-230870556_53744692

https://vk.com/topic-230870556_53744710

https://vk.com/topic-230870556_53744724

https://vk.com/topic-230870556_53744745

https://vk.com/topic-230870556_53744767

https://vk.com/topic-230870556_53744784

https://vk.com/topic-230870556_53744821

https://vk.com/topic-230870556_53744845

https://vk.com/topic-230870556_53778286

https://vk.com/topic-230870556_53778295

https://vk.com/topic-230870556_53778305

https://vk.com/topic-230870556_53778316

https://vk.com/topic-230870556_53778327

https://vk.com/topic-230870556_53778339

https://vk.com/topic-230870556_53778349

https://vk.com/topic-230870556_53778359

https://vk.com/topic-230870556_53778368

https://vk.com/topic-230870556_53778381

https://vk.com/topic-230870556_53778392

https://vk.com/topic-230870556_53778410

https://vk.com/topic-230870556_53778422

https://vk.com/topic-230870556_53778435

https://vk.com/topic-230870556_53778500

https://vk.com/topic-230870556_53778518

https://vk.com/topic-230870556_53778536

https://vk.com/topic-230870556_53778551

https://vk.com/topic-230870556_53778562

https://vk.com/topic-230870556_53778580

https://vk.com/topic-230870556_53778598

https://vk.com/topic-230870556_53778621

https://vk.com/topic-230870556_53778639

https://vk.com/topic-230870556_53778653

https://vk.com/topic-230870556_53778664

https://vk.com/topic-230870556_53778675

https://vk.com/topic-230870556_53778689

https://vk.com/topic-230870556_53778702

https://vk.com/topic-230870556_53778715

https://vk.com/topic-230870556_53778725

https://vk.com/topic-230870556_53778736

https://vk.com/topic-230870556_53778744

https://vk.com/topic-230870556_53778762

https://vk.com/topic-230870556_53778772

https://vk.com/topic-230870556_53778792

https://vk.com/topic-230870556_53778799

https://vk.com/topic-230870556_53778809

https://vk.com/topic-230870556_53778816

https://vk.com/topic-230870556_53778822

https://vk.com/topic-230870556_53778830

https://vk.com/topic-230870556_53778841

https://vk.com/topic-230870556_53778859

https://vk.com/topic-230870556_53778872

https://vk.com/topic-230870556_53778885

https://vk.com/topic-230870556_53778900

https://vk.com/topic-230870556_53778912

https://vk.com/topic-230870556_53778920

最后编辑于
©著作权归作者所有,转载或内容合作请联系作者
平台声明:文章内容(如有图片或视频亦包括在内)由作者上传并发布,文章内容仅代表作者本人观点,简书系信息发布平台,仅提供信息存储服务。

推荐阅读更多精彩内容