将文本文件写入excel
将文本文件拖入Excel (Drag a Text File Into Excel)
Last month, I showed you how to drag information from a web browser into Excel. You can also drag text files, to open them quickly in Excel.
上个月,我向您展示了如何将信息从Web浏览器拖到Excel中 。 您还可以拖动文本文件,以在Excel中快速打开它们。
I find this a really quick way to open a text file, especially if Windows Explorer is already open.
我发现这是一种打开文本文件的快速方法,尤其是在Windows资源管理器已经打开的情况下。
Instead of using the Open command, or the Text Import Wizard, just drag the text file into the Excel window.
无需使用“打开”命令或“文本导入向导”,只需将文本文件拖到Excel窗口中即可。
![TextFileDragExcel01 TextFileDragExcel01](https://i-blog.csdnimg.cn/blog_migrate/12f55fe62aa294ac8d93a41aabd64d20.png)
The text file opens automatically, in separate columns in this example, because the data was tab separated.
在此示例中,文本文件会自动打开,并在单独的列中显示,因为数据是用制表符分隔的。
翻译自: https://contexturesblog.com/archives/2010/05/17/drag-a-text-file-into-excel/
将文本文件写入excel