1. keep
  2. RO CSVI
  3. Wednesday, 16 January 2019
  4.  Subscribe via email
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?
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.

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 :)
  1. more than a month ago
  2. RO CSVI
  3. # 1
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 :)
  1. more than a month ago
  2. RO CSVI
  3. # 2
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 ;)
  1. more than a month ago
  2. RO CSVI
  3. # 3
Accepted Answer Pending Moderation
Big Like :)
  1. more than a month ago
  2. RO CSVI
  3. # 4
  • Page :
  • 1


There are no replies made for this post yet.
Be one of the first to reply to this post!