如何读取Perl中的Excel文件？

问题描述

我正在寻找一些关于如何编写Perl脚本从excel文件读取数据，然后使用数据读取（作为一个字符串希望）并将其传递给另一个Perl文件（作为参数）的示例/建议。

目标是有一个表，用户可以在表中输入一些数据（ftp目标或文件名）到表中。那么我的程序会用这个自动化来获取数据。它不需要非常优雅的实现...只需要它来读取行数据或多或少。

解决方案

模块可以读取Excel文件。该文档包括如何使用它的示例。

I am looking for some examples/advice on how to write a Perl script to read data from an excel file then use the data read in (as a string hopefully) and pass it to another Perl file (as an argument).

The goal is to have a table in which the user can type some data (ftp destination or filename) into the table. Then my program will grab that data at do some automation with it. It does not have to be very elegant in implementation ... Just need it to read rows of data more or less.

解决方案

The Spreadsheet::ParseExcel module can read Excel files. The documentation includes examples how to use it.

这篇关于如何读取Perl中的Excel文件？的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持！