Excel to HTML tables
$250-750 USD
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
ID projekta: #5867131
Več o projektu
Dodeljeno:
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
28 freelancerjev ponuja v povprečju za $580 na tem delu
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č
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
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č
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
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.
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.
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
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!
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.
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č
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č
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č