Find Jobs
Hire Freelancers

Perl module to modify Excel workbook

$30-250 USD

进行中
已发布超过 10 年前

$30-250 USD

货到付款
I need a new Perl module that will enable me to create Excel reports from a MySQL database. The module needs to take an Excel workbook as a template, and then modify it using data returned to it from the database. The module should be sort of a cross between Spreadsheet::ParseExcel::SaveParser and Excel::Template, in that it will use a current workbook as the template (like Spreadsheet::ParseExcel::SaveParser), but it will allow me to do variable and loop substitution like Excel::Template instead of having to specify absolute row and column numbers. It needs to maintain the formatting of the template workbook. What I'm envisioning is that we will develop a naming convention to show which cells in the workbook are actually placeholders that will be filled in from the database. Something like any cell that is named _VARIABLE_ would be replaced with the value from $hash_ref->{'VARIABLE'}. It needs to support loops with syntax similar to Excel::Template, so that I can pass an array ref (which references an array of hash refs) and have the row repeated for each hash ref. Please let me know any questions you have any we can work out the details. The module does not need to interact with the database directly; all of the data will be collected outside of the module and passed in to the module as array and hash refs. --TWH
项目 ID: 4974676

关于此项目

5提案
远程项目
活跃11 年前

想赚点钱吗?

在Freelancer上竞价的好处

设定您的预算和时间范围
为您的工作获得报酬
简要概述您的提案
免费注册和竞标工作
5威客以平均价$201 USD来参与此工作竞价
用户头像
i can develop this script to create excel reports.
$250 USD 在2天之内
4.7 (50条评论)
5.8
5.8
用户头像
Hello Sir, i am a professional perl developer. i have good hands on in database side. thanks! kishor
$155 USD 在3天之内
5.0 (32条评论)
5.2
5.2
用户头像
Have done something very similar for a system to read and write excel files for a channel sales report for a travel company. Can put something together in a day or two.
$222 USD 在3天之内
5.0 (3条评论)
4.9
4.9
用户头像
I am very good in scripting language like perl and python. I am also a database expert and experienced in wiring queries. I can do this task for you
$190 USD 在3天之内
4.8 (16条评论)
5.0
5.0
用户头像
I've more than 10 years experience in Perl/PHP/MySQL programming.
$190 USD 在3天之内
4.9 (11条评论)
4.6
4.6

关于客户

UNITED STATES的国旗
Fullerton, United States
4.9
17
付款方式已验证
会员自4月 2, 2007起

客户认证

谢谢!我们已通过电子邮件向您发送了索取免费积分的链接。
发送电子邮件时出现问题。请再试一次。
已注册用户 发布工作总数
Freelancer ® is a registered Trademark of Freelancer Technology Pty Limited (ACN 142 189 759)
Copyright © 2024 Freelancer Technology Pty Limited (ACN 142 189 759)
加载预览
授予地理位置权限。
您的登录会话已过期而且您已经登出,请再次登录。