In SQL to Excel smart service the headers are not coming in BOLD

You cannot make the SQL to Excel smart service automatically format the header row in bold; it only controls data export, not Excel styling.
To get bold headers, you must use an Excel template where the header cells are already bold, and let the smart service just fill in the data below those cells.