Hi Team,
I would like to converted a excel sheet which has formulas and filters to be converted to an html file and retain the same interactive functionality wherein i would be able to entry some basic data using the files and drop down.
In attached sheet, I would need to edit the Project Start Date "B3" only and rest of the formulas should be applied and return the "B4" value and also users should be able to use the filter function. All needs to be done through webpage.
Thanks
Raju
Hi Team,
Any Update ref my post.
excel does not inherently have this feature
you will need to look for an addon
you will get varying results based on how complex your sheet and how much your budget is....
If you are satisfied with the solution(s) provided, please mark your thread as Solved.
Select Thread Tools-> Mark thread as Solved. To undo, select Thread Tools-> Mark thread as Unsolved.
rajuganapathy, use this code:
Please Login or Register to view this content.
(*) Reputation points appreciated.
excelbs.tk
michson:
im pretty sure that is not an interactive html output but a static html file
also there is option in excel 2013 for xlHtmlCalc instead of xlHtmlStatic
https://msdn.microsoft.com/en-us/lib.../ff194386.aspx
however i don't have 2013 to test to see what it does
Thanks for the code and its only converting the sheet into a static webpage, however my requirement was to use the functionality of drop down and also editing the date field in the Html webpage.
found other threads which say the same thing
http://www.excelforum.com/excel-prog...l-webpage.html
http://www.excelforum.com/excel-gene...questions.html
you have to do other stuff outside of VBA/excel but itself
something like this maybe?
http://www.spreadsheetconverter.com/...tml-converter/
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks