WithColumnWidthsTest.php 1.0 KB

12345678910111213141516171819202122232425262728293031323334353637383940414243
  1. <?php
  2. namespace Maatwebsite\Excel\Tests\Concerns;
  3. use Maatwebsite\Excel\Concerns\Exportable;
  4. use Maatwebsite\Excel\Concerns\FromArray;
  5. use Maatwebsite\Excel\Concerns\WithColumnWidths;
  6. use Maatwebsite\Excel\Tests\TestCase;
  7. class WithColumnWidthsTest extends TestCase
  8. {
  9. /**
  10. * @test
  11. */
  12. public function can_set_column_width()
  13. {
  14. $export = new class implements FromArray, WithColumnWidths
  15. {
  16. use Exportable;
  17. public function columnWidths(): array
  18. {
  19. return [
  20. 'A' => 55,
  21. ];
  22. }
  23. public function array(): array
  24. {
  25. return [
  26. ['AA'],
  27. ['BB'],
  28. ];
  29. }
  30. };
  31. $export->store('with-column-widths.xlsx');
  32. $spreadsheet = $this->read(__DIR__ . '/../Data/Disks/Local/with-column-widths.xlsx', 'Xlsx');
  33. $this->assertEquals(55, $spreadsheet->getActiveSheet()->getColumnDimension('A')->getWidth());
  34. }
  35. }