As a client required I was looking for a solution to creating some html pages for upload to a web site from a csv file exported from excel. The other requirement was that as much as possible of the process would be automated so that the user would update the file – run a process and the web site reflect the latest changes. Using webdrive to map a network drive to an ftp account where the files could be update was the first part of the equation. Secondly I needed a tool that could be scripted and run from the command line to produce the necessary output.
So I researched and came across Total Excel Convertor from here
As the developer describes it – Total Excel Converter is the perfect choice to convert any kind of table. Supported formats include Excel and Excel 2007, as well as OpenOffice formats (.odt, .ods) and .xml, .sql, wk2, wks, .dbf, .tex, .difThe list of target formats is even more extensive. It includes Word (both Doc and DocX), PDF, HTML, Access, TXT, ODT, ODS, XML, SQL, CSV, Lotus, DBF, TEX, DIFF, SYLK, LaTeX.
New! Total Excel Converter can easily convert OpenOffice .ods files to Microsoft .xls documents. This makes spread sheets produced by different programs compatible with your viewer.
Total Excel Converter does the job perfectly. Select the file you want to convert and press the Convert button. The program Wizard will help you to make all the settings (it automatically sets the most appropriate, but you can change them according to your requirements).
Total Excel Converter may be run from the command line. As well as this, it integrates into MS Windows. That means that you don’t have to launch the program to convert your XLS or XLSX files. Just right click the file on your desktop. Select the option Convert To in the popup menu. Choose the target format: the program does the rest.
So after some testing I was able to show the client a low cost means of pulling data from their line of business system – allowing changes to be made and then an automated trasnfer of the data from csv text to html table with some formatting with the user have to learn how to do it all themselves. There are some things I’d like it to do – allow me to specify numbers of rows per page and the ability to create a seperate page per row with links back to a single or multi page html index but these are for additional use for other clients.