{"text_format":"1","workbook":"xlsx","n_sheets":3,"sheets":["50","20","vlookup"],"not_rendered":{"charts":0,"images":0,"macros":0,"external_links":0,"defined_names":0,"comments":0,"pivot_tables":0},"unopened":[],"bounds":{"document_bytes":16777216,"sheet_cells":100000,"rows_first":2000,"rows_last":500,"rows_between":2000,"halvings":0,"cell_chars":16384,"cell_head_chars":4096},"cells_cut":0,"cells_raw":0,"read":"whole","date_system":"1900"}

{"sheet":"50","index":0,"n_rows":51,"n_cols":17,"rows_kept":51,"cut":false,"hidden":false,"merged":[]}
["id","hotelid","酒店名","星级","城市","地址","开业年份","客房数",null,null,null,"id","hotelid","酒店名称","评论条数","评论总分","网址"]
[1,713260,"北京中航工业第一招待所",2.5,"北京","东四北大街汪芝麻胡同16号",1961,100,null,null,59,1,745176,"布丁酒店（北京工业大学欢乐谷店）（原北京十里河店）",164,3.5999999046325701,"http://hotels.ctrip.com/hotel/745176.html"]
[2,735585,"北京京盔宾馆",2.5,"北京","盔甲厂胡同4号",2011,44,null,null,50,2,126258,"远景国际公寓（北京远中悦麒店）",189,3.7,"http://hotels.ctrip.com/hotel/126258.html"]
[3,86668,"北京申晨酒店",2.5,"北京","丰管路8号",2007,126,null,null,70,3,344564,"上海泉泉宾馆",7,3.7999999523162802,"http://hotels.ctrip.com/hotel/344564.html"]
[4,796490,"大连海发招待所",5.5,"大连","大连市金州区火车站前盛滨25号楼",2006,100,null,null,40,4,346345,"北京黎明园宾馆",27,3.5999999046325701,"http://hotels.ctrip.com/hotel/346345.html"]
[5,374798,"北京社科博源宾馆",3.5,"北京","东府区王府井大街27号",2005,80,764,null,65,5,61071,"汉庭酒店（北京崇文门店）",127,3.5999999046325701,"http://hotels.ctrip.com/hotel/61071.html"]
[6,801373,"银座佳驿酒店（上海吴淞店）",3.5,"上海","松浦路100号",2013,136,null,null,null,6,485275,"锦江之星（上海逸仙路店）",346,4.3000001907348597,"http://hotels.ctrip.com/hotel/485275.html"]
[7,767525,"上海佳佳阳光酒店式短租公寓田子坊店",3.5,"上海","上海徐汇区肇家浜路7弄(近瑞金南路)",2009,98,null,null,77,7,468005,"北方朗悦酒店（北京青年湖店）",351,4.4000000953674299,"http://hotels.ctrip.com/hotel/468005.html"]
[8,83227,"北京连杰酒店",2.5,"北京","东苇路9号鑫兆佳园15号楼（管庄路北京科技大学对面）",2010,124,527,null,110,8,63207,"汉庭酒店（上海徐家汇二店）",346,4.0999999999999996,"http://hotels.ctrip.com/hotel/63207.html"]
[9,766925,"上海和州旅馆",3.5,"上海","上海浦东新区上南路林恒路2209号",2006,100,null,null,100,9,767285,"上海六通招待所",28,3.9,"http://hotels.ctrip.com/hotel/767285.html"]
[10,65499,"莫泰168（上海南站上师大店）",1.5,"上海","桂林路17号",2009,107,null,null,100,10,767079,"上海如约时尚酒店",18,4.4000000000000004,"http://hotels.ctrip.com/hotel/767079.html"]
[11,110473,"汉庭酒店（北京望京花家地店）",2,"北京","花家地1号楼",2006,125,208,null,null,11,369675,"北京国贸大酒店",906,4.8000001907348597,"http://hotels.ctrip.com/hotel/369675.html"]
[12,206,"北京国二招宾馆",4,"北京","西直门南大街6号",1969,251,null,null,178,12,534825,"上海华纳风格大酒店",633,4.3000001907348597,"http://hotels.ctrip.com/hotel/534825.html"]
[13,751124,"大连宝龙旅馆",1.5,"大连","西山街210号",2013,25,null,null,50,13,764582,"上海芦林旅馆",345,4.0999999999999996,"http://hotels.ctrip.com/hotel/764582.html"]
[14,346345,"北京黎明园宾馆",1.5,"北京","西坝河中里21号楼（国展西门4号门对面）",2003,40,27,null,null,14,737743,"北京佰特阳光快捷宾馆",435,2.9,"http://hotels.ctrip.com/hotel/737743.html"]
[15,18621,"北京南航明珠商务酒店（原北京南航大酒店）",3,"北京","东三环中路10号",2001,76,1030,null,124,15,83227,"北京连杰酒店",527,4.0999999999999996,"http://hotels.ctrip.com/hotel/83227.html"]
[16,766168,"上海小川旅馆",4,"上海","上海闵行区虹梅路2802号",2006,98,null,null,100,16,766838,"上海开心短租阳光公寓二店",123,3.7,"http://hotels.ctrip.com/hotel/766838.html"]
[17,534825,"上海华纳风格大酒店",4,"上海","莲花路1733号",2007,178,633,null,80,17,374798,"北京社科博源宾馆",764,4.0999999046325701,"http://hotels.ctrip.com/hotel/374798.html"]
[18,396423,"北京昆仑饭店",5.5,"北京","新源南路2号",1988,646,null,null,76,18,18621,"北京南航明珠商务酒店（原北京南航大酒店）",1030,3.7999999523162802,"http://hotels.ctrip.com/hotel/18621.html"]
[19,63207,"汉庭酒店（上海徐家汇二店）",1.5,"上海","钦州北路98号",2008,110,346,null,125,19,110473,"汉庭酒店（北京望京花家地店）",208,4.1999998092651403,"http://hotels.ctrip.com/hotel/110473.html"]
[20,766838,"上海开心短租阳光公寓二店",3.5,"上海","上海市浦东新区佳林路138号6号房",2006,100,123,null,null,20,769720,"上海江亚旅馆",234,3.6,"http://hotels.ctrip.com/hotel/769720.html"]
[21,769959,"上海金腾旅馆",3.5,"上海","上海金杨路776号",2006,80]
[22,761501,"北京龙庆峡连珠农家院",1.5,"北京","古城村北外大街石营街1号",2013,19]
[23,468005,"北方朗悦酒店（北京青年湖店）",2,"北京","北京市东城区青年湖南街19号",2012,77,351]
[24,344564,"上海泉泉宾馆",1.5,"上海","一二八纪念路215号",2010,70,7]
[25,775505,"北京百旺庄园招待所",1.5,"北京","北七家镇王府街4号",2012,60]
[26,134714,"大连壹方休闲公寓",2,"大连","周水前东特购物广场楼上大连商业学校对面（爱丽舍大厦）肯德基苏宁电器楼上",2011,20]
[27,81137,"上海惠宾源酒店",1.5,"上海","打浦路92-3号",2006,54]
[28,767079,"上海如约时尚酒店",3.5,"上海","上海浦东顾唐路198号",2006,100,18]
[29,480044,"上海晋颐假日宾馆",1.5,"上海","人民北路186号",2013,41]
[30,767223,"京昌酒店长阳店",3.5,"上海","杨浦区长阳路1510号",2006,50]
[31,767530,"上海日之星宾馆(上海张桥店)",3.5,"上海","上海市浦东新区佳林路175号(近金高路)",2001,100]
[32,51711,"北京赢家商务酒店",3,"北京","北京市海淀区学院路38号",2007,195]
[33,534960,"大连铁道1896花园酒店",4.5,"大连","胜利桥胜利街39号/（光辉巷36号，毗邻俄罗斯一条街、西侧50米胜利街道旁）",2013,116]
[34,142321,"大连如家休闲宾馆",5.5,"大连","长兴岛三堂联兴路（富康商厦旁）",2011,40]
[35,126258,"远景国际公寓（北京远中悦麒店）",1.5,"北京","赵公口甲13号",2009,50,189]
[36,433528,"上海安居乐客酒店",1.5,"上海","控江路1155号",2012,34]
[37,74048,"汉庭酒店（上海南京东路店）",1.5,"上海","山东中路230号",2009,108]
[38,764582,"上海芦林旅馆",4,"上海","上海市闵行区华漕镇纪鹤路255号",2006,50,345]
[39,345017,"上海扬子江万丽大酒店",5,"上海","延安西路2099号",1990,542]
[40,796337,"大连龙海酒店公寓星海大观店",5.5,"大连","大连市沙河口区星河路65A星海大观E坐1401室",2006,200]
[41,533886,"桔子水晶酒店（上海康桥店）",4,"上海","康桥路1789号",2013,132]
[42,397161,"上海明城大酒店",4,"上海","崂山路600号",1997,399]
[43,479758,"上海凯轩宾馆",1.5,"上海","乍浦路321号",2010,50]
[44,689194,"北京鑫燕宾馆",1.5,"北京","北三环中路40号",2012,28]
[45,61071,"汉庭酒店（北京崇文门店）",1.5,"北京","船板胡同47号",2008,65,127]
[46,764585,"上海松春旅店",1.5,"上海","谷阳北路36号",2010,12]
[47,533504,"北京考拉酒店",1.5,"北京","文慧园斜街9号",2013,48]
[48,480679,"上海景缘国际酒店",3.5,"上海","浦东大道2333号",2006,205]
[49,767285,"上海六通招待所",3.5,"上海","上海市宝山区月浦镇",2006,100,28]
[50,745176,"布丁酒店（北京工业大学欢乐谷店）（原北京十里河店）",1.5,"北京","南新园中路106号",2011,59,164]

{"sheet":"20","index":1,"n_rows":21,"n_cols":6,"rows_kept":21,"cut":false,"hidden":false,"merged":[]}
["id","hotelid","酒店名称","评论条数","评论总分","网址"]
[1,745176,"布丁酒店（北京工业大学欢乐谷店）（原北京十里河店）",164,3.5999999046325701,"http://hotels.ctrip.com/hotel/745176.html"]
[2,126258,"远景国际公寓（北京远中悦麒店）",189,3.7,"http://hotels.ctrip.com/hotel/126258.html"]
[3,344564,"上海泉泉宾馆",7,3.7999999523162802,"http://hotels.ctrip.com/hotel/344564.html"]
[4,346345,"北京黎明园宾馆",27,3.5999999046325701,"http://hotels.ctrip.com/hotel/346345.html"]
[5,61071,"汉庭酒店（北京崇文门店）",127,3.5999999046325701,"http://hotels.ctrip.com/hotel/61071.html"]
[6,485275,"锦江之星（上海逸仙路店）",346,4.3000001907348597,"http://hotels.ctrip.com/hotel/485275.html"]
[7,468005,"北方朗悦酒店（北京青年湖店）",351,4.4000000953674299,"http://hotels.ctrip.com/hotel/468005.html"]
[8,63207,"汉庭酒店（上海徐家汇二店）",346,4.0999999999999996,"http://hotels.ctrip.com/hotel/63207.html"]
[9,767285,"上海六通招待所",28,3.9,"http://hotels.ctrip.com/hotel/767285.html"]
[10,767079,"上海如约时尚酒店",18,4.4000000000000004,"http://hotels.ctrip.com/hotel/767079.html"]
[11,369675,"北京国贸大酒店",906,4.8000001907348597,"http://hotels.ctrip.com/hotel/369675.html"]
[12,534825,"上海华纳风格大酒店",633,4.3000001907348597,"http://hotels.ctrip.com/hotel/534825.html"]
[13,764582,"上海芦林旅馆",345,4.0999999999999996,"http://hotels.ctrip.com/hotel/764582.html"]
[14,737743,"北京佰特阳光快捷宾馆",435,2.9,"http://hotels.ctrip.com/hotel/737743.html"]
[15,83227,"北京连杰酒店",527,4.0999999999999996,"http://hotels.ctrip.com/hotel/83227.html"]
[16,766838,"上海开心短租阳光公寓二店",123,3.7,"http://hotels.ctrip.com/hotel/766838.html"]
[17,374798,"北京社科博源宾馆",764,4.0999999046325701,"http://hotels.ctrip.com/hotel/374798.html"]
[18,18621,"北京南航明珠商务酒店（原北京南航大酒店）",1030,3.7999999523162802,"http://hotels.ctrip.com/hotel/18621.html"]
[19,110473,"汉庭酒店（北京望京花家地店）",208,4.1999998092651403,"http://hotels.ctrip.com/hotel/110473.html"]
[20,769720,"上海江亚旅馆",234,3.6,"http://hotels.ctrip.com/hotel/769720.html"]

{"sheet":"vlookup","index":2,"n_rows":51,"n_cols":17,"rows_kept":51,"cut":false,"hidden":false,"merged":[]}
["id","hotelid","酒店名","星级","城市","地址","开业年份","客房数",null,null,null,"id","hotelid","酒店名称","评论条数","评论总分","网址"]
[1,713260,"北京中航工业第一招待所",2.5,"北京","东四北大街汪芝麻胡同16号",1961,100,null,null,{"$f":"VLOOKUP(M2,$B$1:$H$51,7,FALSE)","v":59},1,745176,"布丁酒店（北京工业大学欢乐谷店）（原北京十里河店）",164,3.5999999046325701,"http://hotels.ctrip.com/hotel/745176.html"]
[2,735585,"北京京盔宾馆",2.5,"北京","盔甲厂胡同4号",2011,44,null,null,{"$f":"VLOOKUP(M3,$B$1:$H$51,7,FALSE)","v":50},2,126258,"远景国际公寓（北京远中悦麒店）",189,3.7,"http://hotels.ctrip.com/hotel/126258.html"]
[3,86668,"北京申晨酒店",2.5,"北京","丰管路8号",2007,126,null,null,70,3,344564,"上海泉泉宾馆",7,3.7999999523162802,"http://hotels.ctrip.com/hotel/344564.html"]
[4,796490,"大连海发招待所",5.5,"大连","大连市金州区火车站前盛滨25号楼",2006,100,null,null,40,4,346345,"北京黎明园宾馆",27,3.5999999046325701,"http://hotels.ctrip.com/hotel/346345.html"]
[5,374798,"北京社科博源宾馆",3.5,"北京","东府区王府井大街27号",2005,80,null,null,65,5,61071,"汉庭酒店（北京崇文门店）",127,3.5999999046325701,"http://hotels.ctrip.com/hotel/61071.html"]
[6,801373,"银座佳驿酒店（上海吴淞店）",3.5,"上海","松浦路100号",2013,136,null,null,{"$error":"#N/A"},6,485275,"锦江之星（上海逸仙路店）",346,4.3000001907348597,"http://hotels.ctrip.com/hotel/485275.html"]
[7,767525,"上海佳佳阳光酒店式短租公寓田子坊店",3.5,"上海","上海徐汇区肇家浜路7弄(近瑞金南路)",2009,98,null,null,77,7,468005,"北方朗悦酒店（北京青年湖店）",351,4.4000000953674299,"http://hotels.ctrip.com/hotel/468005.html"]
[8,83227,"北京连杰酒店",2.5,"北京","东苇路9号鑫兆佳园15号楼（管庄路北京科技大学对面）",2010,124,null,null,110,8,63207,"汉庭酒店（上海徐家汇二店）",346,4.0999999999999996,"http://hotels.ctrip.com/hotel/63207.html"]
[9,766925,"上海和州旅馆",3.5,"上海","上海浦东新区上南路林恒路2209号",2006,100,null,null,100,9,767285,"上海六通招待所",28,3.9,"http://hotels.ctrip.com/hotel/767285.html"]
[10,65499,"莫泰168（上海南站上师大店）",1.5,"上海","桂林路17号",2009,107,null,null,100,10,767079,"上海如约时尚酒店",18,4.4000000000000004,"http://hotels.ctrip.com/hotel/767079.html"]
[11,110473,"汉庭酒店（北京望京花家地店）",2,"北京","花家地1号楼",2006,125,null,null,{"$error":"#N/A"},11,369675,"北京国贸大酒店",906,4.8000001907348597,"http://hotels.ctrip.com/hotel/369675.html"]
[12,206,"北京国二招宾馆",4,"北京","西直门南大街6号",1969,251,null,null,178,12,534825,"上海华纳风格大酒店",633,4.3000001907348597,"http://hotels.ctrip.com/hotel/534825.html"]
[13,751124,"大连宝龙旅馆",1.5,"大连","西山街210号",2013,25,null,null,50,13,764582,"上海芦林旅馆",345,4.0999999999999996,"http://hotels.ctrip.com/hotel/764582.html"]
[14,346345,"北京黎明园宾馆",1.5,"北京","西坝河中里21号楼（国展西门4号门对面）",2003,40,null,null,{"$error":"#N/A"},14,737743,"北京佰特阳光快捷宾馆",435,2.9,"http://hotels.ctrip.com/hotel/737743.html"]
[15,18621,"北京南航明珠商务酒店（原北京南航大酒店）",3,"北京","东三环中路10号",2001,76,null,null,124,15,83227,"北京连杰酒店",527,4.0999999999999996,"http://hotels.ctrip.com/hotel/83227.html"]
[16,766168,"上海小川旅馆",4,"上海","上海闵行区虹梅路2802号",2006,98,null,null,100,16,766838,"上海开心短租阳光公寓二店",123,3.7,"http://hotels.ctrip.com/hotel/766838.html"]
[17,534825,"上海华纳风格大酒店",4,"上海","莲花路1733号",2007,178,null,null,80,17,374798,"北京社科博源宾馆",764,4.0999999046325701,"http://hotels.ctrip.com/hotel/374798.html"]
[18,396423,"北京昆仑饭店",5.5,"北京","新源南路2号",1988,646,null,null,76,18,18621,"北京南航明珠商务酒店（原北京南航大酒店）",1030,3.7999999523162802,"http://hotels.ctrip.com/hotel/18621.html"]
[19,63207,"汉庭酒店（上海徐家汇二店）",1.5,"上海","钦州北路98号",2008,110,null,null,125,19,110473,"汉庭酒店（北京望京花家地店）",208,4.1999998092651403,"http://hotels.ctrip.com/hotel/110473.html"]
[20,766838,"上海开心短租阳光公寓二店",3.5,"上海","上海市浦东新区佳林路138号6号房",2006,100,null,null,{"$error":"#N/A"},20,769720,"上海江亚旅馆",234,3.6,"http://hotels.ctrip.com/hotel/769720.html"]
[21,769959,"上海金腾旅馆",3.5,"上海","上海金杨路776号",2006,80]
[22,761501,"北京龙庆峡连珠农家院",1.5,"北京","古城村北外大街石营街1号",2013,19]
[23,468005,"北方朗悦酒店（北京青年湖店）",2,"北京","北京市东城区青年湖南街19号",2012,77,null,null,"xlsx"]
[24,344564,"上海泉泉宾馆",1.5,"上海","一二八纪念路215号",2010,70,null,null,"xlsm"]
[25,775505,"北京百旺庄园招待所",1.5,"北京","北七家镇王府街4号",2012,60]
[26,134714,"大连壹方休闲公寓",2,"大连","周水前东特购物广场楼上大连商业学校对面（爱丽舍大厦）肯德基苏宁电器楼上",2011,20]
[27,81137,"上海惠宾源酒店",1.5,"上海","打浦路92-3号",2006,54]
[28,767079,"上海如约时尚酒店",3.5,"上海","上海浦东顾唐路198号",2006,100]
[29,480044,"上海晋颐假日宾馆",1.5,"上海","人民北路186号",2013,41]
[30,767223,"京昌酒店长阳店",3.5,"上海","杨浦区长阳路1510号",2006,50]
[31,767530,"上海日之星宾馆(上海张桥店)",3.5,"上海","上海市浦东新区佳林路175号(近金高路)",2001,100]
[32,51711,"北京赢家商务酒店",3,"北京","北京市海淀区学院路38号",2007,195]
[33,534960,"大连铁道1896花园酒店",4.5,"大连","胜利桥胜利街39号/（光辉巷36号，毗邻俄罗斯一条街、西侧50米胜利街道旁）",2013,116]
[34,142321,"大连如家休闲宾馆",5.5,"大连","长兴岛三堂联兴路（富康商厦旁）",2011,40]
[35,126258,"远景国际公寓（北京远中悦麒店）",1.5,"北京","赵公口甲13号",2009,50]
[36,433528,"上海安居乐客酒店",1.5,"上海","控江路1155号",2012,34]
[37,74048,"汉庭酒店（上海南京东路店）",1.5,"上海","山东中路230号",2009,108]
[38,764582,"上海芦林旅馆",4,"上海","上海市闵行区华漕镇纪鹤路255号",2006,50]
[39,345017,"上海扬子江万丽大酒店",5,"上海","延安西路2099号",1990,542]
[40,796337,"大连龙海酒店公寓星海大观店",5.5,"大连","大连市沙河口区星河路65A星海大观E坐1401室",2006,200]
[41,533886,"桔子水晶酒店（上海康桥店）",4,"上海","康桥路1789号",2013,132]
[42,397161,"上海明城大酒店",4,"上海","崂山路600号",1997,399]
[43,479758,"上海凯轩宾馆",1.5,"上海","乍浦路321号",2010,50]
[44,689194,"北京鑫燕宾馆",1.5,"北京","北三环中路40号",2012,28]
[45,61071,"汉庭酒店（北京崇文门店）",1.5,"北京","船板胡同47号",2008,65]
[46,764585,"上海松春旅店",1.5,"上海","谷阳北路36号",2010,12]
[47,533504,"北京考拉酒店",1.5,"北京","文慧园斜街9号",2013,48]
[48,480679,"上海景缘国际酒店",3.5,"上海","浦东大道2333号",2006,205]
[49,767285,"上海六通招待所",3.5,"上海","上海市宝山区月浦镇",2006,100]
[50,745176,"布丁酒店（北京工业大学欢乐谷店）（原北京十里河店）",1.5,"北京","南新园中路106号",2011,59]