Scripting language for Calc
Hello! I use LibreOffice Calc in order to create the timetable for my school. Some teachers are not available for some hours, which are denoted with the character "X" in the corresponding cells of the spreadsheet (timetable).
However, I need to enter these data (not available hours for each one of the teachers) in another application, which uses the xml format for its input file. The xml file carries many data and constraints, including the not available hours for each one of the teachers. So, saving the spreadsheet as a csv file does not work, since the xml file has completely different syntax and symbols (although the information is identical)!
What I need to do is write a script in order to "scan" the timetable of my school (the spreadsheet) and then create the xml file with the above mentioned data (with different syntax and symbols than the csv file).
Which programming language the best for this task in terms of simplicity and efficiency? Thanks a lot!
Hi @alex72gr. Can you please provide sample timetable and XML schema needed for the result? You can export your spreadsheet to xml format via XSLT filter (with some caveats, though), so maybe no any scripting is needed. Spreadsheet by itself is a file in xml format.
Hi! I uploaded the sample files. The ods file is the sample spreadsheet file with the time constraints. The odt file is actually the xml file. What I need is a script which "transforms" the spreadsheet information to the xml file (with the specific "notation" and syntax). Since this type of tasks is useful for me, if you think that it would be better for me to learn a programming language, please let me know. This XSLT filter might be a good solution, but Python (for example) might much better.