please open section “Misc Settings” ( at bottom of the page) and add this code
add_action( 'woe_xls_print_header', function($objPHPExcel, $formater ) {
$objPHPExcel->getDefaultStyle()->getAlignment()->setWrapText(true);
},10,2);
Thread Starter
db151
(@moddingrepair)
Hi thanks so much for the code, but I noticed that it is for the xls file, could you get the file exported to the CSV? A thousand thanks
please don’t click on CSV file.
start Excel and use menu Data>From Text/CSV.
So you can configure format for necessary column.
Thread Starter
db151
(@moddingrepair)
add_action( 'woe_xls_print_header', function($objPHPExcel, $formater ) {
$objPHPExcel->getDefaultStyle()->getAlignment()->setWrapText(true);
},10,2);
Maybe I explained myself badly, I meant if the code is ok for exporting the csv file? . I only export with csv files
hi
You don’t need any code.
CSV is plain text format.
so you must format columns when you open file in Excel, via menu Data.
if I still understand you incorrectly — please record the video
Thread Starter
db151
(@moddingrepair)
my export file is .csv file. Is the code you gave me good for .csv files or is it only good for .xls files?
screen : https://prnt.sc/t4e4XvqEx00u
- I sent you code for XLS
- You don’t need code to format CSV
please record the video of the problem
