XLS column labels not to be Bold font?

  • srkiller

    (@srkiller)


    4 years, 7 months ago

    Hi,
    my bussines software cannot import XLS export from plugin because column labels are in bold font. Is there a way to fix it somehow via “custom php code”, for column labels font to be regular, just like data beneath it?
    best regards

Viewing 10 replies - 1 through 10 (of 10 total)
  • Plugin Author algol.plus

    (@algolplus)

    4 years, 7 months ago

    Hi

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

    Thread Starter srkiller

    (@srkiller)

    4 years, 7 months ago

    Yes, import went perfectly

    Thread Starter srkiller

    (@srkiller)

    4 years, 7 months ago

    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…?

    Plugin Author algol.plus

    (@algolplus)

    4 years, 7 months ago

    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);
    Thread Starter srkiller

    (@srkiller)

    4 years, 7 months ago

    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 4 years, 7 months ago by srkiller.
    Plugin Author algol.plus

    (@algolplus)

    4 years, 7 months ago

    Xls? Or Xlsx?

    Can you switch to CSV?

    • This reply was modified 4 years, 7 months ago by algol.plus.
    Thread Starter srkiller

    (@srkiller)

    4 years, 7 months ago

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

    Plugin Author algol.plus

    (@algolplus)

    4 years, 7 months ago

    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.

    Thread Starter srkiller

    (@srkiller)

    4 years, 7 months ago

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

    Plugin Author algol.plus

    (@algolplus)

    4 years, 7 months ago

    ok, got it.

    please ping me with results

    • This reply was modified 4 years, 7 months ago by algol.plus.
Viewing 10 replies - 1 through 10 (of 10 total)

The topic ‘XLS column labels not to be Bold font?’ is closed to new replies.