No replies to this topic

[shailugs]

Hi,
I am creating HSSFSheet using HSSFWorkbook. The sheet is getting created properly. but when i open the sheet the column width is 8.43 for all the columns, but i want like when i open the sheet it should show each column fit to its contents.
for now what i do is when i open the sheet i select all column and then double clicks on the column seperator line to view all the contents properly. Can this be done in coding itself by using HSSFSheet sheet object anyhow. so that when i open the created sheet it will show each column fit to its contents & i dont have to expand each column after i opened the file.
thanks is advance. Please let me know if you need more explanation.