[Tugindia] [texhax] Creating labels from excel sheets

Uwe Ziegenhagen ziegenhagen at gmail.com
Wed Dec 10 20:46:10 CET 2014


What I have made good experience was to directly use Excel without
exporting to CSV.

Just assume you have data in the cells A1 and B1 like in the attached
graphics. Using Excel formulas you can simply generate the LaTeX code.

I use in the German Excel "Zeichen(10)" to create a line break, I'd expect
the English function name to be something like "character(10)". After that
I simply copy all rows to my TeX editor and remove the " via search/replace.

Normally I use this functionality to maintain lists of captions in Excel,
in you case it could work as well.

Uwe



2014-12-10 12:50 GMT+01:00 bhutex <bhutex at gmail.com>:

> 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
> क्या आप यह देख पा रहें हैं।
> इस का मतलब आप का कम्प्यूटर यूनीकोड
> को समझती है। देर किस बात की हिन्दी मे
> चिठ्ठियां लिखिये।
>
>
> _______________________________________________
> TeX FAQ: http://www.tex.ac.uk/faq
> Mailing list archives: http://tug.org/pipermail/texhax/
> More links: http://tug.org/begin.html
>
> Automated subscription management: http://tug.org/mailman/listinfo/texhax
> Human mailing list managers: postmaster at tug.org
>



-- 
Dr. Uwe Ziegenhagen
<http://www.uweziegenhagen.de>


More information about the tugindia mailing list