hello,
it is working fine with the newer verion the code in here
.............................................................................................................................................
Dim Workbook As New Workbook
Dim sheet1 As Worksheet = Workbook.Worksheets(0)
Dim cells As Cells = Workbook.Worksheets(0).Cells
cells(0, 1).PutValue("Responses")
cells(0, 2).PutValue("count")
cells(0, 3).PutValue("%")
cells(1, 1).PutValue("Male")
cells(1, 2).PutValue("9")
cells(1, 3).Formula = "=ROUND(((C2)/89),2)"
cells(1, 3).Style.Number = 10
HttpContext.Current.Response.ClearHeaders()
HttpContext.Current.Response.ContentType = ("application/force-download")
HttpContext.Current.Response.AddHeader("content-disposition", "attachment; filename=Test.xls")
HttpContext.Current.Response.Flush()
Response.Flush()
Dim mStream As IO.MemoryStream = New IO.MemoryStream()
Workbook.Save(mStream, FileFormatType.Default)
Response.BinaryWrite(mStream.ToArray())
Response.Flush()
........................................................................................................................................................................
i ahve one question for u if i am using the same propert as
cells(1, 3).Style.Number = 10
then y it is not working in my version and for this i have to again by the newer version
Regards
Lakdawala Zaid