[Tugindia] Creating labels from excel sheets

[Harish Kumar Holla]

Can you send a sample csv file?

On Wed, Dec 10, 2014 at 5:20 PM, bhutex <bhutex at gmail.com> wrote:

> 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
> क्या आप यह देख पा रहें हैं।
> इस का मतलब आप का कम्प्यूटर यूनीकोड
> को समझती है। देर किस बात की हिन्दी मे
> चिठ्ठियां लिखिये।
> _______________________________________________
> Home:        http://www.tug.org.in/
> TeX FAQ:     http://www.tex.ac.uk/faq
> unsubscribe: http://tug.org/mailman/listinfo/tugindia




-- 
with regards
=========================
Dr. Harish Kumar
Dept. of Physics
Pondicherry Engineering College
Puducherry 605 014
Ph: 0413 2655281-286 (Extn: 646)
---------------------------------------------
Residence:
Dr. Harish Kumar
# 29 (New No.) I Main Cluny Road
Avvai Nagar, Lawspet
Puducherry 605 008
Ph: 0413 2253652, 9443052957
=========================