如何将CSV文件转换为EXCEL文件 [英] how to convert CSV file to EXCEL file

问题描述

大家好，


我已经阅读了很多将Excel数据转换成CSV文件的线程。

但是，我现在需要一个perl脚本将CSV文件转换为excel文件，如果需要模块，最好使用win32 :: OLE。


目前我所知道的是当我将扩展名更改为.csv文件时，它通过Microsoft Excel CSV文件更改为excel文件


所以如果我是使用perl脚本并转换

perl脚本必须打开这个csv文件并将其转移到excel？

hm ..我不太确定但是那样吗？

希望有一些地方我可以在这些

hi guys,

i''ve read a lot of thread of converting excel data into CSV files.
however, i need a perl script to convert CSV file into excel file now, if required modules is needed, it would be preferable if win32::OLE is used..

currently what i know is when i change my extension as .csv file mannually, it get changed to an excel file through Microsoft Excel CSV file

so if i were to use a perl script and convert
the perl script has to open this csv file and transfer it into excel?
hm..i''m not too sure but is it like that?
hope there could be certain place where i can look up info on these

推荐答案

我建​​议您搜索 CPAN 。您将能够找到一个模块来以适当的格式创建文件，而不是手动操作。


--Kevin

I would suggest that you search CPAN. You will be able to find a module to create your files in the proper format rather than doing it manually.

--Kevin

hm。 .ook我找到了一个模块来帮助我

但是我完全与安装部分混淆了


我正在Windows和activeperl上运行

阅读网站说要安装我必须


1. perl MAKEFILE.pl

2.make

3.make测试


i真的不知道这意味着什么，我尝试过像

hm..ook i found somewhat a module to help me
but i''m totally confused with the installation part

i''m running on windows and activeperl
read website saying to install i have to

1. perl MAKEFILE.pl
2.make
3.make test

i really dunno what this means and i;ve tried like

perl -MCPAN -e shell


没什么可行的......我真的很困惑模块东西

有人可以帮忙吗？

perl -MCPAN -e shell

and nothing works..i''m really very confused about the modules thingy
can anyone help?

这篇关于如何将CSV文件转换为EXCEL文件的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！