Hello,
I have the code to export to excel, and to even format the date cells, but when I try to format to include am/pm it is not working. I am using the same format text to display am/pm in the grid successfully with "tt" but it does not seem to apply to excel's cell. It displays, for example, "08/06/2015 21:33:02 tt" instead of "8/6/2015 9:33:02 PM" which is the desired result.
excelExport:
function
(e) {
var
sheet = e.workbook.sheets[0];
for
(
var
rowIndex = 1; rowIndex < sheet.rows.length; rowIndex++) {
var
row = sheet.rows[rowIndex];
for
(
var
cellIndex = 0; cellIndex < row.cells.length; cellIndex ++) {
row.cells[cellIndex].format =
"MM/dd/yyyy hh:mm tt"
}
}
}