phpmyadmin icon indicating copy to clipboard operation
phpmyadmin copied to clipboard

[Feat]: Import/Export Excel (OpenOffice XML) Files

Open raffaem opened this issue 3 months ago • 4 comments

phpMyAdmin version

5.2.3

Describe the feature

I searched but I don't think it was already asked

Any plans to import/export Excel files (.xlsx / OpenOffice XML)?

Describe the solution

Import / Export XLSX files

Describe the alternatives

From Excel export as ODS or CSV.

But you need to re-export every time you update the table.

Additional context

No response

raffaem avatar Nov 25 '25 10:11 raffaem

Good idea, #19957 is making exporting a bit simpler. Would you make a pull-request to implement this format ?

it looks like it was an export format in the past: https://github.com/phpmyadmin/phpmyadmin/pull/12902 Source code: https://github.com/phpmyadmin/phpmyadmin/blob/RELEASE_3_3_10/libraries/export/xlsx.php It was added near 2010: https://github.com/phpmyadmin/phpmyadmin/commits/RELEASE_3_3_10/libraries/export/xlsx.php

@ibennetch do you know more about it ?

williamdes avatar Nov 25 '25 20:11 williamdes

hey @williamdes , i see its assigned for new contributors, could you please asssign me this issue!, i'd like to work on it!

AryanBagade avatar Nov 26 '25 05:11 AryanBagade

hey @williamdes , i see its assigned for new contributors, could you please asssign me this issue!, i'd like to work on it!

You can go ahead. If possible please do not add a new dependency on a library

williamdes avatar Nov 26 '25 08:11 williamdes

will try will create a pr

AryanBagade avatar Nov 26 '25 08:11 AryanBagade