Perhaps this is a simple question, but I have not found any information about this anywhere. I am creating an Excel file and I have a little problem when creating the file. The problem is that I call the autofilter method to filter all columns, and then I call the autosize method, but it does not seem to take into account the space that the down arrows in the cells fall into.
For example, I have a column with the heading "AA", and when the file is generated, the column is shrunk, so I can only see the down arrow, not the header text. Unfortunately, the column values ββare not long enough to make the column longer when the autosize method is called ...
So, does anyone have a solution for this?
Thanks in advance!
source share