Proper XLS exports using PHPExcel [#1269994]

Comment	File	Size	Author
#22	views_data_export-phpexcel_support-1269994-22.patch	4.81 KB	ttournie

#21	views_data_export-phpexcel_support-1269994-21.patch	4.78 KB	ttournie

#20	views_data_export-phpexcel_support-1269994-20.patch	4.89 KB	kala4ek
7.x-3.x: PHP 5.5 & MySQL 5.5, D7 18 pass PHP 5.6 & MySQL 5.5, D7 18 pass
#17	views_data_export-phpexcel_support-1269994-17.patch	4.84 KB	kala4ek
7.x-3.x: PHP 5.5 & MySQL 5.5, D7 Patch failed to apply PHP 5.6 & MySQL 5.5, D7 Patch failed to apply
#15	views_data_export-phpexcel_support-1269994-11.patch	5.35 KB	apmsooner
7.x-3.x: PHP 5.5 & MySQL 5.5, D7 18 pass PHP 5.6 & MySQL 5.5, D7 18 pass
#11	views_data_export-phpexcel_support-1269994-11.patch	5.63 KB	apmsooner
7.x-3.x: PHP 5.5 & MySQL 5.5, D7 Patch failed to apply PHP 5.6 & MySQL 5.5, D7 Patch failed to apply
#7	views_data_export-phpexcel_support-1269994-7.patch	6.04 KB	Huntelaer
7.x-3.x: PHP 5.5 & MySQL 5.5, D7 1 fail PHP 5.6 & MySQL 5.5, D7 1 fail
#2	views_data_export-phpexcel_support-1269994-2.patch	5.3 KB	Johann Wagner
7.x-3.x: PHP 7 & MySQL 5.5 Checkout Error

Comment #1

Steven Jones CreditAttribution: Steven Jones commented 2 September 2013 at 10:13

Title:

PhpExcel

» Proper XLS exports using PhpExcel

This could be done as a standalone module, either in this codebase or in another project.

Log in or register to post comments

Comment #2

Johann Wagner CreditAttribution: Johann Wagner commented 25 August 2014 at 10:15

Issue summary:

View changes

File	Size
views_data_export-phpexcel_support-1269994-2.patch	5.3 KB
7.x-3.x: PHP 7 & MySQL 5.5 Checkout Error

Please find attached a patch that adds support for the PHPExcel library.

I also added a views option to choose Excel format (XLS or XLSX).

Log in or register to post comments

Comment #3

Johann Wagner CreditAttribution: Johann Wagner commented 25 August 2014 at 10:15

Status:

Active

» Needs review

Log in or register to post comments

Comment #4

Steven Jones CreditAttribution: Steven Jones commented 27 August 2014 at 05:47

Status:

Needs review

» Closed (won't fix)

See this FAQ page: https://www.drupal.org/node/1820458

Sorry but VDE core will not support 'proper' XLS files, but feel free to create a project on Drupal.org that provides the export format for VDE and I'll add a link from the project page.

Log in or register to post comments

Comment #5

d.novikov CreditAttribution: d.novikov commented 31 October 2014 at 14:01

Status:

Closed (won't fix)

» Needs review

Please take a look at this module, which I have just released. Do not know if it is properly designed, but it runs XLSX export for me:
https://www.drupal.org/project/views_data_export_phpexcel

Log in or register to post comments

Comment #6

Anonymous (not verified) CreditAttribution: Anonymous commented 1 September 2015 at 22:36

Thanks d.novikov.

I have been using a different php excel library (php_excel based on libXl) for other excel generation on my site. I was able to use that module as a base to get it to work with it.

Log in or register to post comments

Comment #7

Huntelaer CreditAttribution: Huntelaer commented 18 February 2016 at 10:32

File	Size
views_data_export-phpexcel_support-1269994-7.patch	6.04 KB
7.x-3.x: PHP 5.5 & MySQL 5.5, D7 1 fail PHP 5.6 & MySQL 5.5, D7 1 fail

I got error message:

Fatal error: Class 'PHPExcel' not found in sites/all/modules/contrib/views_data_export/theme/views_data_export.theme.inc on line 343

I resolved this by including the library path

Log in or register to post comments

Comment #8

18 February 2016 at 10:34

Status:

Needs review

» Needs work

The last submitted patch, 7: views_data_export-phpexcel_support-1269994-7.patch, failed testing.

Log in or register to post comments

Comment #9

18 February 2016 at 10:34

The last submitted patch, 7: views_data_export-phpexcel_support-1269994-7.patch, failed testing.

Log in or register to post comments

Comment #10

annared CreditAttribution: annared commented 22 August 2016 at 14:17

Fatal error: Class 'PHPExcel' not found in sites/all/modules/contrib/views_data_export/theme/views_data_export.theme.inc on line 343

I resolved this by including the library path

where did you include the library path?

Log in or register to post comments

Comment #11

apmsooner CreditAttribution: apmsooner commented 24 August 2016 at 18:11

File	Size
views_data_export-phpexcel_support-1269994-11.patch	5.63 KB
7.x-3.x: PHP 5.5 & MySQL 5.5, D7 Patch failed to apply PHP 5.6 & MySQL 5.5, D7 Patch failed to apply

Revised patch in #7 to attempt to pass test.

Log in or register to post comments

Comment #12

apmsooner CreditAttribution: apmsooner commented 24 August 2016 at 18:12

Status:

Needs work

» Needs review

Log in or register to post comments

Comment #13

24 August 2016 at 18:33

Status:

Needs review

» Needs work

The last submitted patch, 11: views_data_export-phpexcel_support-1269994-11.patch, failed testing.

Log in or register to post comments

Comment #14

24 August 2016 at 18:33

The last submitted patch, 11: views_data_export-phpexcel_support-1269994-11.patch, failed testing.

Log in or register to post comments

File	Size
views_data_export-phpexcel_support-1269994-11.patch	5.35 KB
7.x-3.x: PHP 5.5 & MySQL 5.5, D7 18 pass PHP 5.6 & MySQL 5.5, D7 18 pass

Comment #16

apmsooner CreditAttribution: apmsooner commented 24 August 2016 at 18:47

Status:

Needs work

» Needs review

Log in or register to post comments

Comment #17

kala4ek

Russian

🇷🇺 Novosibirsk

CreditAttribution: kala4ek as a volunteer and at DrupalJedi commented 7 September 2016 at 03:28

Title:

Proper XLS exports using PhpExcel

» Proper XLS exports using PHPExcel

File	Size
views_data_export-phpexcel_support-1269994-17.patch	4.84 KB
7.x-3.x: PHP 5.5 & MySQL 5.5, D7 Patch failed to apply PHP 5.6 & MySQL 5.5, D7 Patch failed to apply

Updated patch according to latest dev release.
Also fixed few issues related to code style.

Log in or register to post comments

Comment #18

7 September 2016 at 03:31

Status:

Needs review

» Needs work

The last submitted patch, 17: views_data_export-phpexcel_support-1269994-17.patch, failed testing.

Log in or register to post comments

Comment #19

7 September 2016 at 03:31

The last submitted patch, 17: views_data_export-phpexcel_support-1269994-17.patch, failed testing.

Log in or register to post comments

Comment #20

kala4ek

Russian

🇷🇺 Novosibirsk

CreditAttribution: kala4ek as a volunteer and at DrupalJedi commented 7 September 2016 at 03:36

Status:

Needs work

» Needs review

File	Size
views_data_export-phpexcel_support-1269994-20.patch	4.89 KB
7.x-3.x: PHP 5.5 & MySQL 5.5, D7 18 pass PHP 5.6 & MySQL 5.5, D7 18 pass

1 file was hidden/shown/deleted

File	Size
views_data_export-phpexcel_support-1269994-17.patch	4.84 KB
7.x-3.x: PHP 5.5 & MySQL 5.5, D7 Patch failed to apply PHP 5.6 & MySQL 5.5, D7 Patch failed to apply

Oops, wrong branch.
Reroll #17

Log in or register to post comments

Comment #21

ttournie CreditAttribution: ttournie commented 15 September 2016 at 06:56

File	Size
views_data_export-phpexcel_support-1269994-21.patch	4.78 KB

Hi,

Thanks for the patch !

For me this patch was not 100% working (issues with bulk export and xlsx format). I have modified it a little bit.

the patch is done from the 7.x-3.0-beta9

Log in or register to post comments

Comment #22

ttournie CreditAttribution: ttournie commented 15 September 2016 at 08:21

File	Size
views_data_export-phpexcel_support-1269994-22.patch	4.81 KB

I have added the trim of new line for a cleaner display.

Log in or register to post comments

Comment #23

Pls CreditAttribution: Pls as a volunteer commented 6 March 2017 at 20:37

#22 patch works great with PHPExcel class library. Thank you!

Log in or register to post comments

Comment #24

joey91133 CreditAttribution: joey91133 as a volunteer and at Fliegen commented 28 September 2017 at 01:39

Patch #22 is work without batch.

Log in or register to post comments

Comment #25

Dadaisme CreditAttribution: Dadaisme commented 14 December 2018 at 01:28

Hi!

I applied the patch #22 whit no error.

But the xls and xlsx files obtained are gibberish, they are not recognised as excel files. Any idea why?

Thx

Log in or register to post comments

Comment #26

cchoe1 CreditAttribution: cchoe1 commented 19 February 2019 at 19:27

@dadaisme

I haven't tested it out but I know PHPExcel has been deprecated as of Jan 2019. So even if this bug isn't a result of that, you should probably know that any future bugs related to the library probably won't be fixed. Should consider rewriting this patch using PHPSpreadsheet which is the successor to PHPExcel.