Skip to Content
Menu
Musisz się zarejestrować, aby móc wchodzić w interakcje z tą społecznością.
To pytanie dostało ostrzeżenie
1 Odpowiedz
9649 Widoki

I want to set width of column in excel report please help me/

Awatar
Odrzuć
Najlepsza odpowiedź

Hi,

You can set the column width in excel report like this:  sheet.set_column(2, 2, 20)

here 20 is the size set for the column, you can change it accordingly.

Also have a look at this explaining the same: How To Increase Column Width of Excel Report in Odoo

Thanks

Awatar
Odrzuć
Autor

what is the mean of the first 2 and second 2 one of them mean number of column and what about second 2 mean, and other question is if i have to set 3 column width 20 and next three 30 and so on then i have to set same like that for each column or we can create variable for that and can use that variable if yes then how we can create variable please.

Thanks.

sheet.set_column(i, j, size).

Where i ,j = the column index and size= the size of the column

eg . sheet.set_column(0, 0, 20) to set the size of the first column to 20 and sheet.set_column(0, 1, 20) to set the size of the second column to 20

Powiązane posty Odpowiedzi Widoki Czynność
2
maj 16
5116
0
gru 22
4477
0
wrz 24
1430
2
cze 18
7444
0
mar 18
3546