Thanks Martin. So here is the catch, I an not using the UniGrid to perform the export, I'm simply making an API call and passing my dataset into it.
private void ExportData(DataExportFormatEnum format)
{
DataSet ds = MyProvider.GetAllTransactions(StartDate, EndDate).DataSetResults;
foreach (DataColumn dc in ds.Tables[0].Columns)
{
dc.ColumnName = dc.ColumnName.Replace("RS_", "").Replace("#", "");
}
ds.AcceptChanges();
DataExportHelper eh = new DataExportHelper(ds);
eh.ExportData(format, Page.Response);
}
I have a link button on a page the user clicks and depending on the link button clicked, it calls this method and performs the export. What I've done is simply remove the Excel export option and allow them to export to CSV and XML as CSV doesn't format the data to text.
Ideally I'd like to export to QIF (Quicken) or some other formats money management software format.