Perl script to parse Excel spreadsheets to text file(s)
$10-30 USD
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
Proje NO: #7411544
Proje hakkında
Seçilen:
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.
Bu iş için 4 freelancer ortalamada $47 teklif veriyor
Hello, thank you for the invitation. Can you post a couple Excel files to review -- Thank you Alexey
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