I have a regular html table:
<table> <tr>hello</tr> <tr>world</tr> </table>
and I am creating an XLS file out of it:
string randomname = @"C:\attachmentsfolder\" + System.IO.Path.GetRandomFileName() + ".xls"; System.IO.File.WriteAllText( randomname, message);
When I open the XLS file generated, I need to MANUALLY expand the columns in order to see long data.
My question is: How can I generate this XLS file such that the columns are already sized properly?