Export Excel chronoform

Hi, I don't manage to export my Data on a excel file (after I click on the connected table). It make an empty file.

But the csv export is workin.

I'm using the Version : 3.1 RC5.5

thanks in advance

Hi reficedev,

If CSV is working for you then use CSV.

Excel has some problems with Characters sets and with memory timeouts with large exports. There are a couple of threads here with some possible solutions.

Bob

that not a good solution.
the excel export should work...

It 's hard for a basic user to make things with a csv file... It's not user friendly 😑

and I still have a probleme with the characters like é à è ...

Hi reficedev,

You can open a CSV file in Excel.

Bob

I know.

It's ok for me, but not so easy for my custommers...

anyway, it works.
I just forgot to specify UTF-8 while I was importing the data from the csv file in excel :mrgreen:

Hey,

sorry to bring up this old topic again, but as I read from the posts, the issue is still unsolved. I think, I found an answer, at least for my Website. Hopefully, it might be helpful to somebody here.

The problem with the blank excel file seems to be not about character sets, but about server side restrictions to write temp files. I set a new (writeable) temp directory and now excel export works perfectly.

In the the file ../administrator/components/com_chronocontact/admin.chronocontact.php, I added after Line 1589 the following command:

$xls->setTempDir('/Your Joomla directory.../administrator/components/com_chronocontact/excelwriter/Writer/');

Hope, it helps.

Regards,
Frank.

Hi Frankz,

That's very helpful thank you.

We have at one time or another identified character set, memory limits and file permission problems with the Excel export. And for some people it just works :-(

Bob