Perl script to parse Excel spreadsheets to text file(s)

Tamamlanmış İlan edilme: Apr 1, 2015 Teslim sırasında ödenir
Tamamlanmış Teslim sırasında ödenir

Create a Perl script.

The script should look at all subdirs of current dir and create a list

of excel (xlsx) file. For each file it parse excel first sheet only.

NOTE: All Spreadsheets can be in different encoding, the resulting files should be in utf-8

Script should do something like this (pseudocode):

print filename

print sheet Name

join cells of each row by '#!#' delimiter

check if first line of the current sheet is like

'First Name#!#Last Name#!#Email#!#Company#!#Job Title#!#Address#!#Phone#!#Country#!#ParentCategory#!#Category#!#SubCategory1#!#SubCategory2#!#SubCategory3'

if not, produce warning and continue

parse each line into ($FirstName, $LastName, $Email, $Company, $JobTitle, $Address, $Phone, $Country, $ParentCategory, $Category, $SubCategory1, $SubCategory2, $SubCategory3)

skip if no email

substitute comma to period in email (common typo)

trim email

check email for validity

put each line into hash with lower case email as a keys

print sorted hash for import to DB

Perl

Proje NO: #7411544

Proje hakkında

4 teklif Uzak proje Aktif Apr 2, 2015

Seçilen:

zkutch

Hi. more 20 years programming experience. I have several question to set real price and time, but let me, pls, state first one - which os you have in view? regards.

%selectedBids___i_period_sub_7% gün içinde 50%project_currencyDetails_sign_sub_9% %project_currencyDetails_code_sub_10%
(11 Değerlendirme)
3.5

Bu iş için 4 freelancer ortalamada $47 teklif veriyor

sveralex

Hello, thank you for the invitation. Can you post a couple Excel files to review -- Thank you Alexey

$41 USD in 2 gün içinde
(3 Değerlendirme)
3.0
sachitjani81

A proposal has not yet been provided

1 gün içinde %bids___i_sum_sub_32%%project_currencyDetails_sign_sub_33% USD
(4 Değerlendirme)
2.0
gokulanand

Hello, I understand your requirement. It looks like the project will be easier and makes sense to do in VBA ( macros ) rather doing in Python. Let me know if you are interested, I can get the task done in 2 to 4 hou Daha Fazla

$30 USD in 0 gün içinde
(1 Yorum)
0.8