Formatting is removed

May 26, 2011 at 2:58 PM

We are using ExtemeML to create XL files. We have templates created with the named ranges and the sheet is formatted for the date and numbers. The program opens the XL and writes the data, but the formatting is getting removed. There by all the numbers and dates are not appearing in the expected format. The reason we moved to ExtremeML is because we wanted to improve in performance when compared to OpenXML. Is there a way where the XL can be changed to retain the format.