Excel to HTML tables

Končano Objavljeno Apr 28, 2014 Plačilo ob prevzemu
Končano Plačilo ob prevzemu

Simple brief:

We need a macro written so that every week it will output eight sets of two HTML tables (sixteen files in all) ready for inclusion on a web page with PHP. You'll also need to write some PHP so that on any given date two of the HTML files are included into the web page. The HTML files will be named [url removed, login to view] and [url removed, login to view] -- e.g. [url removed, login to view] and 20140106_days.html.

There will be TWO Excel source files each week. One will always remain the same name, [url removed, login to view], the other will change each week based on the day of the week. Once again it will be in YYYYMMDD format such as 20140106_programme.xls.

Once I have chosen a freelancer, you will need to be able to complete the work with any revisions within three days.

Worked examples:

Please see the attached dated files for worked examples.

More details:

Must be able to read from two Excel files one which changes each week and a static Excel file with a table of movies and links and output sixteen HTML files (2 x eight) one with each type of table for each day of the new week. The need for eight sets of tables when there are only seven days in the week is because on the day the macro is run, the last day from the previous week will be overwritten and replaced. In the attached examples the files [url removed, login to view] and [url removed, login to view] will both be overwritten by the next weeks first file.

Must be able to output appropriately styled table cells (leave hooks for adding CSS to).

Must be able to add the hyperlinks for each movie (see [url removed, login to view]).

Must be able to have ‘closed’ on appropriate days (Mondays/others). If there are no sessions for that day, then the cells should be merged and show 'closed'.

Must be able to cope with a blank cell for a session time.

Must be able to cope with different starting times. For example, if there is a red cell above the starting time it is to read '5:30 for 6:00'.

Must convert times to a standard format (i.e. ‘9:30am’or ‘1:20pm’ and consistent across the board).

Must be able to use two, three or more session times per cell.

Must be able to utilise Drop Box (local copy) for the source of Excel files therefore I must be able change the path structure for the source files.

Would be nice for it to be able to cope with both internal and external hyperlinks.

Would be nice for it to be able to cope with both .xls and .xlsx files

PHP Visual Basic za aplikacije

ID projekta: #5867131

Več o projektu

28 predlogov Oddaljen projekt Aktiven May 2, 2014

Dodeljeno:

cheapexcell

Hello Sir, I am not sure if a macro can do this, I will create a Windows app with GUI for you if you are interested. Ready to start. Thanks, Alex

$421 USD v 3 dneh
(96 mnenj)
6.3

28 freelancerjev ponuja v povprečju za $580 na tem delu

varun8211

H brucecode, Please provide me an estimate for developing the site as outlined in the Feature Requirements Document posted. $2000 Approx, the cost for product upload and listing may depend on their numbers so it Več

$1052 USD v 10 dneh
(20 ocen)
8.0
rajeshsonisl

Hello, With 99% completion rate, 650+ 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 wro Več

$721 USD v 4 dneh
(469 ocen)
7.5
syfaldeen

Hi, I can complete the project in 3 days as required; however, I don't see any need to use VBA! All the requirements can be developed in pure PHP where the server checks for new Excel files every week in the specifie Več

$750 USD v 3 dneh
(37 ocen)
6.7
mantislin

Are you here? Can you response me? Hi sir, I just check all details, can we do it with PHP script, use PHP to read excel data and output to html file? Thanks, Kimi

$500 USD v 5 dneh
(133 ocen)
6.6
eComOS

Dear sir, I will complete your project within 4 days and provide ONE YEAR free bug guarantee.. I have gone through your outsourced requirement "Excel to HTML tables" and have analyzed that I have right credentials ( Več

$591 USD v 365 dneh
(72 ocen)
6.0
bsubramaniam1234

Hi,the data's from excel sheet can be viewed as HTML using php using CSV technique and can be moved into your desired directory as well using move_uploaded_file() function in PHP,I have a question you want this proce Več

$722 USD v 10 dneh
(15 ocen)
5.9
angwangri

HI sir, i am a web developer in dahuasoft online support. I have just read your job description and been excited. Because I have just finished very similar job like your requirements. Please check my working histor Več

$700 USD v 10 dneh
(19 ocen)
5.6
ebinarylogix

HI, I am expert in PHP and I can help you write script for transformation of excel to html as your recommended solutions. Will be really interested in discussion. Please send me message and we will initiate chat. Addy

$526 USD v 5 dneh
(17 ocen)
5.6
byrasoft

A proposal has not yet been provided

$666 USD v 5 dneh
(49 ocen)
4.7
dpune

Hi, I have more than 14 years of exp and I am expert in this kind of work. I have completed more than 200 projects. Please look at the feedback left by my employer to know more about my work. Waiting for your positive Več

$500 USD v 10 dneh
(28 ocen)
4.5
denissilanov

Hi! I have 8 years experience in programming and know VBA and PHP well. I can make this project for you. Everything will be done according to your requirements. Denis.

$700 USD v 5 dneh
(7 ocen)
4.3
MuradMurad

Hi, I have lots of experience with automation in Excel, Word, Powerpoint and all MS products, as well as with loading remote data. I can finish the job in 3 days and in fact will start to prepare you a demo.

$622 USD v 3 dneh
(4 ocen)
4.2
Time2win

Hello, We have excellent team of programmers and designers to work on your project efficiently and complete job in time. We have read your deepest requirement at our best and will surely give better results. thanks

$789 USD v 20 dneh
(10 ocen)
4.1
Aan12

I can do this type of job at minimum cost and in three days. All I need is to ask a few questions about this proyect so I can start with it. Thanks!

$250 USD v 3 dneh
(4 ocen)
2.4
Ecoseit

hi , i am ready to work with you on least amount while giving you better quality then any other one !! the reason is just to create a long term realtions with you and your organization !! i am having more then Več

$250 USD v 10 dneh
(3 ocen)
1.2
step1x

Hi, At first I would like to request to take a look at my portfolio. 10+ years of web development. I can help you. Let's work.

$526 USD v 3 dneh
(1 Ocena)
1.0
raviprashanth83

Hi Bruce Code, Its already 23 bids on your project. Still, I am going to bid for this project, which shows my knowledge, and expertise in Excel VBA. I clearly understand your requirement, and hope to do it better Več

$250 USD v 3 dneh
(1 Ocena)
0.5
rajeshgrv

have gone through with the requirement and we can start this project now. I want to introduce our self, we are a group of freelancers we have 11 year of experience in web application development and design, we w Več

$610 USD v 20 dneh
(0 ocen)
0.0
ZenAspirations

Hello, I can allocate a programmer for you with whom you can contact directly. He will work according to your requirements and will send you daily work updates. He meets all your required skills. If you are interest Več

$750 USD v 12 dneh
(0 ocen)
0.0
dilishjacob

Hi, I have 8+ years experience. I am able to deliver work in small period with good quality. Already did this type of xl reading query in PHP Expert in PHP, Codeigniter, Wordpress, Flash Actionscript (AS3), Več

$777 USD v 3 dneh
(0 ocen)
0.0