Using PHP to generate Excel files to the specified directory _php tutorial

Source: Internet
Author: User

Generate an Excel file in PHP to a specified directory


This article mainly introduces the use of PHP to generate Excel files to the specified directory of relevant information, the need for friends can refer to the following

Recently the company wants to generate a report, generated in PHP.

Header ("Content-type:application/vnd.ms-excel");

Header ("Content-disposition:attachment;filename=test_data.xls");

I Baidu, seemingly this can be achieved soon, but this file is generated in the browser to download the place,

I want to generate the generated files to the specified directory, so can it be implemented?

Also, can I insert a picture inside?

Phpexcel is English, read for a long while not understand. Is there a direct-generated example to look at?

Below we enclose an example:

?

1

2

3

4

5

6

7

8

9

10

11

12

13

14

15

16

17

18

19

20

21st

22

23

24

25

26

27

28

29

30

31

32

33

34

35

36

37

38

39

40

41

42

43

44

45

46

47

48

49

50

51

52

53

54

55

56

57

58

59

60

61

62

63

64

65

66

67

68

69

70

71

72

73

74

/**

+----------------------------------------------------------

* Import the required class library with Java

* This function has the function of caching

+----------------------------------------------------------

* @param string $class Class library namespace strings

* @param string $BASEURL start path

* @param string $ext imported file name extensions

+----------------------------------------------------------

* @return Boolen

+----------------------------------------------------------

*/

Function Import ($class, $baseUrl = ', $ext = '. class.php ') {

Static $_file = Array ();

$class = str_replace (Array ('. ', ' # '), Array ('/', '. '), $class);

if (' = = = $baseUrl && false = = = Strpos ($class, '/')) {

Check alias Import

Return Alias_import ($class);

}

if (Isset ($_file[$class. $baseUrl]))

return true;

Else

$_file[$class. $baseUrl] = true;

$class _strut = explode ('/', $class);

if (empty ($BASEURL)) {

if (' @ ' = = $class _strut[0] | | App_name = = $class _strut[0]) {

Load the current Project Application class Library

$BASEURL = DirName (Lib_path);

$class = Substr_replace ($class, basename (lib_path). ' /', 0, strlen ($class _strut[0]) + 1);

}elseif (' think ' = = Strtolower ($class _strut[0])) {//Think official base Class library

$BASEURL = Core_path;

$class = substr ($class, 6);

}elseif (In_array (Strtolower ($class _strut[0]), array (' org ', ' com ')) {

Org third party public class library COM enterprise public class Library

$BASEURL = Library_path;

}else {//Load other Project Application class library

$class = Substr_replace ($class, ", 0, strlen ($class _strut[0]) + 1);

$BASEURL = App_path. '.. /' . $class _strut[0]. '/'. basename (Lib_path). ' /';

}

}

if (substr ($BASEURL,-1)! = '/')

$baseUrl. = '/';

$classfile = $baseUrl. $class. $ext;

if (!class_exists (basename ($class), false)) {

Import the class library file if the class does not exist

Return Require_cache ($classfile);

}

}

/**

* Export Excel Table

* @param array $data data, two-dimensional array, one record per piece of data

* @param array $title The field names of each column of data, and the arrays must be consistent with the data order (can be omitted)

* @param string $filename Excel name

* @param array $field need to specify the exported data field, the sort must match the title, that is, and the array key value of the data is isolated

*/

function Exportexcel ($data = ', $title = ', $filename = ' Excel ', $field =array ()) {

if (! $data | |!is_array ($DATA)) return false;

if ($filename = = ") $filename = ' Excel ';

if ($field && Is_array ($field)) {//As long as the specified fields are exported and exported in this order

$dateNew =array ();

foreach ($data as $k = = $v) {

foreach ($field as $fkey) {

$dateNew [$k] [$fkey]= $v [$fkey];

}

}

$data = $dateNew;

}

Import ("@.org.util.excelxml");//Call Export Excel Class

$xls = new Excelxml (' UTF-8 ', false, ' Sheet1 ');

$xls->addarray ($data, $title);

$xls->generatexml ($filename);

}

http://www.bkjia.com/PHPjc/1020279.html www.bkjia.com true http://www.bkjia.com/PHPjc/1020279.html techarticle using PHP to generate Excel files to a specified directory this article mainly introduces the use of PHP to generate Excel files to the specified directory of relevant information, the need for friends can refer to the recent company to generate reports, with ...

  • Contact Us

    The content source of this page is from Internet, which doesn't represent Alibaba Cloud's opinion; products and services mentioned on that page don't have any relationship with Alibaba Cloud. If the content of the page makes you feel confusing, please write us an email, we will handle the problem within 5 days after receiving your email.

    If you find any instances of plagiarism from the community, please send an email to: info-contact@alibabacloud.com and provide relevant evidence. A staff member will contact you within 5 working days.

    A Free Trial That Lets You Build Big!

    Start building with 50+ products and up to 12 months usage for Elastic Compute Service

    • Sales Support

      1 on 1 presale consultation

    • After-Sales Support

      24/7 Technical Support 6 Free Tickets per Quarter Faster Response

    • Alibaba Cloud offers highly flexible support services tailored to meet your exact needs.