具有UTF-8的字节顺序标记的Excel文件导致错误 [英] Excel files with byte order mark for UTF-8 causing errors

问题描述

我只是想知道是否有任何可能的方法来解决这个问题。我在工作中接收包含光纤接头的拼接信息的Excel文件，当我尝试导入时，我得到一个输出错误，表明第一个表与期望看不到匹配。当我然后打开它，我可以看到UTF-8的BOM为直接在这个词之前 / code>。

I am just wondering if there is any possible way to fix this. I receive Excel files at work that contain the splicing information for fibre joints, and when I try to import then I get an output error saying the first table didn't match up with what it expected to see. When I then open it, I can see the BOM for UTF-8 as  directly before the word like this Joint Name.

显然，这是隐藏在原始文件，它导致一些手动工作，必须从每个Excel文件中删除每个符号。目前我收到的文件是.csv格式，错误文件以.csv格式显示。

Obviously this is hidden in the original file, and it causes a bit of manual work having to remove each of the symbols from each Excel file. Currently the files I am receiving are in a .csv format and the error files come back as a .csv with the symbols showing.

保存这些删除BOM或某物，以避免手动工作在这种情况下？

Is there any way I can pre-save these to remove the BOM or something to avoid the manual work in this situation?

理想情况下，我想删除隐藏的BOM，以便导入只是第一次工作而不重做。

Ideally I'd like to remove the hidden BOM so that the import just works the first time without rework.

推荐答案

我已经找出答案，将它留给任何遇到类似问题的人。

I have figured out the answer, will leave it here for anyone who is encountering a similar issue.

打开csv文件，在编码菜单中，您可以从UTF-8 BOM更改为UTF-8。保存文件，就这样了。

Open the csv file in Notepad++, in the encoding menu you can change from UTF-8 BOM to UTF-8. Save the file and it is gone, simple as that.

祝你好运！

这篇关于具有UTF-8的字节顺序标记的Excel文件导致错误的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！