protected void btnExportToExcel_Click(object sender, EventArgs e)
{
radgridSentiment.ExportSettings.IgnorePaging = true;
radgridSentiment.MasterTableView.ExportToCSV();
radgridSentiment.MasterTableView.GetColumn("columnTweetID").Visible = true;
radgridSentiment.MasterTableView.GetColumn("columnBusinessAreas").Visible = true;
radgridSentiment.MasterTableView.GetColumn("columnLocation").Visible = true;
radgridSentiment.MasterTableView.GetColumn("columnAuthorLocationContinentCode").Visible = true;
radgridSentiment.MasterTableView.GetColumn("columnAuthorLocationStateCode").Visible = true;
radgridSentiment.MasterTableView.GetColumn("columnAuthorLocationRegionCode").Visible = true;
radgridSentiment.MasterTableView.GetColumn("columnAuthorLocationCountryCode").Visible = true;
radgridSentiment.MasterTableView.GetColumn("columnDataSourceIndustry").Visible = true;
radgridSentiment.MasterTableView.GetColumn("columnDataSourceCoverageArea").Visible = true;
radgridSentiment.MasterTableView.GetColumn("columnDataSourceBusinessArea").Visible = true;
radgridSentiment.MasterTableView.GetColumn("columnLifeStyle").Visible = true;
radgridSentiment.MasterTableView.GetColumn("DataURL").Visible = true;
radgridSentiment.MasterTableView.GetColumn("columnUserID").Visible = true;
radgridSentiment.MasterTableView.GetColumn("columnSelect").Visible = false;
radgridSentiment.MasterTableView.GetColumn("columnAction").Visible = false;
radgridSentiment.MasterTableView.GetColumn("columnTweetDataExport").Visible = true;
radgridSentiment.MasterTableView.GetColumn("columnTweetData").Visible = false;
}
I have a button on click of which i export the data of a grid in csv format, and i have some columns having integer values in 15+ digits, the problem is that when the data of grid is exported i find the value in exponent form ie. if the value is 232837539508146000 than i am getting it as 2.32837E+17, i want the value as it is.
its urgent!
Thanks in advance!
With Regards,
Peeyush Pandey