Tables/Database module

TODO: more examples and explanation (See: To-Do List)

Inline

• \setuplayout[scale=0.8]
  \usemodule[database]
  
  \defineseparatedlist
    [MyTable]
    [separator=tab,
     left=\bTD,right=\eTD,
     first=\bTR,last=\eTR,
     before=\bTABLE,after=\eTABLE]
  
  \setupTABLE[c][each][align=flushright,width=2.5cm,align=middle]
  \setupTABLE[r][1][background=color,backgroundcolor=gray]
  \startMyTable
  Cows	Total	Milking	Pregnant
  01/1995	1709	1449	260
  01/1996	1713	1444	269
  01/1997	1606	1387	219
  01/1998	1634	1416	218
  11/1998	1558	1350	208
  11/1999	1520	1307	212
  11/2000	1475	1285	190
  11/2001	1496	1345	151
  11/2002	1498	1338	160
  11/2003	1492	1324	169
  11/2004	1457	1295	161
  11/2005	1421	1263	158
  \stopMyTable
  
  %load from a file
  %\processseparatedfile[TSV][cows.tsv]
  
  

• 

Data from File

\usemodule[database]

\starttext

\defineseparatedlist
 [test]
 [separator=space, % tab
  before=\bTABLE,after=\eTABLE,
  first=\bTR,last=\eTR,
  left=\bTD,right=\eTD]

\processdatabasefile[test][csv.csv]

\stoptext

Links

• exceltex - LaTeX package to fetch data from Excel documents ( Scripting Excel article )
• tab4tex - Preprocessor for LaTeX tabular environments
• Creating tables using CSV (comma–separated values) : My Way by Mojca Miklavec.
• Using ConTeXt with Databases by Thomas A. Schmitz (article in NTG-MAPS about XML and SQL databases).