Lukket

php excel reader and display resultsin html

on html page 5 different field

Postcode,AQ,Profile,Area,Uplift

Uplift field is used for adding digits up on top of the values displayed dynamically

there is two different Headings E and G means we will divide the page in two with different Headings from the files..

All the EXCEL files is a price-book that refreshed every week so we replace the files every week. for this reason your script needs to be able to read this files even if they replaced assuming same format.

for example

first box we enter 03 profile

2nd box we enter 10 Area

======================================================================================

Category E Files

FOR DUAL

file SMART Saver Acquisition Price book (aug14).xls

Can you check if you can make your script read from the file and do this:

as well as other fields we will have one single html page and few fields to enter some number and it will read from the file and display the correct row

so based on this entry

script should open the sheet 10

and list the result from

ROW18,19 with headings as 3YEAR results

and ROW 35,36 as 2YEAR results

so it would use the same heading but we would add another column to beginning called LENGTH to display if it is 2YEAR or 3YEAR

FOR SSE

file [url removed, login to view]

when we enter 03 and 10

on the first sheet the correct ROW is 4 and 5 you will see ColumnD and ColumnE defines that from what entered

this would read from all sheets as each sheet is for 12,24,36,48month

=======================================================================================

Category G files

FOR CNG

file=DIRECT CNG 24Mth Latest from [url removed, login to view] (you will find this file have hidden Rows so your script will need to be able to see the hidden rows automatically to work properly ,... )

profile and area fields wont effect for this file

provided what postcode entered if script can enter the values on ColumnB and get results from ColumnD and show them on page that is great

postcode is the 2nd sheet in this file and you will see how it works, we will have postcode field to enter on html and once we enter it will find the nearest matching postcode in the file and it will enter the value into that cell in columnB

if you enter 90000 into B14 CELL you will see the price result changes on right so that's what is needed to be displayed on HTML page..

FOR GP

file:20p-65p MATRIX - VERSION [url removed, login to view]

profile and area fields wont effect for this file

on ColumnB you can see all the AQ range (we will have an AQ field to enter)

so if i enter 10000 this would display the ROW (21-22)

Evner: C programmering, Javascript, Linux, PHP, Python

Se mere: works need excel, html 5 book, how to get a value in javascript, how excel works, what is html 5, script reader, smart xls, gp as, find reader, file reader, sse, excel show different based value, display excel cell, single html, find postcode php, excel can open file, excel read cell value, php effect, php excel read, excel list files add, dual php, excel format cell, excel cell format, excel html sheets, php hidden fields

Om arbejdsgiveren:
( 48 bedømmelser ) London, United Kingdom

Projekt ID: #6428584

12 freelancere byder i gennemsnit $262 på dette job

rajeshsonisl

Hello, With 99% completion rate, 700 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 !!)... you can never go wron Flere

$789 USD in 3 dage
(713 bedømmelser)
7.5
zeke

I have experience working with similar project. Available to start immediately and finish as soon as possible.

$166 USD in 3 dage
(203 bedømmelser)
7.1
akinwale

Hello, I have reviewed your requirements and I can implement a complete solution for you within 3 days. I have over 9 years of experience with PHP development and I am available to start working on this immediately. Qu Flere

$250 USD in 3 dage
(87 bedømmelser)
6.4
evidcomm

Hello Hiring manager, Greetings from Evidcomm!!! We have gone through your requirements and would be pleased to work on. We have already done this kind of work in past and surely we will get finished this project Flere

$210 USD in 6 dage
(68 bedømmelser)
6.4
stevecorsi

lets do it ? lets do it ? lets do it ? lets do it ? lets do it ? lets do it ? lets do it ? lets do it ? lets do it ? lets do it ? lets do it ?

$250 USD in 3 dage
(39 bedømmelser)
6.0
anuyadav1

i can write this php script to read excel and display on page .

$230 USD in 5 dage
(49 bedømmelser)
5.5
miraclesolution

Greetings I would like to discuss in more details before placing a confirm bid. Let me know if you have some time to chat on Freelancer. Awaiting to hear from you,Have done similar work to your requirements in the pa Flere

$222 USD in 3 dage
(38 bedømmelser)
5.4
ThemePlugger

A proposal has not yet been provided

$250 USD in 5 dage
(29 bedømmelser)
5.1
drudev

Hello. I am a web developer with 11+-year experience . I work remotely on DigitalRay company - [login to view URL] - LA (USA). Technical knowledges: 1PHP JavaScript Ruby RoR ASP.Net C#, Java, Python, Zend, CakePHP, Symph Flere

$377 USD in 3 dage
(48 bedømmelser)
5.0
AndonData

Hi, I am expert in graphic design. we can show you our previous work for quality test. So may i know what's the right time to talk you about this project. Hope you will reply me soon,I will wait for your's v Flere

$200 USD in 2 dage
(56 bedømmelser)
4.8
sarpinfotech

Hi I work towards providing reliable, relevant and robust IT solutions at most competitive prices to my customers. I ensure 100% customer satisfaction so lets start. you can check our latest job here: Flere

$200 USD in 3 dage
(18 bedømmelser)
4.2
Excellentlancer

Dear sir, In 7 years working will PHP, I played with Excel many times. It isn't difficult to read and display the Excel data in HTML Pages. I've read your specs also check 4 attached file carefully. I can complete Flere

$100 USD in 3 dage
(5 bedømmelser)
1.6
rkarwa

A proposal has not yet been provided

$100 USD in 5 dage
(1 bedømmelse)
0.8