天气预报 > 其他 > excel打开是乱码怎么办
excel打开是乱码怎么办
更新时间: 2020-10-29 00:00:00  

1、Excel打开一个csv格式的文档,出现乱码

2、有乱码的CSV档透过记事本的方式开启

3、用记事本打开后,开到的也是一堆乱码,单击“档案”---“另存为”;

4、在弹出的保存对话框中选择“ANSI格式

5、设置完成,将文件保存再用excel打开。可以看到,文档能够正常的显示了

关键词: excel 打开 乱码 怎么办

excel打开是乱码怎么办相关经验

天气预报

最新推荐

页面:/news/view-2011353/ | 耗时:0.3715 s | 内存:2.11 MB | 查询:4 | 缓存读取:3 写入:0 | 加载文件:25
select * from tbl_Articles WHERE ArticleID=2011353 LIMIT 0,1
select * from tbl_Articles_data WHERE ArticleID=2011353 LIMIT 0,1
select * from tbl_Articles_sphinx where id=2011353 LIMIT 0,1
SELECT ArticleID,Title FROM tbl_Articles WHERE ArticleID IN(1088508,1065945,1071055,1091974,1091950,1010909,1089215,1090150,1048622,1061328,1080699,1051847,1041986,1070474,1073772,1090260,1048220,1066810,1084917,1062062,1080241,1065795,1077619,1069065,1045553,1062424,1058463,1080997,1072745,1072591) ORDER BY field (ArticleID,1088508,1065945,1071055,1091974,1091950,1010909,1089215,1090150,1048622,1061328,1080699,1051847,1041986,1070474,1073772,1090260,1048220,1066810,1084917,1062062,1080241,1065795,1077619,1069065,1045553,1062424,1058463,1080997,1072745,1072591)