Convert xlsx spreadsheet to php array

已完成 已发布的 Nov 13, 2015 货到付款
已完成 货到付款

This is a small project that involves taking an uploaded xlsx file and converting the xml data contained to a PHP array with structure of Array([0]('key'=>'value','key2'=>'value2'...). Column headings are to be used as keys for each cell. Empty cells cannot be skipped. Each row of the spreadsheet becomes another row in the array, i.e., one array returned with multiple rows and key=>value pairs within.

A couple of the bidders have asked for more details about the project. I'm submitting a sample spreadsheet and here is the desired array structure from the output. Note empty spreadsheet cells are included as blank values in the array. Also, these spreadsheets are coming from a third-party website which I do not control. Therefore, future columns in the spreadsheet are subject to change and the column headings must be used as keys in the array.
Array([0]=>
Array("Last_name"=>"Allen", "Middle_initial"=>"", "First_name"=>Scott, "Nickname"=>"", "Prefix"=>"", "Suffix"=>"", "Join_date"=>"7/3/2008", "Email"=>"scott.alle@xxx.com", "Preferred_address"=>"65655 C Rd","Washington"...),
[1]=>Array("Last_name"=>"Anton", "Middle_initial"=>"", "First_name"=>Steve, "Nickname"=>"", "Prefix"=>"", "Suffix"=>"", "Join_date"=>"7/3/2010", "Email"=>"", "Preferred_address"=>"1 Main Rd", "Preferred_City"=>"Washington"...)
)

PHP

项目ID: #8900313

关于项目

14个方案 远程项目 活跃的Nov 22, 2015

授予:

justTry

Hello! Would you rather explain further, because it's first an excel file then xml, and with no file sample atatched it's difficult to realize what you are talking about. Regards, Dobri

$40 USD 在1天内
(146条评论)
5.9

有14名威客正在参与此工作的竞标,均价$49/小时

rajeshsonisl

Hello! With 98% to 99% completion rate, 850+ successfully completed projects, and a 5.00 reputation (maximum possible, 5.0) (Yes, not even 4.99 average rating, can be verified on my profile page [login to view URL] 更多

$94USD 在1天里
(884条评论)
8.5
sprextech

Dear Sir/Madam, I Have already read your project description & fully understand this project for you. Also I have solid experienced professional in-house team of designers, developers and coders. We are offering best p 更多

$80USD 在1天里
(285条评论)
7.5
adicoman

Hi, I am very interested to work on your project. I have 11+ years experience in Web Development using a large variety of programming languages, frameworks, database architecture, APIs, CRMs, ERPs, mobile develo 更多

$64 USD 在3天内
(54条评论)
5.8
logicalsoft

A proposal has not yet been provided

$35 USD 在3天内
(8条评论)
5.3
binarygeotech

Hello, am an expert in web application development with over 8 years of experience. I have strong knowledge in creating and handling various web applications. I've created a lot of both singular and enterprise web appl 更多

$40 USD 在0天内
(31条评论)
5.3
smitakad89

plz come on chat now so we can discuss more and start.....am waiting

$30USD 在1天里
(22条评论)
5.0
manhpham

Hi there, My name is Manh, from Vietnam. I am highly interested in your project I have been working on this site for more than 4 years with many successful and interesting projects. I am willing to help y 更多

$55USD 在1天里
(11条评论)
4.0
Baxter2008

Hello. I can do this PHP class/module for you. Please be aware that it will require an additional/3rd-party open-source extension to be installed to parse the xlsx file. But beyond that, it's a quick and easy to do. 更多

$60USD 在1天里
(16条评论)
3.8
anuramafl

A proposal has not yet been provided

$35USD 在1天里
(6条评论)
2.8
jarjar78

Hello. I have a wide experience of writing different kind of parsers. So I will make this work quick according to your conditions. Sincerely, Yaroslav.

$50USD 在1天里
(1条评论)
1.0
XPoli

c'est un simple issue de conversion en php, alors il m'a prends 1 jour à le faire si vous étes intéresser

$30USD 在1天里
(1条评论)
0.2