Excel and LibreOffice file

[Volker Dirr]

Some guys want to modify timetables with Excel or LibreOffice. (Even i suggest to learn a bit HTML/css and modify the css file)
So they ask for an excel, LibreOffice file, or alternative CSV files.
That is NOT needed (and difficult to code).
Excel and LibreOffice can import HTML files!

Now some guys complain that those tables doesn't look fine (since the Excel import filter isn't perfect and just import some basic stuff). But don't worry, that is easy to fix! You only need to do it ONE time.

You just need to know ,,macros". So you can always get your needed style back with a single mouse click if you import later other generated timetables.

Excel users: Please read an excel manual about ,,macro".

LibreOffice users: here is a short manual:

1. You maybe need to turn on macro recodring: LibreOffice → Tools → Options → Advanced → Enable macro recording
2. Open the FET HTML file with LibreOffice → File → Open
3. If the table of contents and or the comments are not always the same  number of rows: I suggest to remove that rows before recording start. You will see soon why. You can save that work later automatically just by adding a few lines into the macro manually if you learn a bit BASIC.
4. Start recoding: LibreOffice → Tools → Macro → Record Macro
5. Now style the table like you want: remove rows/columns, Change font, change color, change boarders, ...
(You might need to remove spans if you want to delete rows/columns. To delete that just select the table and click on LibreOffice → Format → Merge Cells → Merge and Center Cells)
6. Stop recording the macro and save it (Press the ,,End Recording" Button)

Ready! That was all. Now you can always get you timetable style:
If you open an other generated timetable only import the HTML file and click on LibreOffice → Tools → Macro → Run Macro (You will be even faster if you place an icon for this into the menu :-)

So as you can see: Just a single mouse click to get your personal perfect styled timetable in Excel or LibreOffice.