I like CSVI a lot but the lack of XLS/XLSX as export format can be a huge disadvantage sometimes. I use LibreOffice which can handle CSV files very well, but Microsoft Excel works terrible with them. Of course I can use import function but some customers can't understand why and and how it works. They only want to open the downloaded file with a simple double click, and usually they get the whole data in a single column no matter what I set up.
I used PHPExcel for this task with my custom scripts. With that converting CSV to XLSX is just a few lines and can be done as a last step, after I created the CSV. As far as I can see it's deprecated now, but I'm sure there are a pretty good tools for the job like PhpSpreadsheet etc. I'm not sure about the license of them but could you please consider extending the funcionality of CSVI with that?
You need to be logged in to view a user's profile.
Accepted Answer
Pending Moderation
Hello,
The support of the XLS/XLSX format has been an issue of licensing in the past. Apart from that, we have to see if the issue of memory involves the export as well. For Import an XLS file must be read into memory completely, which can be an issue.
I will have another look at what is available as well but no promises at this point
The support of the XLS/XLSX format has been an issue of licensing in the past. Apart from that, we have to see if the issue of memory involves the export as well. For Import an XLS file must be read into memory completely, which can be an issue.
They only want to open the downloaded file with a simple double click, and usually they get the whole data in a single column no matter what I set up.That is a matter of configuration though. You need to use the correct delimiters as specified on the users computer. By setting the option Excel CSV and giving the export filename the .xls extension will open the file directly in Excel. This way users don't have to use the import from file option in Excel. Have you tried that?
I will have another look at what is available as well but no promises at this point
Kind regards,
RolandD
=========================
If you use our extensions, please post a rating and a review at the Joomla! Extension Directory
RolandD
=========================
If you use our extensions, please post a rating and a review at the Joomla! Extension Directory
Accepted Answer
Pending Moderation
Hi RolandD
Just FYI, I have just implemented a simple PhpSpreadsheet function into my other project.
https://github.com/PHPOffice/PhpSpreadsheet
https://phpspreadsheet.readthedocs.io/en/latest/
The code is maintained, works very well.
Converting an existing CSV to XLS,XLSX, ODS (even maybe HTML/PDF) is very simple: https://www.codediesel.com/php/convert-csv-to-excel-format-in-php/
I'd love this feature in CSVI
Just FYI, I have just implemented a simple PhpSpreadsheet function into my other project.
https://github.com/PHPOffice/PhpSpreadsheet
https://phpspreadsheet.readthedocs.io/en/latest/
The code is maintained, works very well.
Converting an existing CSV to XLS,XLSX, ODS (even maybe HTML/PDF) is very simple: https://www.codediesel.com/php/convert-csv-to-excel-format-in-php/
I'd love this feature in CSVI
Accepted Answer
Pending Moderation
Hello,
In CSVI 8, the next generation of CSVI will make use of this library. So it is coming at some point
In CSVI 8, the next generation of CSVI will make use of this library. So it is coming at some point
Kind regards,
RolandD
=========================
If you use our extensions, please post a rating and a review at the Joomla! Extension Directory
RolandD
=========================
If you use our extensions, please post a rating and a review at the Joomla! Extension Directory
- Page :
- 1
There are no replies made for this post yet.
Be one of the first to reply to this post!
Be one of the first to reply to this post!