|
Exporting to Microsoft Excel |
  
|
|
Exporting to Microsoft Excel |
|
Untis allows you to export all timetables and reports to MS Excel.
Exporting timetables
Proceed as follows:
| • | Right-click on the timetable and select "Copy in HTML format" |
This copies the HTML commands required to display the timetable into the clipboard
<!DOCTYPE HTML PUBLIC '-//IETF//DTD HTML//EN'>
<html>
<head>
<meta http-equiv='Content-Type' content='text/html; charset=iso-8859-1'><meta http-equiv='expires' content='0'><meta name='keywords' content='Stundenplan, timetable'>
<meta name='GENERATOR' content='Untis 2012'>
<title>Untis 2012 Timetable 2012/2013 TestSchool DEMO 2</title>
<style type='text/css'>
a {color:#000000;}
</style>
</head>
<body class=tt>
<CENTER><font size='3' face='Arial' color='#000000'>
<TABLE border='0' cellpadding='1' ><TR><TD rowspan='2' width='5'></TD><TD> TestSchool DEMO </TD><TD rowspan='2' width='5'></TD><TD>Timetable 2012/2013</TD><TD rowspan='2' width='5'></TD><TD align='right'> Untis 2012 </TD><TD rowspan='2' width='5'> </TD></TR><TR><TD>For demo and test</TD><TD>Valid from: 10 October</TD> <TD align='right'>8.4.2011 9:27 </TD></TR></TABLE><BR></font>
<font size='6' face='Arial' color='#0000FF'>
1a
</font> <font size='4' face='Arial'>
Class 1a (Gauss)
</font>
(etc.)
| • | Switch to MS Excel and select menu item "Edit | Paste" (or CTRL+V). |
Please note that different versions of Excel interpret HTML code in different ways. The timetables generally require subsequent manual reformatting in Excel in order to improve their visual appearance.