Hi, Im just using AdvancedExcel to export data. I get trouble when cell-formatting. When I set Bold is true, It just in-bold the header of 1st column, others are not. Someone please help me about it
Hi @Kiet Truong ,
I am not very sure why it only applies only to the first row.
But I believe if you try to use Cell_WriteRangeWithFormat, you should be able to achieve what you need. Maybe that's why there is that separate action to use if you really need formatting.
Regards,
Bryan
hi @Bryan Villalobos , there is just 1 different thing between these action is about ExportHeaders, I need this to add header to my sheet. With Cell_WriteRangeWithFormat, Bold work as in-bold all the text in sheet, not just header.
Just a point to note: You said "Bold work as in-bold all the text in sheet" - Actually, the formatting will work only on the range that you defined. But not all the text.
Anyway, I understand you needed that Export headers. So I think you can just use Cell_FormatRange after the Cell_WriteRange and define the range you need for the format.
Hello @Kiet Truong
1. You must set the value of each cell to true to make the entire column bold.
2. If you encounter an issue, follow these steps.
Step 1: Create an Excel sheet template with all cells in bold, as shown in the screenshot.
Remark: Provide the sheet name, for example, "Excel_Demo".
Step 2: Upload the file to your resource folder in the Service Studio.
Step 3: Use workbook_Open and select the Excel file you just uploaded from resources.
Step 4: Use Worksheet_Select to choose the Excel sheet you defined in the "Excel_Demo" sheet.
Step 5: Retrieve all data from the input parameter and use cell_write to add the data to Excel and obtain the binary.
Feel free to ask if you have any issues.
Regards
Nikhil Kumar Vijay