We are exporting data to Excel using XlsIO library. The string values in data table may have leading zeroes. The problem is these values are treated as numbers in Excel and leading zeroes are stripped out.
Setting worksheet.IsStringsPreserved property to true is not the solution - all the values in the sheet will be treated as strings which is not desired behaviour.
Also the predefined formatting of the column is ignored - the format of the first column is text, but the values are displayed as numbers with 2 decimal places.