e.g. in Excel template file we've set range(3,17,3,37) format as "dd-MMM-yyyy" to display date value.
but after file downloaded, it displays all date value in "yyyy-MM-dd hh:mm:ss"
I've tried setting format in the code as well, it still doesn't work. Any idea about this issue?? Thanks!
- Code: Select all
ws.InsertDataTable(dt, False, 3, 1)
ws.Range(3, 17, 3, 37).NumberFormat = "dd-MMM-yyyy"