Atitit.excel Export Functionality Solution PHP Java version c#.net total collection. doc

Atitit.excel Export functionality Solution PHP java version c#.net Total collection . docx

.1. save format office2003 office2007/2010 format 1

1 . 2. Class Library Selection java. NET has Apache.poi available,php uses phpexcel1.8.0 1

1 . 3. issues that need to be addressed 2

1 . 4. Custom class Library Atiexcel 2

1 . 5. process details for Excel export - - export headers 2

1 . 6. process details for Excel export - - Export Data 2

1 . 7. The difference between phpexcel and poi 3

1.1. Excel save format office2003 office2007/2010 format

The Legacy office Family uses The Save format of Office 2003, which is essentially a binary compound document storage format that is now deprecated.

And the old version of theOffice (Office ), -,XP,2003)compared to the common format ofOfficethe extension of the document file adds aX, such asWordof the document. DOCthe format becomes. DOCXformat,Excelof the spreadsheet. XLSthe format becomes. XLSXformat, and so on

 openxml ( ooxml office office word , excel , powerpoint openxml format.

new version of The office family is stored in zip+ooxml format

The storage format used by the latest version of the OFFICE2016 series is still in the office2007/2010 format:

1.2.Class Library Selection java. NET has apache.poi available,php uses phpexcel1.8.0

Author :: ★ (Attilax) >>>    nickname : old Wow's paw   (   full name:: ATTILAX AKBAR AL RAPANUI  Attilax   Baroque   Alpha   Rapa Nui   )   Kanji name: Ayron, Email:[email protected]

reprint Please indicate source: http://www.cnblogs.com/attilax/

1.3. issues that need to be addressed

You need to be able to save list<map> data as Excel.

You need a table header mapping table that can bind list<map ...

Java PHP. NET version API uniformity

1.4. Custom class Library Atiexcel

Open source for flexibility, the provision of APIs too trivial, resulting in less efficient development. Further encapsulation is required.

1.5. process details for Excel export - - export headers

function AddLine ($objPHPExcel, $line, $lineNum, $isFirstTitle =false) {

$line = $list [0];

$keys =array_keys ($line);

$alphas _str= "A,b,c,d,e,f,g,h,i,j,k,l,m,n,o,p,q,r,s,t";

$alphas =explode (",", $alphas _str);

$sheet = $objPHPExcel->setactivesheetindex (0);

$i = 0;

Print_r ($keys);d ie ();

foreach ($keys as $key)

{

$alp = $alphas [$i];

// Die ($alp);

if ($isFirstTitle)

$cell = $key;

Else

$cell = $line [$key];

$sheet->setcellvalue ($alp. $lineNum, $cell);

$i + +;

}

}

1.6. process details for Excel export - - Export Data

Export data basic and Export header API has been, but the data cell value is different, the table header method is to take the row key , the data mode is the valuethat needs row :

1.7. The difference between phpexcel and poi

Phpexcel directly operates the cell, using a1,b2 to locate the cell mode, Poi needs to find the rowfirst, more cumbersome.

Reference

PHP Operations Excel – phpexcel Basic usage -diandian_520 's column - Blog Channel -CSDN.NET.html

Atitit.excel Export Functionality Solution PHP Java version c#.net total collection. doc