Report in .xls format

Dear Team,
I am generating a report on daily and monthly basis with 30 variable(30 columns). The report is generated as expected in .pdf format but when the same report is saved in .xls format , the cells gets mixed up and the values are reflected in some other columns. Also please guide me how can I fix the width of the column.