Per VBA Arbeitsblätter leeren
Hier ein wenig VBA, um Excel-Blätter zu leeren:
Sub clearthisSheet() With Sheets("Tabelle1") .Cells.Clear End With |
Textsatz mit \LaTeX, Programmieren, Zahlen, etc.
Author Archive
Hier ein wenig VBA, um Excel-Blätter zu leeren:
Sub clearthisSheet() With Sheets("Tabelle1") .Cells.Clear End With |
Ein kurzer Nachtrag zu meinem „Kalender mit TikZ“-Beispiel. Von Rolf Niepraschk gibt es das „tikz-kalender“ Paket (https://ctan.org/pkg/tikz-kalender), das die notwendige Funktionalität bereitstellt.
Schauen wir uns ein einfaches Beispiel an:
tikz-kalender
genutzt\setup
-Befehl gibt man die verschiedenen Variablen in Key-Value Notation an\makeKalender
\documentclass{tikz-kalender} \usepackage[utf8]{inputenc} \usepackage[T1]{fontenc} \setup{year=2018,title={Termine}} \begin{document} \makeKalender \end{document} |
Hier ein zusammengefrickeltes Beispiel für einen TikZ-basierten Jahreskalender. „Zusammengefrickelt“ deshalb, weil es bestimmt über die TikZ- und pgf-Kalenderfunktionen viel einfacher und eleganter geht. Letzlich tut es aber 😉
Kalender_2018 (auch wenn das PDF im Namen „2017“ trägt)
\documentclass[fontsize=6pt]{scrartcl} \usepackage[a4paper,landscape,left=0.5cm,right=0.5cm,top=0.5cm,bottom=0.5cm]{geometry} \usepackage[]{ifdraft} \usepackage[]{attachfile} \usepackage[]{eso-pic} \usepackage[english]{babel} \usepackage[T1]{fontenc} \usepackage[utf8]{inputenc} \renewcommand{\familydefault}{\sfdefault} \RequirePackage[scaled=0.9]{helvet} \usepackage{tikz} \usepackage[right]{showlabels} \usetikzlibrary{positioning} \pagestyle{empty} \usepackage{xcolor} \usepackage{hyperref} \usepackage{url} \definecolor{weekendday}{RGB}{220,220,220} \newcommand{\file}[1]{\textattachfile{#1}{\textcolor{blue}{\LaTeX\ Sourcecode}}} \begin{document} \AddToShipoutPictureFG*{ \put(35,10){\footnotesize Uwe Ziegenhagen, ziegenhagen@gmail.com, \file{\jobname.tex} } } \begin{center} \begin{tikzpicture} [ x=23mm,y=6mm, mybox/.style={rectangle,rounded corners,minimum width=23mm, minimum height=6mm}, month/.style={mybox,align=center,draw=black,fill=yellow,thick,font=\bfseries\Large}, date/.style={mybox,draw=gray,fill=yellow,align=left,thick,minimum width=5mm,font=\bfseries\Large}, day/.style={mybox,draw=black,align=left}, weekendday/.style={mybox,draw=black,align=left,fill=weekendday} ] \node at (0,0) [month] {Januar}; \node at (1,0) [month] {Februar}; \node at (2,0) [month] {März}; \node at (3,0) [month] {April}; \node at (4,0) [month] {Mai}; \node at (5,0) [month] {Juni}; \node at (6,0) [month] {Juli}; \node at (7,0) [month] {August}; \node at (8,0) [month] {September}; \node at (9,0) [month] {Oktober}; \node at (10,0) [month] {November}; \node at (11,0) [month] {Dezember}; \node at (-0.6,-1) [date] {01}; \node at (-0.6,-2) [date] {02}; \node at (-0.6,-3) [date] {03}; \node at (-0.6,-4) [date] {04}; \node at (-0.6,-5) [date] {05}; \node at (-0.6,-6) [date] {06}; \node at (-0.6,-7) [date] {07}; \node at (-0.6,-8) [date] {08}; \node at (-0.6,-9) [date] {09}; \node at (-0.6,-10) [date] {10}; \node at (-0.6,-11) [date] {11}; \node at (-0.6,-12) [date] {12}; \node at (-0.6,-13) [date] {13}; \node at (-0.6,-14) [date] {14}; \node at (-0.6,-15) [date] {15}; \node at (-0.6,-16) [date] {16}; \node at (-0.6,-17) [date] {17}; \node at (-0.6,-18) [date] {18}; \node at (-0.6,-19) [date] {19}; \node at (-0.6,-20) [date] {20}; \node at (-0.6,-21) [date] {21}; \node at (-0.6,-22) [date] {22}; \node at (-0.6,-23) [date] {23}; \node at (-0.6,-24) [date] {24}; \node at (-0.6,-25) [date] {25}; \node at (-0.6,-26) [date] {26}; \node at (-0.6,-27) [date] {27}; \node at (-0.6,-28) [date] {28}; \node at (-0.6,-29) [date] {29}; \node at (-0.6,-30) [date] {30}; \node at (-0.6,-31) [date] {31}; \node at (0,-1) [day] {}; \node at (0,-2) [day] {}; \node at (0,-3) [day] {}; \node at (0,-4) [day] {}; \node at (0,-5) [day] {}; \node at (0,-6) [weekendday] {}; \node at (0,-7) [weekendday] {}; \node at (0,-8) [day] {}; \node at (0,-9) [day] {}; \node at (0,-10) [day] {}; \node at (0,-11) [day] {}; \node at (0,-12) [day] {}; \node at (0,-13) [weekendday] {}; \node at (0,-14) [weekendday] {}; \node at (0,-15) [day] {}; \node at (0,-16) [day] {}; \node at (0,-17) [day] {}; \node at (0,-18) [day] {}; \node at (0,-19) [day] {}; \node at (0,-20) [weekendday] {}; \node at (0,-21) [weekendday] {}; \node at (0,-22) [day] {}; \node at (0,-23) [day] {}; \node at (0,-24) [day] {}; \node at (0,-25) [day] {}; \node at (0,-26) [day] {}; \node at (0,-27) [weekendday] {}; \node at (0,-28) [weekendday] {}; \node at (0,-29) [day] {}; \node at (0,-30) [day] {}; \node at (0,-31) [day] {}; \node at (1,-1) [day] {}; \node at (1,-2) [day] {}; \node at (1,-3) [weekendday] {}; \node at (1,-4) [weekendday] {}; \node at (1,-5) [day] {}; \node at (1,-6) [day] {}; \node at (1,-7) [day] {}; \node at (1,-8) [day] {}; \node at (1,-9) [day] {}; \node at (1,-10) [weekendday] {}; \node at (1,-11) [weekendday] {}; \node at (1,-12) [day] {}; \node at (1,-13) [day] {}; \node at (1,-14) [day] {}; \node at (1,-15) [day] {}; \node at (1,-16) [day] {}; \node at (1,-17) [weekendday] {}; \node at (1,-18) [weekendday] {}; \node at (1,-19) [day] {}; \node at (1,-20) [day] {}; \node at (1,-21) [day] {}; \node at (1,-22) [day] {}; \node at (1,-23) [day] {}; \node at (1,-24) [weekendday] {}; \node at (1,-25) [weekendday] {}; \node at (1,-26) [day] {}; \node at (1,-27) [day] {}; \node at (1,-28) [day] {}; \node at (2,-1) [day] {}; \node at (2,-2) [day] {}; \node at (2,-3) [weekendday] {}; \node at (2,-4) [weekendday] {}; \node at (2,-5) [day] {}; \node at (2,-6) [day] {}; \node at (2,-7) [day] {}; \node at (2,-8) [day] {}; \node at (2,-9) [day] {}; \node at (2,-10) [weekendday] {}; \node at (2,-11) [weekendday] {}; \node at (2,-12) [day] {}; \node at (2,-13) [day] {}; \node at (2,-14) [day] {}; \node at (2,-15) [day] {}; \node at (2,-16) [day] {}; \node at (2,-17) [weekendday] {}; \node at (2,-18) [weekendday] {}; \node at (2,-19) [day] {}; \node at (2,-20) [day] {}; \node at (2,-21) [day] {}; \node at (2,-22) [day] {}; \node at (2,-23) [day] {}; \node at (2,-24) [weekendday] {}; \node at (2,-25) [weekendday] {}; \node at (2,-26) [day] {}; \node at (2,-27) [day] {}; \node at (2,-28) [day] {}; \node at (2,-29) [day] {}; \node at (2,-30) [day] {}; \node at (2,-31) [weekendday] {}; \node at (3,-1) [weekendday] {}; \node at (3,-2) [day] {}; \node at (3,-3) [day] {}; \node at (3,-4) [day] {}; \node at (3,-5) [day] {}; \node at (3,-6) [day] {}; \node at (3,-7) [weekendday] {}; \node at (3,-8) [weekendday] {}; \node at (3,-9) [day] {}; \node at (3,-10) [day] {}; \node at (3,-11) [day] {}; \node at (3,-12) [day] {}; \node at (3,-13) [day] {}; \node at (3,-14) [weekendday] {}; \node at (3,-15) [weekendday] {}; \node at (3,-16) [day] {}; \node at (3,-17) [day] {}; \node at (3,-18) [day] {}; \node at (3,-19) [day] {}; \node at (3,-20) [day] {}; \node at (3,-21) [weekendday] {}; \node at (3,-22) [weekendday] {}; \node at (3,-23) [day] {}; \node at (3,-24) [day] {}; \node at (3,-25) [day] {}; \node at (3,-26) [day] {}; \node at (3,-27) [day] {}; \node at (3,-28) [weekendday] {}; \node at (3,-29) [weekendday] {}; \node at (3,-30) [day] {}; \node at (4,-1) [day] {}; \node at (4,-2) [day] {}; \node at (4,-3) [day] {}; \node at (4,-4) [day] {}; \node at (4,-5) [weekendday] {}; \node at (4,-6) [weekendday] {}; \node at (4,-7) [day] {}; \node at (4,-8) [day] {}; \node at (4,-9) [day] {}; \node at (4,-10) [day] {}; \node at (4,-11) [day] {}; \node at (4,-12) [weekendday] {}; \node at (4,-13) [weekendday] {}; \node at (4,-14) [day] {}; \node at (4,-15) [day] {}; \node at (4,-16) [day] {}; \node at (4,-17) [day] {}; \node at (4,-18) [day] {}; \node at (4,-19) [weekendday] {}; \node at (4,-20) [weekendday] {}; \node at (4,-21) [day] {}; \node at (4,-22) [day] {}; \node at (4,-23) [day] {}; \node at (4,-24) [day] {}; \node at (4,-25) [day] {}; \node at (4,-26) [weekendday] {}; \node at (4,-27) [weekendday] {}; \node at (4,-28) [day] {}; \node at (4,-29) [day] {}; \node at (4,-30) [day] {}; \node at (4,-31) [day] {}; \node at (5,-1) [day] {}; \node at (5,-2) [weekendday] {}; \node at (5,-3) [weekendday] {}; \node at (5,-4) [day] {}; \node at (5,-5) [day] {}; \node at (5,-6) [day] {}; \node at (5,-7) [day] {}; \node at (5,-8) [day] {}; \node at (5,-9) [weekendday] {}; \node at (5,-10) [weekendday] {}; \node at (5,-11) [day] {}; \node at (5,-12) [day] {}; \node at (5,-13) [day] {}; \node at (5,-14) [day] {}; \node at (5,-15) [day] {}; \node at (5,-16) [weekendday] {}; \node at (5,-17) [weekendday] {}; \node at (5,-18) [day] {}; \node at (5,-19) [day] {}; \node at (5,-20) [day] {}; \node at (5,-21) [day] {}; \node at (5,-22) [day] {}; \node at (5,-23) [weekendday] {}; \node at (5,-24) [weekendday] {}; \node at (5,-25) [day] {}; \node at (5,-26) [day] {}; \node at (5,-27) [day] {}; \node at (5,-28) [day] {}; \node at (5,-29) [day] {}; \node at (5,-30) [weekendday] {}; \node at (6,-1) [weekendday] {}; \node at (6,-2) [day] {}; \node at (6,-3) [day] {}; \node at (6,-4) [day] {}; \node at (6,-5) [day] {}; \node at (6,-6) [day] {}; \node at (6,-7) [weekendday] {}; \node at (6,-8) [weekendday] {}; \node at (6,-9) [day] {}; \node at (6,-10) [day] {}; \node at (6,-11) [day] {}; \node at (6,-12) [day] {}; \node at (6,-13) [day] {}; \node at (6,-14) [weekendday] {}; \node at (6,-15) [weekendday] {}; \node at (6,-16) [day] {}; \node at (6,-17) [day] {}; \node at (6,-18) [day] {}; \node at (6,-19) [day] {}; \node at (6,-20) [day] {}; \node at (6,-21) [weekendday] {}; \node at (6,-22) [weekendday] {}; \node at (6,-23) [day] {}; \node at (6,-24) [day] {}; \node at (6,-25) [day] {}; \node at (6,-26) [day] {}; \node at (6,-27) [day] {}; \node at (6,-28) [weekendday] {}; \node at (6,-29) [weekendday] {}; \node at (6,-30) [day] {}; \node at (6,-31) [day] {}; \node at (7,-1) [day] {}; \node at (7,-2) [day] {}; \node at (7,-3) [day] {}; \node at (7,-4) [weekendday] {}; \node at (7,-5) [weekendday] {}; \node at (7,-6) [day] {}; \node at (7,-7) [day] {}; \node at (7,-8) [day] {}; \node at (7,-9) [day] {}; \node at (7,-10) [day] {}; \node at (7,-11) [weekendday] {}; \node at (7,-12) [weekendday] {}; \node at (7,-13) [day] {}; \node at (7,-14) [day] {}; \node at (7,-15) [day] {}; \node at (7,-16) [day] {}; \node at (7,-17) [day] {}; \node at (7,-18) [weekendday] {}; \node at (7,-19) [weekendday] {}; \node at (7,-20) [day] {}; \node at (7,-21) [day] {}; \node at (7,-22) [day] {}; \node at (7,-23) [day] {}; \node at (7,-24) [day] {}; \node at (7,-25) [weekendday] {}; \node at (7,-26) [weekendday] {}; \node at (7,-27) [day] {}; \node at (7,-28) [day] {}; \node at (7,-29) [day] {}; \node at (7,-30) [day] {}; \node at (8,-1) [day] {}; \node at (8,-2) [weekendday] {}; \node at (8,-3) [weekendday] {}; \node at (8,-4) [day] {}; \node at (8,-5) [day] {}; \node at (8,-6) [day] {}; \node at (8,-7) [day] {}; \node at (8,-8) [day] {}; \node at (8,-9) [weekendday] {}; \node at (8,-10) [weekendday] {}; \node at (8,-11) [day] {}; \node at (8,-12) [day] {}; \node at (8,-13) [day] {}; \node at (8,-14) [day] {}; \node at (8,-15) [day] {}; \node at (8,-16) [weekendday] {}; \node at (8,-17) [weekendday] {}; \node at (8,-18) [day] {}; \node at (8,-19) [day] {}; \node at (8,-20) [day] {}; \node at (8,-21) [day] {}; \node at (8,-22) [day] {}; \node at (8,-23) [weekendday] {}; \node at (8,-24) [weekendday] {}; \node at (8,-25) [day] {}; \node at (8,-26) [day] {}; \node at (8,-27) [day] {}; \node at (8,-28) [day] {}; \node at (8,-29) [day] {}; \node at (8,-30) [weekendday] {}; \node at (8,-31) [weekendday] {}; \node at (9,-1) [day] {}; \node at (9,-2) [day] {}; \node at (9,-3) [day] {}; \node at (9,-4) [day] {}; \node at (9,-5) [day] {}; \node at (9,-6) [weekendday] {}; \node at (9,-7) [weekendday] {}; \node at (9,-8) [day] {}; \node at (9,-9) [day] {}; \node at (9,-10) [day] {}; \node at (9,-11) [day] {}; \node at (9,-12) [day] {}; \node at (9,-13) [weekendday] {}; \node at (9,-14) [weekendday] {}; \node at (9,-15) [day] {}; \node at (9,-16) [day] {}; \node at (9,-17) [day] {}; \node at (9,-18) [day] {}; \node at (9,-19) [day] {}; \node at (9,-20) [weekendday] {}; \node at (9,-21) [weekendday] {}; \node at (9,-22) [day] {}; \node at (9,-23) [day] {}; \node at (9,-24) [day] {}; \node at (9,-25) [day] {}; \node at (9,-26) [day] {}; \node at (9,-27) [weekendday] {}; \node at (9,-28) [weekendday] {}; \node at (9,-29) [day] {}; \node at (9,-30) [day] {}; \node at (9,-31) [day] {}; \node at (10,-1) [day] {}; \node at (10,-2) [day] {}; \node at (10,-3) [weekendday] {}; \node at (10,-4) [weekendday] {}; \node at (10,-5) [day] {}; \node at (10,-6) [day] {}; \node at (10,-7) [day] {}; \node at (10,-8) [day] {}; \node at (10,-9) [day] {}; \node at (10,-10) [weekendday] {}; \node at (10,-11) [weekendday] {}; \node at (10,-12) [day] {}; \node at (10,-13) [day] {}; \node at (10,-14) [day] {}; \node at (10,-15) [day] {}; \node at (10,-16) [day] {}; \node at (10,-17) [weekendday] {}; \node at (10,-18) [weekendday] {}; \node at (10,-19) [day] {}; \node at (10,-20) [day] {}; \node at (10,-21) [day] {}; \node at (10,-22) [day] {}; \node at (10,-23) [day] {}; \node at (10,-24) [weekendday] {}; \node at (10,-25) [weekendday] {}; \node at (10,-26) [day] {}; \node at (10,-27) [day] {}; \node at (10,-28) [day] {}; \node at (10,-29) [day] {}; \node at (10,-30) [day] {}; \node at (11,-1) [weekendday] {}; \node at (11,-2) [weekendday] {}; \node at (11,-3) [day] {}; \node at (11,-4) [day] {}; \node at (11,-5) [day] {}; \node at (11,-6) [day] {}; \node at (11,-7) [day] {}; \node at (11,-8) [weekendday] {}; \node at (11,-9) [weekendday] {}; \node at (11,-10) [day] {}; \node at (11,-11) [day] {}; \node at (11,-12) [day] {}; \node at (11,-13) [day] {}; \node at (11,-14) [day] {}; \node at (11,-15) [weekendday] {}; \node at (11,-16) [weekendday] {}; \node at (11,-17) [day] {}; \node at (11,-18) [day] {}; \node at (11,-19) [day] {}; \node at (11,-20) [day] {}; \node at (11,-21) [day] {}; \node at (11,-22) [weekendday] {}; \node at (11,-23) [weekendday] {}; \node at (11,-24) [day] {}; \node at (11,-25) [day] {}; \node at (11,-26) [day] {}; \node at (11,-27) [day] {}; \node at (11,-28) [day] {}; \node at (11,-29) [weekendday] {}; \node at (11,-30) [weekendday] {}; \node at (11,-31) [day] {}; \end{tikzpicture} \end{center} \end{document} |
Hier ein Beispiel für Diagramme mit TikZ:
\documentclass[12pt,ngerman]{scrartcl} \usepackage[utf8]{inputenc} \usepackage[T1]{fontenc} \usepackage{babel} \usepackage{tikz} \begin{document} \begin{tikzpicture} [ mybox/.style={rectangle,rounded corners,xshift=1cm,yshift=1cm,minimum width=20mm, minimum height=5mm}, lang/.style={mybox,black,align=center,draw=black,fill=yellow,very thick,font=\bfseries}, ] \node at (5,-1) {\bfseries\large imperativ/prozedural}; \node at (13,-1) {\bfseries\large objektorientiert}; \node at (1,12) {\textbf{1950}}; \node at (1,10) {\textbf{1960}}; \node at (1,8) {\textbf{1970}}; \node at (1,6) {\textbf{1980}}; \node at (1,4) {\textbf{1990}}; \node at (1,2) {\textbf{2000}}; \node at (1,0) {\textbf{2010}}; \draw (2,0) -- (15,0); \draw (2,2) -- (15,2); \draw (2,4) -- (15,4); \draw (2,6) -- (15,6); \draw (2,8) -- (15,8); \draw (2,10) -- (15,10); \draw (2,12) -- (15,12); \node at (10,2.5) [lang] {Python}; \node at (4,10.5) [lang] {Fortran}; \end{tikzpicture} \end{document} |
Datumswerte der Form (d)dmmjjjj
, also beispielsweise 1122017 für den 1.12.2017 lassen sich leicht durch die folgende Excel-Funktion in etwas brauchbares verwandeln:
=WERT(WECHSELN(B4;LINKS(RECHTS(B4;6);2)&RECHTS(B4;4);"")&"."&LINKS(RECHTS(B4;6);2)&"."&RECHTS(B4;4)) |
Annahme: Der „schlechte“ Datumsstring steht in Zelle B4. Das erzeugte Ergebnis muss man dann über die Formatierung auf Datum ändern.
Hier zur Erläuterung:
Beispiel-Excel:
DatumUmwandeln
Die finale Formel, die oben angegeben ist, fügt die einzelnen Teile nur zusammen.
Ich muss mich gelegentlich mit MS Access beschäftigen und habe eine Möglichkeit gesucht, Tabellenstrukturen zu exportieren. Basierend auf Code von Allen Browne (http://allenbrowne.com/func-06.html) habe ich um seine TableInfo()
Funktion eine Exportfunktion geschrieben.
Option Compare Database ' based on http://allenbrowne.com/func-06.html ' modified for the export of the information by Uwe Ziegenhagen Sub exportTableInformation() On Error GoTo TableInfoErr ' Purpose: Display the field names, types, sizes and descriptions for a table. ' Argument: Name of a table in the current database. Dim db As DAO.Database Dim tdf As DAO.TableDef Dim fld As DAO.Field Set db = CurrentDb() ' ask user for path of the output file ' https://support.office.com/de-de/article/InputBox-Funktion-Eingabefeld-17821927-28b7-4350-b7f1-4786575314d9 Dim Message, Title, Default, MyValue Message = "File will be overwritten..." ' Set prompt. Title = "Enter file of output file" ' Set title. Default = "c:\somefile.csv" ' Set default. ' Display message, title, and default value. outputfilePath = InputBox(Message, Title, Default) n = FreeFile() Open outputfilePath For Output As #n Print #n, "SOURCE;TABLE;FIELDNAME;FIELDTYPE;SIZE;DESCRIPTION" Set db = CurrentDb() Debug.Print For Each tdf In db.TableDefs ' ignore system and temporary tables If Not (tdf.Name Like "MSys*" Or tdf.Name Like "~*") Then For Each fld In tdf.Fields Debug.Print db.Name & ";" & tdf.Name & ";" & fld.Name & ";" & FieldTypeName(fld) & ";" & fld.Size & ";" & GetDescrip(fld) Print #n, db.Name & ";" & tdf.Name & ";" & fld.Name & ";" & FieldTypeName(fld) & ";" & fld.Size & ";" & GetDescrip(fld) Next End If Next Set tdf = Nothing Set db = Nothing Close #n TableInfoExit: Set db = Nothing Exit Sub TableInfoErr: Select Case Err Case 3265& 'Table name invalid MsgBox strTableName & " table doesn't exist" Case Else Debug.Print "TableInfo() Error " & Err & ": " & Error End Select Resume TableInfoExit End Sub Function GetDescrip(obj As Object) As String ' http://allenbrowne.com/func-06.html On Error Resume Next GetDescrip = obj.Properties("Description") End Function Function FieldTypeName(fld As DAO.Field) As String 'http://allenbrowne.com/func-06.html 'Purpose: Converts the numeric results of DAO Field.Type to text. Dim strReturn As String 'Name to return Select Case CLng(fld.Type) 'fld.Type is Integer, but constants are Long. Case dbBoolean: strReturn = "Yes/No" ' 1 Case dbByte: strReturn = "Byte" ' 2 Case dbInteger: strReturn = "Integer" ' 3 Case dbLong ' 4 If (fld.Attributes And dbAutoIncrField) = 0& Then strReturn = "Long Integer" Else strReturn = "AutoNumber" End If Case dbCurrency: strReturn = "Currency" ' 5 Case dbSingle: strReturn = "Single" ' 6 Case dbDouble: strReturn = "Double" ' 7 Case dbDate: strReturn = "Date/Time" ' 8 Case dbBinary: strReturn = "Binary" ' 9 (no interface) Case dbText '10 If (fld.Attributes And dbFixedField) = 0& Then strReturn = "Text" Else strReturn = "Text (fixed width)" '(no interface) End If Case dbLongBinary: strReturn = "OLE Object" '11 Case dbMemo '12 If (fld.Attributes And dbHyperlinkField) = 0& Then strReturn = "Memo" Else strReturn = "Hyperlink" End If Case dbGUID: strReturn = "GUID" '15 'Attached tables only: cannot create these in JET. Case dbBigInt: strReturn = "Big Integer" '16 Case dbVarBinary: strReturn = "VarBinary" '17 Case dbChar: strReturn = "Char" '18 Case dbNumeric: strReturn = "Numeric" '19 Case dbDecimal: strReturn = "Decimal" '20 Case dbFloat: strReturn = "Float" '21 Case dbTime: strReturn = "Time" '22 Case dbTimeStamp: strReturn = "Time Stamp" '23 'Constants for complex types don't work prior to Access 2007 and later. Case 101&: strReturn = "Attachment" 'dbAttachment Case 102&: strReturn = "Complex Byte" 'dbComplexByte Case 103&: strReturn = "Complex Integer" 'dbComplexInteger Case 104&: strReturn = "Complex Long" 'dbComplexLong Case 105&: strReturn = "Complex Single" 'dbComplexSingle Case 106&: strReturn = "Complex Double" 'dbComplexDouble Case 107&: strReturn = "Complex GUID" 'dbComplexGUID Case 108&: strReturn = "Complex Decimal" 'dbComplexDecimal Case 109&: strReturn = "Complex Text" 'dbComplexText Case Else: strReturn = "Field type " & fld.Type & " unknown" End Select FieldTypeName = strReturn End Function |
Hier ein Beispiel aus der Dokumentation des pixelart
Pakets von Louis Paternault
\documentclass[12pt]{scrartcl} \usepackage[utf8]{inputenc} \usepackage{pixelart} \begin{document} I \bwpixelart[color=red, scale=.05, raise=-0.3ex]{% 001101100 011111110 111111111 111111111 111111111 011111110 001111100 000111000 000010000 } \LaTeX \end{document} |
pdflatex packt einiges an Meta-Daten in eine PDF-Datei:
Mit dem pdfprivacy (http://mirror.ctan.org/macros/latex/contrib/pdfprivacy) Paket von Laurens Sion lassen sich diese Informationen unterdrücken.
Aus der Dokumentation:
„Creating pdfs with pdfLATEX populates several pdf meta-data fields such as date/time of creation/modification, information about the latex instal-
lation (e.g., pdfTEX version), and the relative paths of included pdfs. The pdfprivacy package provides support for emptying several of these pdf meta-
data fields as well as suppressing some pdfTEX meta-data entries in the resulting pdf.“
Die Optionen stehen dabei für:
Diese letzte Option zur pdftrailerid
sagt mir nichts, die anderen Optionen sind sicherlich selbsterklärend. Hier ein Beispiel:
\documentclass[12pt,ngerman]{scrartcl} \usepackage[utf8]{inputenc} \usepackage[T1]{fontenc} \usepackage{booktabs} \usepackage{babel} \usepackage{graphicx} \usepackage{csquotes} \usepackage{paralist} \usepackage{xcolor} \usepackage[nodocdata=false,noeditdata=true,noproducerdata=true,noptexdata=true,nopdftrailerid=false]{pdfprivacy} \begin{document} Hallo Welt! \end{document} |
Ich habe am 02.12.2017 die CFA Level 1 Prüfung in Frankfurt/Main geschrieben und möchte kurz die Fragen beantworten, die ich selbst im Vorfeld der Prüfung zum Ablauf hatte:
Hier ein Beispiel, wie man mit varioref
und prettyref
Referenzen in LaTeX aufpeppen kann:
\documentclass[ngerman]{scrartcl} \usepackage[latin1]{inputenc} \usepackage[T1]{fontenc} \usepackage{babel} \usepackage{xcolor} % sinnloser Text \usepackage{blindtext} \usepackage{varioref} \usepackage{prettyref} % for prettyref \newrefformat{eq}{\textup{(\ref{#1})}} \newrefformat{cha}{Kapitel \ref{#1}} \newrefformat{sec}{Abschnitt \ref{#1}} \newrefformat{tab}{Tabelle \ref{#1} auf Seite \pageref{#1}} \newrefformat{fig}{Abbildung \ref{#1} auf Seite \pageref{#1}} \usepackage{showlabels} \begin{document} \section{Erster Abschnitt}\label{sec:erst} \blindtext[3] \begin{figure}[h]% \rule{\columnwidth}{5cm} \caption{Hallo Welt!}% \label{fig:test1}% \end{figure} \blindtext[1] \section{Zweiter Abschnitt} \blindtext[5] \begin{figure}% \rule{\columnwidth}{5cm} \caption{Hallo Welt!}% \label{fig:test2}% \end{figure} \blindtext[4] \begin{itemize} \item Ohne Paket: Siehe Abbildung \textcolor{red}{\ref{fig:test1}} auf Seite \textcolor{red}{\pageref{fig:test1}} \item Varioref: Siehe Abbildung \textcolor{red}{\vref{fig:test1}} \item Varioref: Siehe die Abbildung \textcolor{red}{\vpageref{fig:test1}} \item Ohne Paket: Siehe Abbildung \textcolor{red}{\ref{fig:test2}} auf Seite \textcolor{red}{\pageref{fig:test2}} \item Varioref: Siehe Abbildung \textcolor{red}{\vpageref{fig:test2}} \item Varioref: Siehe Abbildung \textcolor{red}{\vref{fig:test2}} \item Varioref: Siehe Abbildungen \textcolor{red}{\vrefrange{fig:test1}{fig:test2}} \item Varioref: Siehe die Abbildungen \textcolor{red}{\vpagerefrange{fig:test1}{fig:test2}} \item Prettyref: \textcolor{red}{\prettyref{fig:test1}} \item Prettyref: \textcolor{red}{\prettyref{sec:erst}} \item Varioref: Siehe Abbildung \textcolor{red}{\vref{fig:test3}} \item Varioref: Siehe Abbildung \textcolor{red}{\vref{fig:test4}} \end{itemize} \clearpage \begin{figure}% \rule{\columnwidth}{5cm} \caption{Hallo Welt!}% \label{fig:test3}% \end{figure} \clearpage \begin{figure}% \rule{\columnwidth}{5cm} \caption{Hallo Welt!}% \label{fig:test4}% \end{figure} \end{document} |
Hier die Ausgabe der Referenzen auf der letzten Seite. Alles, was in rot gesetzt wird, wird so über das entsprechende TeX gesteuert.