This is a migrated thread and some comments may be shown as answers.

RadGrid export to csv formatting

0 Answers 51 Views
Grid
This is a migrated thread and some comments may be shown as answers.
Peeyush
Top achievements
Rank 1
Peeyush asked on 08 Aug 2012, 02:19 PM
        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;
}
Hello,

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

No answers yet. Maybe you can help?

Tags
Grid
Asked by
Peeyush
Top achievements
Rank 1
Share this question
or