public static void ExportTo(this PivotGridControl pvtGrid, string fileName, bool openAfterExport = false)
{
var ext = new FileInfo(fileName).Extension;
switch (ext)
{
case ".csv":
pvtGrid.ExportToCsv(fileName);
break;
case ".htm":
case ".html":
pvtGrid.ExportToHtml(fileName);
break;
case ".bmp":
pvtGrid.ExportToImage(fileName);
break;
case ".mht":
pvtGrid.ExportToMht(fileName);
break;
case ".pdf":
pvtGrid.ExportToPdf(fileName);
break;
case ".rtf":
pvtGrid.ExportToRtf(fileName);
break;
case ".txt":
pvtGrid.ExportToText(fileName);
break;
case ".xls":
pvtGrid.ExportToXls(fileName);
break;
case ".xlsx":
pvtGrid.ExportToXlsx(fileName);
break;
default:
throw new Exception("გთხოვთ აირჩიოთ სწორი ფაილის ტიპი.");
}
if (openAfterExport)
{
try
{
Process.Start(fileName);
}
catch
{
//if (throwError) throw;
}
}
}
static void DoExportEx(string title, string filter, string exportFormat, PivotGridControl grid)
{
if (grid == null)
{
return;
}
string fname = grid.FindForm().Text;
fname = fname.Replace(" ", "");
fname = fname.Replace('/', '_');
//fname = FileUtility.GetValidateItemName(fname);
fname = fname + "_" + DateTime.Now.ToString("yyyyMMddHHmmss");
string fileName = ShowSaveFileDialog(title, filter, fname);
if (string.IsNullOrEmpty(fileName) == false)
{
PivotGridExportHelper exporter = new PivotGridExportHelper();
exporter.exportGrid = grid;
exporter.stop = false;
exporter.thread = new Thread(new ThreadStart(exporter.StartExport));
exporter.thread.Start();
Cursor currentCursor = Cursor.Current;
Cursor.Current = Cursors.WaitCursor;
switch (exportFormat)
{
case "htm": grid.ExportToHtml(fileName);
break;
case "mht": grid.ExportToMht(fileName);
break;
case "pdf": grid.ExportToPdf(fileName);
break;
case "xls": grid.ExportToXls(fileName);
break;
case "rtf": grid.ExportToRtf(fileName);
break;
case "txt": grid.ExportToText(fileName, "\t");
break;
}
exporter.EndExport();
Cursor.Current = currentCursor;
OpenFile(fileName);
}
}
public void ExportToExcel(PivotGridControl gcDxCualquierGrid)
{
SaveFileDialog saveDialog = new SaveFileDialog();
saveDialog.Title = "Guardar como";
saveDialog.DefaultExt = ".xls";
saveDialog.AddExtension = true;
saveDialog.CheckPathExists = true;
saveDialog.Filter = "Archivos de Microsoft Excel 2007 (*.xls)|*.xls|Todos los archivos (*.*)|*.*";
saveDialog.ShowDialog();
XlsExportOptions options = new XlsExportOptions();
options.TextExportMode = TextExportMode.Text;
if (!string.IsNullOrEmpty(saveDialog.FileName))
{
gcDxCualquierGrid.ExportToXls(saveDialog.FileName, options);
}
}
public static void ExportToExcel(PivotGridControl pivotGrid, string docName)
{
SaveFileDialog dialog = new SaveFileDialog();
dialog.Title = "Save Excel File";
dialog.Filter = "Excel files (*.xls)|*.xls";
dialog.FileName = StringHelper.Trim(docName.Replace('/', '_') + ".xls");
if (dialog.ShowDialog() == DialogResult.OK)
{
pivotGrid.ExportToXls(dialog.FileName);
if (MessageBox.Show("Excel File을 여시겠습니까?", "Open", MessageBoxButtons.OKCancel) == DialogResult.OK)
{
System.Diagnostics.Process ps = new System.Diagnostics.Process();
ps.StartInfo.FileName = dialog.FileName;
ps.Start();
}
}
}
public static void ExportGridToFile(PivotGridControl grid, string ext)
{
switch (ext)
{
case "xls":
grid.ExportToXls(File.ShowSaveFileDialog(ext), true);
return;
case "pdf":
grid.ExportToPdf(File.ShowSaveFileDialog(ext));
return;
case "htm":
grid.ExportToHtml(File.ShowSaveFileDialog(ext));
return;
case "rtf":
grid.ExportToRtf(File.ShowSaveFileDialog(ext));
return;
}
}
public static string ExportToExcel(PivotGridControl pivot, TextExportMode exportMode)
{
try
{
var fileName = GetSaveExcelFileName();
var extension = Path.GetExtension(fileName);
if (extension == ".xls")
{
pivot.ExportToXls(fileName,
new XlsExportOptions(
exportMode, true));
}
else if (extension == ".xlsx")
{
pivot.ExportToXlsx(fileName,
new XlsxExportOptions(
exportMode, true));
}
else
{
return "";
}
return fileName;
}
catch
{
}
return "";
}
