I've been using an own class with some commands for writing exams in my classes (I'm a teacher). In this, I use a rather complex point system (why I do this is kind of irrelevant) with 9 different kind of points. In order to show the students what kind of points they earned on a particular question, I've been using newfile
to create a .xml
file showing the question number and what kind of point that can be earned on that particular question, as shown in the picture (when opened in Excel)
When I enter the questions I put some point commands to that question (9 different) which each add a row to the .xml
file. The class uses a load of counters and commands, and lots of text to produce the beginning and ending of the .xml
file.
I've come to the conclusion that I really need a barchart, showing the points earned and not earned, but .xml
in Excel wont give me any (well, it does but it can not be saved so I can't harvest the code by opening the file in a text editor).
So, this might be more Excel related than LaTeX, but since I use LaTeX to produce the file in question, I thought I could ask it here: Is there a way (or package) to create Excel files via LaTeX, that can add charts (in some way)? Or is there a better way than using newfile
and .xml
? Perhaps a different file format is needed?
gnumeric
, a free light-weight spreadsheet. It is capable of saving charts in gzippedxml
format with simpler structure, thanxlsx
. And it can read/write files inexcel
andLaTeX
formats.