I would like to be able to upload an Excel (xls) file to my hosting server, convert it to HTML and place it into a particular folder. Currently I am having to convert them on my local computer and upload them. Others will be using this so I would love to be able to have them do it right online. I found THIS SCRIPT that does the file conversion but I cannot find a way to get a hold of that person. Does anyone know of a similar type of script that will do what I need?
I would check how it is being done - most scripts use a comm object from MS but even MS themselves recommend that you dont use this as it is ultra inefficient, ok if you want one or two a day done but certainly not suitable to allow general site users to have access to. Are you simply wanting the table data or are you also wanting the formating etc? Will the cells only contain strings or will there also be formula's/ calculated fields? If it is a basic job that you want not including formating then you would have a much easier life if you converted the xls file to a csv before uploading.
I have found several programs that do the conversion quite well. So far they seem to keep all of the formatting and formulas/calculations quite well. I do not want it for general use. I have a site with a password protected area for several sales agents to access. only one person would have access to uploading the files while the others can only view the data. I thought this would be much easier because the guy I am doing this for has several Excel files each containing several sheets. I thought this would be easier than setting up a database, converting to CSV files and the whole nine yards. Not to mention, he seems to want to constintely change the formatting and infor within the files.