Reproduce a multi-sheet Excel form as a multi-page Gravity Form

Em Andamento Postado há 7 anos Pago na entrega
Em Andamento Pago na entrega

Extract values and formulas from an excel 2007 file, and filter data to reproduce a Gravity Form for each sheet.

__A software is needed, not the end result__

The excel file (xls 2003 to 2007) will contain more than one sheet.

Most sheets are forms, a sheet contains all definitions for selections.

Step 1) Parse the excel file to build a PHP array with all extracted information:

- data to reproduce in the Gravity Form is contained in colored cells;

- the 1st row can contain a keyword (uppercased) to ignore a column;

- the 1st row can contain the name of a cell (lowercased) which value is use to ignore some rows;

- some rows contain validation rules to reproduce in the Gravity Form;

- formulas in the cells use named cells:

-- create an entry in the PHP array;

-- store the formula with reference to the entry in the array.

The PHP array must look like this:

"sheet1" => array(

"titles" => array(

"my title for the 1st column",

"my title for the 2nd column",

...),

"label1" => "description for this entry",

"entry1" => array(

"var_name" => "named_cell1",

"type" => "input",

"validation" => "var1>2",

"message" => "value must be greater than 2",

...),

"label2" => "description for this 2nd entry",

"entry2" => array(

"var_name" => "the cell2",

"type" => "formula",

"definition" => "var1*100+SUM(D69:D84)",

"validation" => "var2+var1<250",

"message" => "value too high",

...),

"label3" => "select the percentage",

"entry3" => array(

"var_name" => "my cell3",

"type" => "select",

"definition" => 1,

"display as" => "percentage",

...),

...),

"definitions" => array(

1 => array(0.01, 0.02, ...),

...),

"variables" => array(

"named_cell1" => 42,

"the cell2" => 133,

"my cell3" => .05,

...);

You can propose something else if required.

Step 2) Build the multi-page Gravity Form from the PHP array:

- named cells in Excel must correspond to PHP variables in the array;

- formulas in Excel must use PHP variables in the array and be updated if the user modifies an entry in a previous page of the Gravity Form;

- submitting the form can allow the use of Gravity PDF ([url removed, login to view])

useful links:

* [url removed, login to view]

* [url removed, login to view]

sample file upon request.

Excel PHP Arquitetura de software WordPress

ID do Projeto: #10320301

Sobre o projeto

20 propostas Projeto remoto Ativo em há 7 anos

Concedido a:

bdsiddhi

Hi, Greetings !! We are a team of 29 full time, dedicated developers having expertise on native iOS & Android app development, Core PHP, Joomla, Magento, Wordpress, Moodle, Expression Engine, Prestashop, OpenCart, Mais

$726 USD em 19 dias
(148 Comentários)
8.0

20 freelancers estão ofertando em média $732 nesse trabalho

rajeshsonisl

Hello! With 98% to 99% completion rate, 900+ successfully completed projects, and a 4.99 reputation (maximum possible, 5.0) (can be verified on my profile page https://www.freelancer.com/u/rajeshsonisl.html !!)... y Mais

$736 USD in 10 dias
(743 Comentários)
8.0
gatelogix

HI, Hope you’re doing great! Before sending over the proposal, need to clarify few things. Please let me know when is a suitable time for a quick chat? We can even do the voice chat or video conferencing if poss Mais

$555 USD in 10 dias
(131 Comentários)
7.1
Thesynapses

Hello There, Greetings! Hope this finds you well. I had gone through your post and I have few queries related to your post: As you want a tool so that you can extract all the details put in required format. Mais

$1666 USD in 10 dias
(17 Comentários)
6.6
prashushinde9

Hello, I understood the initial scope of this project. Although i want to discuss further this job in order to prepare the final concept for this project. After Complete discussion over the call or in chat, i Mais

$773 USD in 20 dias
(53 Comentários)
6.8
Shopify

I want to discuss this project with you further, let me know the best suitable time for you to schedule the meeting, Feel free to message me at any time, i used to be online 14 hrs in a day on this website so probably Mais

$773 USD in 20 dias
(13 Comentários)
6.5
ZnDevelopers

Hi, I am ready to start it. But i have some questions for you. So kindly leave message for me, then i'll discuss it in depth.

$526 USD in 6 dias
(107 Comentários)
6.3
Handyman84

Hello May i know the deadline for this project? Also i want to know if you have a detailed brief if possible so I can understand better and to be able to provide you a fair quote and timeframe. Waiting your reply Mais

$948 USD in 30 dias
(12 Comentários)
6.2
rinabuoy13

Hello there, I am experienced developer in excel and other languages. I am a good fit for the task. Looking to hearing from you. Regards,

$333 USD in 15 dias
(34 Comentários)
4.8
FlyingMoon

Hello, client I have read your job post carefully. 1. I will parse excel file and make php arrays from it using PHPExcel. 2. I will built gravity forms with them Thank you

$400 USD in 10 dias
(5 Comentários)
4.4
MohsanEijaz

I have experience in MS Excel, VBA Programming, XML, MS Work, Google Docs, SEO, Google Spreadsheet, Data Entry in Odoo, Google Document and other related applications. I believe my capabilities would be perfect for yo Mais

$555 USD in 5 dias
(28 Comentários)
4.2