Postingan lainnya

Cara buat worksheet di excel tanpa phpexcel plugin

ada yang punya referensi Cara buat worksheet di excel tanpa phpexcel plugin?


<script type="text/javascript">
function fnExcelReport() {
  var tab_text = '<html xmlns:x="urn:schemas-microsoft-com:office:excel">';
  tab_text = tab_text + '<head><xml><x:ExcelWorkbook><x:ExcelWorksheets><x:ExcelWorksheet>';

  tab_text = tab_text + '<x:Name><?php echo $a;?></x:Name>';

  tab_text = tab_text + '<x:WorksheetOptions><x:Panes></x:Panes></x:WorksheetOptions></x:ExcelWorksheet>';
  tab_text = tab_text + '</x:ExcelWorksheets></x:ExcelWorkbook></xml></head><body>';

  tab_text = tab_text + "<table border='1px'>";
  tab_text = tab_text + $('#myTable').html();
  tab_text = tab_text + '</table></body></html>';

  var data_type = 'data:application/vnd.ms-excel';

  var ua = window.navigator.userAgent;
  var msie = ua.indexOf("MSIE ");

  if (msie > 0 || !!navigator.userAgent.match(/Trident.*rv\:11\./)) {
      if (window.navigator.msSaveBlob) {
          var blob = new Blob([tab_text], {
              type: "application/csv;charset=utf-8;"
          });
          navigator.msSaveBlob(blob, 'TestBook.xls');
      }
  } else {
      $('#test').attr('href', data_type + ', ' + encodeURIComponent(tab_text));
      $('#test').attr('download', 'Test file.xls');
  }

}
</script>

php

@Nandar

648 Kontribusi 204 Poin

Diperbarui 7 tahun yang lalu

2 Jawaban:

agan bisa manfaat packagist https://packagist.org/search/?q=excel untuk nyari package php apapun

misalnya http://faisalman.github.io/simple-excel-php/ contoh penggunaan ada di dokumentasinya sendiri

 use SimpleExcel\SimpleExcel;
use SimpleExcel\Spreadsheet\Worksheet;

$worksheet = new Worksheet();                                       // Define a new worksheet
$worksheet->insertRecord(array('ID', 'Nama Kota', 'Kode'));

$excel = new SimpleExcel();
$excel->insertWorksheet($worksheet);                                // Insert defined worksheet to excel document
$excel->insertWorksheet(new Worksheet());                           // Insert a new blank worksheet
$excel->getWorksheet(2)->insertRecord(array('1', '2', '3'));        // Insert a new row to that blank worksheet

$excel->exportFile('/home/faisalman/Downloads/test.xml', 'XML');    // Write document as XML file

@hilmanski

2670 Kontribusi 2132 Poin

Dipost 7 tahun yang lalu

Mau tanya mas sy mau buat akun premium mau liat tutorial excel apakah juga ada pembuatan worksheet nya?

@Nandar

648 Kontribusi 204 Poin

Dipost 7 tahun yang lalu