Last post May 28, 2018 02:26 AM by Nan Yu
May 26, 2018 07:01 AM|vijaylakshmi|LINK
I have a dataset which is bind to a gridview
i want to give a download option in excel. i have written the code and it works fine..
but in the excel sheet the rupee symbol is not coming.
i wrote a code to get the rupee symbol in to get the symbol in the gridview.
why is not coming in the excel cell..??
May 28, 2018 02:26 AM|Nan Yu|LINK
I don't know how do you export the dataset to excel , with Microsoft.Office.Interop.Excel or some other plugins . If you are using Microsoft.Office.Interop.Excel , you can try excel currency formatting like :
formatRange = xlWorkSheet.get_Range("a1", "b1");
formatRange.NumberFormat = "$ #,###,###.00";
xlWorkSheet.Cells[1, 1] = "1234567890";
Please refer to below links for more details and code samples :