将.txt转换为excel的问题 [英] problem converting .txt to excel

问题描述

伙计们，


下面是一个我需要帮助的脚本

i得到这个打印出来的csv excel

我正在尝试修改它以读取.txt文件来转换excel

hm ...似乎仍然不知道为什么它不能运行？


是不是我不应该在win32 :: OLE模块中打开我的文件？

hi guys,

below is a script that i need yr help on
i got this to print out a csv to excel
i''m trying to modify it to read a .txt file to convert an excel
hm...doesn''t seem to work still any idea why it can''t run?

is it cos i should not be open my file in the win32::OLE module?

展开 | 选择 | Wrap | 行号

推荐答案

您期待什么格式？我从你的脚本获取输出，每个文本文件中的数据都写在excel文件的每一页中。

What format are you expecting? I am getting the output from your script, with data from each text file written in each sheet of the excel file.

什么格式是你期待吗？我从您的脚本获取输出，每个文件文件中的数据都写在excel文件的每个表格中。

What format are you expecting? I am getting the output from your script, with data from each text file written in each sheet of the excel file.

hm..yeah

这就是我想要的......但似乎有些错误

它没有使用脚本

我没有得到任何输出

hm..yeah
that''s what i want...but there seems to be some error
it''s not working the script
i''m not gettng any output

确定我已经让它工作了谢谢


erm ..但是有问题


我的excel表有太长的数字

例如：


526236273282392323

他们以excel输出：


5.26 + E14


任何想法如何将其显示为原始格式？

而不是E14格式？

ok i''ve got it working thanks

erm..but there a problem

my excel sheet has numbers that are too long
like for example:

526236273282392323

they output in excel :

5.26+E14

any idea how to display it as the original format?
and not as the E14 format?

这篇关于将.txt转换为excel的问题的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！