XLS column labels not to be Bold font?

Hi

Were you able to import data after you removed Bold for 1st line?

Yes, import went perfectly

P.S.
I have 50-100 exports during a day, is there a way for a plugin export 1st line (column headers) with regular font? Because it is not a solution for me to open every one of them and format the 1st line…?

please, open section “Misc Settigs” and add following code

add_action( 'woe_xls_print_header', function($objPHPExcel, $formater ) {
$sheet = $objPHPExcel->getActiveSheet();
$last_column = $sheet->getHighestDataColumn();
$sheet->getStyle( "A1:" . $last_column . "1" )->getFont()->setBold( false);
},10,2);

Thanks, that remove the bold from 1st line, but strangly my bussiness software still doesnt recognize it, it says “wrong format of file” error, like before.
And If I edit it myself (without Your code) and remove the formating of 1st line, it works. I use openoffice for editing xls…
Quite strange ??

EDIT: even if I just open xls (with Your code) in openoffice and just save it, it works perfectly..

• This reply was modified 3 years, 2 months ago by srkiller.

Xls? Or Xlsx?

Can you switch to CSV?

• This reply was modified 3 years, 2 months ago by algol.plus.

Its XLS (not xlsx)
Unfortunatelly, my software import option is XLS only

Please try to export without header line and import “as is”.

I think it’s general problem for generated file, regardless to formatting of 1st line.

import without header dont work.. same error “wrong format of file”.
I will try to contact sowtware devs..
Thanks for Your time!
my best

ok, got it.

please ping me with results

• This reply was modified 3 years, 2 months ago by algol.plus.