PhpSpreadsheet set background color of cell to white
Premlatha
Using phpspreadsheet, I want to set white background to the excel cell.
$cells='A1';
$spreadsheet->getActiveSheet()->getStyle($cells)->getFill()-
>setFillType(\PhpOffice\PhpSpreadsheet\Style\Fill::FILL_SOLID)-
>getStartColor(' #FFFFFF')->setARGB('#FFFFFF');
This code make cell background black even I set white color rgb value, #FFFFFF.
The result I want,
Thanks in advance.
Premlatha
The symbol '#' not need to be included when specify the ARGB in phpspreadsheet. This one able to set cell background white.
cell by cell
$spreadsheet->getActiveSheet()->getStyle($cells)->getFill()->setFillType(\PhpOffice\PhpSpreadsheet\Style\Fill::FILL_SOLID)->getStartColor()->setARGB('ffffff');
range of cells
$spreadsheet->getActiveSheet()->getStyle('A1:A5')->getFill()->setFillType(\PhpOffice\PhpSpreadsheet\Style\Fill::FILL_SOLID)->getStartColor()->setARGB('ffffff');
Collected from the Internet
Please contact javaer1[email protected] to delete if infringement.
edited at
Related
TOP Ranking
- 1
Spring Data MongoRepository save(T) not working... sometimes
- 2
pump.io port in URL
- 3
Title not updating in nextjs, tailwind css app
- 4
redirect your computer port to url
- 5
ngClass error (Can't bind ngClass since it isn't a known property of div) in Angular 11.0.3
- 6
How to see the schema sql (DDL) in spring boot?
- 7
how to use angular material form field and flex-layout
- 8
Transparent Background for TextEditor in SwiftUI
- 9
How does SwiftUI pass EnvironmentObjects between HostingController?
- 10
How to check if variable is integer (avoid problem with spaces around) in POSIX shell script?
- 11
AirflowException: Celery command failed - The recorded hostname does not match this instance's hostname
- 12
Format certain floating dataframe columns into percentage in pandas
- 13
Convert prompt-sync require into import method
- 14
Spring JpaRepository - Detach and Attach entity
- 15
Double spacing in rmarkdown pdf
- 16
Counting records in JSON array using javascript and Postman
- 17
Binary to Decimal in Haskell without using recursion or list comprehensions
- 18
Is it possible to pass values to a table type parameter from PYODBC to SQL Server?
- 19
Combining 3 boolean masks in Python
- 20
Use google recaptcha with Angular and WebAPI
- 21
Can't open lib 'ODBC Driver 13 for SQL Server'? Sym linking issue?
Comments