date format when exporting to excel changes

Question

date format when exporting to excel changes

Navigation

#1 by (0 votes)
#2 by (-1 votes)

1

I have this code to export to

c#

asked by oscar ramirez 10.05.2017 в 17:32

source

2 answers

Fit two divs How to do so that when I click on an Item in a listview in Android studio I opened a new activity

score 0 · Answer 1

Use NumberFormat :

Example:

string FRM_EXCEL_FECHA = "dd/MM/yyyy"; // o el formato que deseas:
ws.Cells[i + 2, j + 1].NumberFormat = FRM_EXCEL_FECHA;
ws.Cells[i + 2, j + 1].Value = dataGridView2.Rows[i].Cells[j].Value.ToString();

score -1 · Answer 2

-1

Give that format to your column

Range rango = (Excel.Range)worksheetobject.Cells[1,1];
rango.EntireColumn.NumberFormat = "DD/MM/YYYY";

answered by 10.05.2017 в 20:00