> $rows */ public static function build( array $rows ): string { if ( ! class_exists( ZipArchive::class ) ) { return ''; } $tmp = wp_tempnam( 'datvetau-import-sample.xlsx' ); if ( ! $tmp ) { return ''; } $zip = new ZipArchive(); if ( true !== $zip->open( $tmp, ZipArchive::OVERWRITE ) ) { return ''; } $sheet_xml = self::sheet_xml( $rows ); $zip->addFromString( '[Content_Types].xml', self::content_types_xml() ); $zip->addFromString( '_rels/.rels', self::root_rels_xml() ); $zip->addFromString( 'xl/workbook.xml', self::workbook_xml() ); $zip->addFromString( 'xl/_rels/workbook.xml.rels', self::workbook_rels_xml() ); $zip->addFromString( 'xl/worksheets/sheet1.xml', $sheet_xml ); $zip->addFromString( 'xl/styles.xml', self::styles_xml() ); $zip->close(); $bytes = (string) file_get_contents( $tmp ); wp_delete_file( $tmp ); return $bytes; } /** * @param array> $rows */ private static function sheet_xml( array $rows ): string { $lines = array( '' ); $lines[] = ''; foreach ( $rows as $r_idx => $row ) { $row_num = $r_idx + 1; $lines[] = ''; foreach ( $row as $c_idx => $value ) { $ref = self::cell_ref( $c_idx, $row_num ); $value = htmlspecialchars( (string) $value, ENT_XML1 | ENT_QUOTES, 'UTF-8' ); if ( is_numeric( $value ) && '' !== $value && 0 === $c_idx && $row_num > 1 ) { // ngay co the la so serial — de dang text trong mau. } $lines[] = '' . $value . ''; } $lines[] = ''; } $lines[] = ''; return implode( '', $lines ); } private static function cell_ref( int $col, int $row ): string { $n = $col + 1; $letters = ''; while ( $n > 0 ) { --$n; $letters = chr( ord( 'A' ) + ( $n % 26 ) ) . $letters; $n = (int) ( $n / 26 ); } return $letters . (string) $row; } private static function content_types_xml(): string { return '' . '' . '' . '' . '' . '' . '' . ''; } private static function root_rels_xml(): string { return '' . '' . '' . ''; } private static function workbook_xml(): string { return '' . '' . ''; } private static function workbook_rels_xml(): string { return '' . '' . '' . '' . ''; } private static function styles_xml(): string { return '' . ''; } }