Home » questions » how can i create a HTML form from a .CSV or EXCEL file?

how can i create a HTML form from a .CSV or EXCEL file?

7
2006-08-15 15:13:05, Category: Programming & Design
Hi I get data sent to me from various people everyday in excel format. Theres literally 1000's of bits of data each day. at present, i put them into an online form manually, one by one, which submits them through aload of php functions and ultimately, the correct DB table (depending on the data). Is there a script i could use that would convert these excel (or csv) files into a html style form that i could submit to my existing scripts to be processed? Theres a few php and .hta scripts ive found, but none of them seem to work at all. Im using php mainly, but Im willing to try just about anything. Thanks in advance

Answers

  1. peekay

    On 2006-08-15 15:32:54


    i don't know if this software would be overly simplistic for your needs, but there are a few "excel to html" programs out there - many offer trial periods, but finding a completely free version (legally) won't be easy. this particular one can handle automated batches of excel files for processing in one go. is this the kind of thing you're looking for: http://www.dozp.com/spreadsheet2html.htm if my answer helped, don't forget to 'accept' it.

  2. whoawhoamrslibby

    On 2006-08-15 15:18:53


    why don't you try to make one? then you can sell it....but there aren't any that I've heard of.

  3. bishoprusty

    On 2006-08-15 15:35:04


    If you are using MS Front page you can place your Excel Spreadsheet inside of a HTML page. Use insert-> component-> officespead sheet. Then use the spreadsheet property tool box (at the top of the spreadsheet) to import the data or auto update the data. If you don't have Front page, Make a table, copy and past your column to the web pages columns, But remember that each browser will interpret a table a little differently (tables are not exact) so all your data might not line up correctly.

  4. banjobarry

    On 2006-08-15 15:30:09


    I don't know if you'd want to use Dreamweaver, but it has a menu option to import CSV files to tables (although I don't know if this would work for DB tables). Import CSV files into MySQL http://codewalkers.com/seecode/448.html Here is a link to a site that shows how to take a csv or other delimited data file and import it INTO MySQL with a script http://www.modwest.com/help/kb6-253.html

  5. arpu2003

    On 2006-08-15 15:18:17


    I do not know about Html.

  6. sheeple_rancher

    On 2006-08-15 15:53:17


    Converting CSV to table is pretty straight forward in php. You would explode each line (by ',') into an array, then write followed by a array element and then . The only problem that might ocur is if quoted text in the csv file contained a comma - you would get an false spit - so you might have to manually explote the lines. Still not a big deal. There has to be lots of scripts out there that handle it realy well.

  7. stratsandlespauls

    On 2006-08-15 15:27:38


    I'd recommend ASP, ASP.NET, or VB6, or VB.NET Any one of these languages provide you with an Excel Object you can instatiate and then create a text file output (ie:data.html) placing the data throughout along with HTML tags. The data from the users need to be consistant though and can't be all different as you are needing to expect the data you want to be in specific cells. You'll need to create a excell template that can't be modified except for data input