search

damithc / testrepo3

0 stars 0 forks source link

Provide a new way for exporting evaluation/feedback report #232

Open damithc opened 10 years ago

damithc commented 10 years ago

From OTS.Nexus on January 08, 2014 17:19:04

The current way of exporting it as csv file does not work well for the case where the report contains foreign characters, as it can't be viewed in Excel properly.

Original issue: http://code.google.com/p/teammatespes/issues/detail?id=1466

damithc commented 10 years ago

From OTS.Nexus on January 08, 2014 03:41:30

Based on what I have founded online, there 3 open-source libraries for handling Excel file with Java: 1) Apache POI ( http://poi.apache.org/ ) -the most popular -might not to be fully compatible with GAE (require more research)

2)JExcel ( http://sourceforge.net/projects/jexcelapi/ ) -developed by individual, but no update since 2009 -supports only up to Excel 2003 (the new .xlsx format is not supported)

3)jXLS ( http://jxls.sourceforge.net/ ) -quite a new library, not much info available online

If we do not want to specifically deal with Excel, I got an idea as below: We can upload the generated csv file to Google Docs instead of giving them directly to users, since Google Docs is able to handle csv with Unicode. Then we give users the links to either download them as excel, pdf or other format.

This way would just required incorporating Google Drice SDK instead of finding external api for Excel.

Which might be a better option for us?

Status: Started

damithc commented 10 years ago

From dam...@gmail.com on January 08, 2014 04:09:32

As discussed: For now, let's simply give an additional instructions on how to import the csv to excel when they have non-English characters. Remember to record these findings in a tech report.