I am using render tool to generate excel output and when I open the excel, I have to Weiden the columns, or the numbers won't be readable. even though I have increased the width of column
If you use the Output Tool to just write it to an Excel file, you can configure it to keep the tables formatting. This is only an available option if you select a specific cell range though. In my experience, you have to know the number of columns, but can overestimate the number of rows.
increase the width/dimension of the page you are writing to in render (ie set it for 30 X 30).