[texhax] Creating labels from excel sheets

bhutex bhutex at gmail.com
Wed Dec 10 12:50:47 CET 2014


We have to create desk slips for conducting an examination. The desk slip/
label will have the following information :

...... examination - 2014
Subject : xyz
Roll No. 0293993

The data of RollNo, Subject and Venue of examination (examination center)
are maintained in an excel sheet - nearly 40 examination centres and 80
subjects total candidates about 20 thousand.

I created desk slip with the use of csvtools and the code is given below :

\documentclass[a4paper,12pt]{article}

\usepackage{csvtools}
\usepackage[left=.5cm,right=.5cm,top=.5cm,bottom=.5cm]{geometry}
\usepackage{multicol}
\usepackage{xcolor}

\begin{document}

\applyCSVfile{data.csv}{% here put the name of the file
%\begin{multicols}{2}
\noindent\fbox{\parbox{6.3cm}{%
{\color{white}.}\\[7pt]
\centering{\LARGE UGC NET - 2014}\\[2pt]
\raggedright
{\Large Subject : \insertSubject}\\[5pt]
{\Large Roll No. : \textbf{0\insertRollNo}}\\[12pt]
}} % This is for parbox
%\end{multicols}
}% This is for CSV file


\end{document}

With the above my purpose is solved. But for this for every subject and
centre we have to create separate csv files.

Is there any better to get the lables printed - centre wise/ subject wise
from a single csv file without creating many csv files. It will be better
If we can print  8 x 3 lables on a4paper.

-- 
Happy (La)TeXing
The BHU TeX Group
क्या आप यह देख पा रहें हैं।
इस का मतलब आप का कम्प्यूटर यूनीकोड
को समझती है। देर किस बात की हिन्दी मे
चिठ्ठियां लिखिये।
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://tug.org/pipermail/texhax/attachments/20141210/67ba8a98/attachment.html>


More information about the texhax mailing list