Change font size in excel file

General
1

Hello everyone!
i need to help me I'm 1st time to used Node-Red
i need to change font size in excel file

32

function node is

msg.payload = [{
        header: {
            'author': 'authorName',
            'title': 'title'
        },
        items: [
         {
            author:'john',
            title:'how to use this',
                
         },
         {
            author:'Bob',
            title:'so Easy'
         }
        ],
    cells: [
        {
            cell_value: "Hello there!",
            cell_styling: {
                fColor: "ffa2917d"
            }
        }
    ],
        sheetName: 'sheet1',
    },
    {
        header: {
            'a': 'AAAAA',
            'b': 'BBBBB'
        },
        items: [
         {
            a:'a',
            b:'b'
         },
         {
            a:'aa',
            b:'bb'
         }
        ],
        sheetName: 'sheet2',
    }];

      msg.filepath = msg.home + '/output.xlsx';

return msg;

the debug out put
9/18/2024, 12:40:57 PMnode: 82381af86c6fa645SSSSS : msg : Object

{ _msgid: "61f618188d392825", home: "E:/amr", topic: "SSSSS", payload: array[2], filepath: "E:/amr/output.xlsx" }

33
33759×467 41.7 KB

pls help

2

Welcome to the forum @amr

Which node are you using to write the excel file? Does the help text for that node say that you can set the front size?

3

Dear Colin
i need it for any node, but I'm already try put font size but no any effect happened

4

Do you mean that you are looking for a node that will write an excel file and allow you to specify the font size in that file?
If so then I think you will have to look at all the excel writing nodes and see if any of them say that the font size can be specified.

5

This topic was automatically closed 90 days after the last reply. New replies are no longer allowed.