FET Forum

FET Support (English) => General Stuff => Topic started by: kdogs on September 30, 2020, 04:00:10 PM

Title: FET To Excel By Roberto Trevisan - Issue Exporting
Post by: kdogs on September 30, 2020, 04:00:10 PM
Hi guys,
I am forced to send out the timetables to the faculty in Excel format and so this tool is very useful to me because otherwise I have to copy all the timetable variants manually. However, when I open the exported .xlsx file on Excel, I get the following message "We found a problem with some content in FileName.xlsx. Do you want us to try to recover as much as we can? If you trust the source of this workbook, Click Yes" Upon Clicking "Yes" I get the following message "The workbook cannot be opened or repaired by Microsoft Excel because it is corrupt". Does anyone know what might be causing this issue? I am using Excel 2013 on Windows 10.
Thanks!
Title: Re: FET To Excel By Roberto Trevisan - Issue Exporting
Post by: Liviu Lalescu on October 06, 2020, 02:57:50 PM
I am sorry, but I cannot help you with this, because it is out of my knowledge.
Title: Re: FET To Excel By Roberto Trevisan - Issue Exporting
Post by: Vangelis Karafillidis on October 06, 2020, 06:47:16 PM
I don't know what the problem is. I had problems when importing the FET generated html files into Excel or LibreOffice Calc. The filters didn't interpret correctly the structure of the html files, and the result was really dissapointing. There is another post (by dimzev) which implies that LibreOffice Calc imports and interprets correctly the FET generated html files. Maybe dimzev uses a newer version of LibreeOffice Calc.
A solution that worked for me:
I imported the html files into Gnumeric. Gnumeric is an open source spreadsheet application. This application interpreted correctly the structure of the html files. Then I saved the spreadsheet either as an xls or an ods file and opened the file for further editing either with Excel (xls format) or LibreOffice calc (ods or xls format).
Try this solution. It might work!
Vangelis.