Programming Praxis

20 Responses to “Translate CSV To HTML”

1. Programming Praxis – Translate CSV To HTML « Bonsai Code said

   January 15, 2013 at 9:44 AM

   […] today’s Programming Praxis exercise, our goal is to translate a csv file to an HTML table. Let’s get […]
2. Remco Niemeijer said

   January 15, 2013 at 9:44 AM

   My Haskell solution (see http://bonsaicode.wordpress.com/2013/01/15/programming-praxis-translate-csv-to-html/ for a version with comments):

   import Text.CSV
   import Text.Printf
   
   toTable :: [[String]] -> String
   toTable = wrap "table" unlines . wrap "tr" concat $ wrap "td" id id where
       wrap :: String -> ([b] -> String) -> (a -> b) -> [a] -> String
       wrap tag combine f xs = printf "<%s>%s</%s>" tag (combine $ map f xs) tag
   
   main :: IO ()
   main = putStrLn . either show toTable =<< parseCSVFromFile "test.csv"
   
3. Exploring Java world said

   January 15, 2013 at 10:36 AM

   […] Question is from here: […]
4. javabloggi said

   January 15, 2013 at 10:44 AM

   Java solution here.
5. JT (@jstolle) said

   January 15, 2013 at 3:23 PM

   Answer in awk (here)[http://psykotedy.tumblr.com/post/40602728216/programming-praxis-convert-csv-to-html].
6. JT (@jstolle) said

   January 15, 2013 at 3:28 PM

   Sorry for the sloppy comment, I don’t know the markup required for the comments here.
7. Translate CSV To HTML | My Blog said

   January 15, 2013 at 7:08 PM

   […] Pages: 1 2 […]
8. Scott Hyndman said

   January 15, 2013 at 10:20 PM

   Ruby solution

   "<table><tr><td>#{csv.split("\n").join('</td></tr><tr><td>').split(',').join('</td><td>')}</td></tr></table>"
   
9. jpv said

   January 16, 2013 at 6:27 PM

   Doesn’t seem anyone other than Programming Praxis dealt with quoted strings
   (which, granted, isn’t necessarily a part of ‘official’ CSV files). It does
   make the code quite a bit more interesting if you do. :)

   Anyways, here’s my short (ugly) version that doesn’t deal with quoted
   strings:

   (require racket/string)
   
   (define (csv->html csv)
     (printf "<table>\n")
     (for ([line (in-list (string-split csv "\n"))])
       (printf "  <tr>\n")
       (for ([item (in-list (string-split line ","))])
         (printf "    <td>~s</td>\n" item))
       (printf "  </tr>\n"))
     (printf "</table>\n"))
   

   And here’s a longer (more awesome!) version that correctly deals with
   quotes and translates what it can to Scheme values (numbers, symbols,
   #t/#f, etc): blog post
10. Reading csv files | GSmith said

    January 17, 2013 at 2:25 AM

    […] post is a Python solution to a programming challenge from Programming Praxis. The challenge is to read a csv file and convert it into an html […]
11. Meke said

    January 17, 2013 at 9:51 PM

    Here’s a solution in PHP:

    <?php
    define("DIRECTORY", "./");
    if (file_exists(DIRECTORY."x.txt")) {
    $xfile = fopen(DIRECTORY."x.txt", "r");
    $xcontent = fgetcsv($xfile);
    echo "
    “;
    foreach ($xcontent as $xentry) {
    echo “”.$xentry.””;
    }
    echo ”

    “;
    } else die(“The file does not exist.”);
    ?>
12. mekesia said

    January 17, 2013 at 9:55 PM

    Quotation marks delineated with a q:

    <?php
    define("DIRECTORY", "./");
    if (file_exists(DIRECTORY."x.txt")) {
    $xfile = fopen(DIRECTORY."x.txt", "r");
    $xcontent = fgetcsv($xfile);
    echo q
    q;
    foreach ($xcontent as $xentry) {
    echo qq.$xentry.qq;
    }
    echo q

    q;
    } else die(“The file does not exist.”);
    ?>
13. mekesia said

    January 18, 2013 at 1:56 AM

    Third time is NOT a charm… :/
14. Praveen S M said

    January 18, 2013 at 12:14 PM

    CSV To HTML
15. Praveen S M said

    January 18, 2013 at 12:17 PM

    Using JSP

    CSV To HTML
16. Mike said

    January 19, 2013 at 4:45 AM

    Python 3.3 solution. Uses the standard library csv to read the file and elementtree to build the table as an xml document. The tostring method takes care of properly escaping characters like <, if any, in the file.

    import csv
    import xml.etree.ElementTree as et

    def csv2html(filelike_obj, id_=None):

    table = et.Element(‘table’, {‘id’:id_} if id_ else {})

    for n, line in enumerate(csv.reader(filelike_obj)):
    row = et.SubElement(table, ‘tr’)
    if n&1: row.set(‘class’, ‘odd’)

    for item in line:
    col = et.SubElement(row, ‘td’)
    col.text = item

    return et.tostring(table, method=’html’).decode()
17. Mike said

    January 19, 2013 at 4:59 AM

    Not sure what happened to the formatting above.

    import csv
    import xml.etree.ElementTree as et
    
    def csv2html(filelike_obj, id_=None):
    
        table = et.Element('table', {'id':id_} if id_ else {})
    
        for n, line in enumerate(csv.reader(filelike_obj)):
            row = et.SubElement(table, 'tr')
            if n&1: row.set('class', 'odd')
            
            for item in line:
                col = et.SubElement(row, 'td')
                col.text = item
    
        return et.tostring(table, method='html').decode()
    
    
18. dead_ant said

    February 5, 2013 at 5:57 PM

    C#:

    static string Csv2Html(string filePath) {
                    return "<table>" + 
                        new StreamReader(filePath)
                            .ReadToEnd()
                            .Split('\n')
                            .Aggregate(string.Empty, (body, record) => body + "<tr>" + 
                                record.Trim()
                                .Split(',').Aggregate(string.Empty, (w, s) => w  + "<td>" + s + "</td>")
                               + "</tr>\n") + "</table>";
                }
    
19. erdalkiran said

    February 12, 2013 at 7:45 PM

    C#:

    namespace CsvToHtml
    {
        using System.IO;
        using System.Text;
        using System.Web;
    
        internal class Program
        {
            #region Methods
    
            private static void Main(string[] args)
            {
                var csv = ReadData(args[0]);
                var htmlEncoded = HttpUtility.HtmlEncode(csv);
                
                var html = new StringBuilder("<table><tr><td>");
                html.Append(htmlEncoded.Replace(",", "</td></tr><tr><td>"));
                html.Append("</td></tr></table>");
            }
    
            private static string ReadData(string fileName)
            {
                var str = new StringBuilder();
    
                using (var stream = new StreamReader(fileName))
                {
                    var buffer = new char[1024];
    
                    while (!stream.EndOfStream)
                    {
                        var charactersRead = stream.ReadBlock(buffer, 0, 1024);
                        str.Append(new string(buffer, 0, charactersRead));
                    }
                }
    
                return str.ToString();
            }
    
            #endregion
        }
    }
    
20. dead_ant said

    February 14, 2013 at 2:29 PM

    erdalkiran, few comments on your solution:

    1. It generates 1-column table – for every comma in the source you produce a new row in the output. Instead it should produce a cell for every comma and a row for each newline.
    2. I see no reason for manual buffered read in this case – you don’t process those chunks one by one, and in the end you still have a full raw string in memory, so why not use something like StreamReader.ReadToEnd() for simplicity?
    3. I can’t see a practical reason for using StringBuilder to store the final output here. StringBuilder might save you memory allocations and some processor cycles if you have lots of string operations, true. But you only have 2 appends. Your code will still likely force a StringBuilder to allocate memory for its internal storage, perhaps more times than it would take to allocate 3 usual immutable strings in the first place.

    Thus, I would suggest to implement your approach something like this:

    static string Csv2Html(string filePath) {
        return "<table><tr><td>" +
            new StreamReader(filePath)
                .ReadToEnd()
                .Replace("\n", "</td></tr><tr><td>") //new row for each newline
                .Replace("\r", string.Empty) //getting rid of newline leftovers, just in case
                .Replace(",", "</td><td>") //new cell for each comma
        + "</td></tr></table>";
    }