hi,
i am trying to write number to excel.
the column formated as below
Style colStyle = sheet.Cells.Columns[colIndex].Style;
StyleFlag flag = new StyleFlag();
flag.NumberFormat = true;
//Set the formating on the as text formating
colStyle.Number = 1;
sheet.Cells.Columns[colIndex].ApplyStyle(colStyle, flag);
and i am writing int type
in excel i receive the number with green triangle that saying : number sorted as text
and below convert to number.
how do i write it as text from the beginning
Thanks
shemesh