"LaTeX for Administrative Work" Example Files
- Example data.
-
- Download samples.sql or view contents.
- Download booklist.csv or view contents.
- Download people.csv or view contents.
- Download ordergroups.csv or view contents.
- Download orders.csv or view contents.
- Download country-codes.csv or view contents.
- Example Graphics Images
- shapes.pdf (or shapes.eps), me.pdf (or me.eps), dummy-logo.png (or dummy-logo.eps) and chicken.png (or chicken.eps).
- Convert a .csv File to a .dbtex File
- This example requires books-multiline.csv. Download or view LaTeX source.
- Convert an .xls Sheet to a .dbtex File
- This example requires shop.xls
The customers sheet can be converted to the file
customers.dbtex using:
datatooltk --output customers.dbtex --xls shop.xls --sheet customers
Alternatively you can use datatooltk-gui to import the data and save to a file called customers.dbtex. See Displaying Data Imported from a Spreadsheet for an example document that uses this data. - Importing SQL data to a .dbtex File
- The products.dbtex file can be fetched from the
samples SQL database
using:
datatooltk --output products.dbtex --sqluser sampleuser --sqldb samples --sql "SELECT * FROM books"
Alternatively you can use datatooltk-gui to import the data and save it to a file called products.dbtex. See Display Product List (SQL) for an example document that uses this data. - Display Product List
- Displaying Data Imported from a Spreadsheet
- Download or view.
- Iterating Through Data
- Download or view.
- List of Names
- Download or view.
- Fetching Data From Row 1
- Fetching a Customer's Details
- Download or view.
- Fetching a Customer's Details With Expansion
- Displaying Customer List (Null Values)
- Download or view.
- A Simple Letter (letter.cls).
- Download or view.
- A Simple Letter (scrlttr2).
- Download or view.
- Writing a letter: KOMA Settings.
- Download or view.
- A Simple Letter (newlfm).
- Download or view.
- A Simple Letter (isodoc).
- Download or view.
- Mail Merging (newlfm.cls).
- Download or view.
- Envelope Labels.
- Download or view.
- Mail merging with letter.cls and envlab.sty.
- Download or view.
- Mail merging with newlfm.cls, envlab.sty and datatool.sty.
- Download or view.
- An Invoice (isodoc.cls).
- Download or view.
- An Invoice (invoice.sty).
- Download or view.
- Multi-Paged Tabulated Material.
- Download or view.
- A Sample CV (currvita.sty).
- Download or view.
- Personal Information Section (europecv.cls).
- Download or view.
- Curriculum Vitae With Sections (europecv.cls).
- Download or view.
- Tabulating a Bibliography.
- Download or view.
- List of Publications (europecv.cls).
- Download or view.
- Sample Memo.
- Download or view.
- Sample Press Release.
- Download or view.
- Sample Minutes.
- Download or view.
- Redaction.
- Download main file and definitions file or view both.
- Watermarks (background.sty)
- Download or view.
- Watermarks (xwatermark.sty)
- Download or view.
- Nested Enumeration
- Download or view.
- Displaying Dates and Times (datetime2.sty)
- Download or view.
- Calculating Ages
- Download or view.
- Custom Date Formatting (pgfcalendar.sty)
- Download or view.
- Custom Date Package
- Download or view.
- Custom Date and Time Package
- Download or view.
- Calendar for May 2014
- Download or view.
- Presentation Themes (Boadilla)
- Download or view.
- Using both exam.cls and probsoln.sty
- Download or view.
- Randomly Selecting Problems
- Download or view. This example also requires mth101.tex and problems-1stprinciples.tex.
- Creating a Problem Sheet using datatool.sty
- Download or view. This example also requires mth101.dbtex.
- Randomly Selecting Problems Not Used in the Past Two Years
- Download or view. This example also requires mth101.dbtex. If you use make there's also a Makefile.
- Random selection with pgfmath.sty and probsoln.sty
- Download or view.
- A Postcard
- Download or view.
- Name Labels (ticket.sty)
- This example requires the dummy-logo.png image. Download or view.
- Leaflet
- This example requires the sample images dummy-logo.png, mallard.png and goose.png. Download or view.
- Leaflet (with tikz.sty)
- This example requires the sample images dummy-logo.png, mallard.png and goose.png. Download or view.
- ISBN Bar Code
- Download or view.
- Advance Information Sheet
- This example requires the sample images dummy-logo.png and chicken.png as well as the barcode-qr.pdf file created in Exercise 28. Download or view.
- Advance Information Sheet (with flowframtk)
- This example requires the sample images dummy-logo.png and chicken.png as well as the barcode-qr.pdf file created in Exercise 28. View or download aisheet.ajr, aisheet.cls and aisheet-sample.tex.
- A Simple Form Class
- View or download simple-form-example.tex and simple-form.cls.
- A Simple Form Class (Gathering Environment Contents)
- View or download sample-project-form.tex and sample-form.cls.
- A Simple Electronic Form
- View or download sample-pdf-form.tex.
- Flow Chart
- View or download flowchart-sample.tex.
- Pie Chart (datapie.sty)
- (This example requires booklist.csv.) View or download datapie-sample.tex.
- Pie Chart (pgf-pie.sty)
- View or download pgf-pie-sample.tex.
- Bar Chart (databar.sty)
- (This example requires booklist.csv.) View or download databar-sample.tex.
- Gantt Chart
- View or download gantt-sample.tex.
- A Sample Plot (pgfplots.sty)
- View or download pgfplots-sample.tex.
- Recording Changes (changes.sty)
- View or download changes-sample.tex.
- Accessing Subversion Revision Information
- View or download svninfo-sample.tex.
