I have an enormous Excel 2010 .xlsx file set up in text cell format. This .xlsx has eleven columns and many thousands of rows. I want to have each row displayed as an individual HTML web page in this manner:
Cell A1 - The URL of the page
Cell B1 - All the < head > HTML code up to:
Cell C1 - HTML Page Title
Cell D1 - All of the rest of the HTML < head > coding up to:
Cell E1 - HTML Head Title
Cell F1 - All of the HTML to get to:
Cell G1 - Paragraph #1
Cell H1 - Paragraph #2
Cell I1 - Paragraph #3
Cell J1 - Paragraph #4
Cell K1 - All of the final HTML which ends in < /html >
The coding and position is absolutely identical for all HTML pages, so the next row would be A2, B2, C2, etc. The only variable from HTML web page number 1 to number 100,000+ is the text content in A1, C1, E1, G1, H1, I1, and J1. Note that the final HTML pages will not be visible in a web browser as a spreadsheet but as properly formatted and designed individual HTML pages.
Important note: The .xlsx is updated periodically thus the HTML changes on each and every page must appear on the website quickly.
This is the current format. If I need to export the Excel to Access format, I can do that easily. I have no preferences as to how this task is achieved, how it is programmed, etc. My only concern is that I want it to work quickly and efficiently on a very powerful Core i7.
35 freelancer bu iş için ortalamada 79$ teklif veriyor
Dear Buyer, We have gone through your requirement and ready to complete the job within time frame. Check your PMB for detail. Thank you, BDM, Zeesol
Very simple task for me (i've done the similar task before) i'll give you application to generate HTMLS from Excel. Python (executable standalone application)