I am new in Latex and I have some issues. I have succeeded in reading the .csv file:


and using How to use datatool package to read a CSV files so that they can be used in tables? got this output:

Image 1

But now I have to format the table like this:

Image 2

and I don't know how, because first of all I don't know how to set the margins that the table can fit into the paper(I've used the geometry package to make the page landscape, but it is not enough).

Then each cell contains time of departure as hour followed by minute, both as two digits, but sometimes I don't have two digits,just one so I have to switch eg. from 12 4 -> 12 04.

Finally each data field means the minute of departure within the particular hour, e.g. number 25 in column w5 means time of departure 5:25, I don't know how to format this way. I was trying like this but I don't think this is the correct way:

\ifthenelse{\equal{\insertbyname{w5}}{}}{\insertbyname{w5}&}{{\bf 05} \insertbyname{w5} &}

If someone can help me I will be more than happy.

  • Welcome to TeX.sx! Usually, we don't put a greeting or a "thank you" in our posts. While this might seem strange at first, it is not a sign of lack of politeness, but rather part of our trying to keep everything very concise. Upvoting is the preferred way here to say "thank you" to users who helped you. :) May 16, 2012 at 23:42
  • Please post a separate question for the conversion of a one digit number to a two digit number as it is quite unrelated to database access. I have a solution, but don't think it makes sense to include it here. May 17, 2012 at 3:18

1 Answer 1


Since your table is very wide, the only real choice is to scale it to fit the full width of the page via \resizebox{\linewidth}{!}{\DTLdisplaydb{myDB}}. I won't include the full image as it is quite unreadable, but here is the left and right hand side of the table, with the frame drawn using \usepackage[showframe]{geometry}:

enter image description here ... enter image description here

As far as accessing the database, you need to use the key to locate the particular value. So, suppose you want to locate the value in row 1 of the w5 column, and the value of row 2 of the w6 column you use:


and the value gets stored in \myValue. So with the code below, we obtain:

enter image description here

To step through each row of the database, you can use a \DTLforeach. Below is the code showing how to process the first three columns of the data to yield:

enter image description here


  • As this question is more about accessing the data from the database, I have not addressed the specific issues of formatting the table. Those should be in a separate question as they are not unrelated to database access.



    % #1 = csname of where to store the result
    % #2 = key for column
    % #3 = row number


    The value of w5 in row 1 is \myValue.
    The value of w6 in row 2 is \myValue.

    \begin{tabular}{l l l l l}
            5 to & 6 to & 7 to \\
            6am  & 7am  & 8am  \\\hline
            5:\WFive &
            6:\WSix &
            7:\WSeven &
  • Thank you for the tips, but actually I don't know the number of lines in my .cvs file, so I need somehow to build the table automatically and more over how can I create the table to look like the one that I posted above? I can't use the structure of a table? May 17, 2012 at 9:32
  • @IonMorozan: Then use a DTLforeach to loop thru each row of your data. May 17, 2012 at 16:37
  • @IonMorozan: See updated solution showing how to step through each row. May 17, 2012 at 22:40
  • Thank you so much for your time! I really appreciate it! I was trying your code, but I get this error: ! Undefined control sequence}(near }% - last bracket). I tried to do some modifications but it doesn't work. Any ideas? May 17, 2012 at 23:48
  • @IonMorozan: I just checked and the code as is compiles for me (am using the latest version of TeXLive2011). Without more details I can not tell. Did you modify the code? May 17, 2012 at 23:55

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service, privacy policy and cookie policy

Not the answer you're looking for? Browse other questions tagged or ask your own question.