public static void ExportPivotToExcel(RadPivotGrid pivot)
{
SaveFileDialog dialog = new SaveFileDialog();
dialog.DefaultExt = "xlsx";
// dialog.Filter = "CSV files (*.csv)|*.csv |All Files (*.*) | *.*";
var result = dialog.ShowDialog();
if ((bool)result)
{
try
{
using (var stream = dialog.OpenFile())
{
var workbook = GenerateWorkbook(pivot);
// IWorkbookFormatProvider formatProvider = new CsvFormatProvider();
//formatProvider.Export(workbook, stream);
XlsxFormatProvider provider = new XlsxFormatProvider();
provider.Export(workbook, stream);
}
}
catch (IOException ex)
{
MessageBox.Show(ex.Message);
}
}
}
private void ExportToExcel()
{
this.BusyIndicator.IsBusy = true;
SaveFileDialog dialog = new SaveFileDialog();
dialog.DefaultExt = "xlsx";
dialog.Filter = "Excel Workbook (xlsx) | *.xlsx |All Files (*.*) | *.*";
var result = dialog.ShowDialog();
if ((bool)result)
{
try
{
using (var stream = dialog.OpenFile())
{
var workbook = GenerateWorkbook();
XlsxFormatProvider provider = new XlsxFormatProvider();
provider.Export(workbook, stream);
}
}
catch (IOException ex)
{
MessageBox.Show(ex.Message);
}
}
this.BusyIndicator.IsBusy = false;
}
public static void ExportPivotToExcel(RadPivotGrid pivot)
{
SaveFileDialog dialog = new SaveFileDialog();
dialog.DefaultExt = "xlsx";
// dialog.Filter = "CSV files (*.csv)|*.csv |All Files (*.*) | *.*";
var result = dialog.ShowDialog();
if ((bool)result)
{
try
{
using (var stream = dialog.OpenFile())
{
var workbook = GenerateWorkbook(pivot);
// IWorkbookFormatProvider formatProvider = new CsvFormatProvider();
//formatProvider.Export(workbook, stream);
XlsxFormatProvider provider = new XlsxFormatProvider();
provider.Export(workbook, stream);
}
}
catch (IOException ex)
{
MessageBox.Show(ex.Message);
}
}
}
static void Main(string[] args)
{
Console.WriteLine("Hello, would you like to create a workbook? [Y/y][N/n]:");
var result = Console.ReadLine();
if (result?.ToLower() == "y")
{
Workbook workbook = new Workbook();
Worksheet worksheet = workbook.Worksheets.Add();
CellSelection selection = worksheet.Cells[1, 1]; //B2 cell
selection.SetValue("Hello RadSpreadProcessing");
string fileName = "SampleFile.xlsx";
IWorkbookFormatProvider formatProvider = new XlsxFormatProvider();
using Stream output = new FileStream(fileName, FileMode.Create);
formatProvider.Export(workbook, output);
Console.WriteLine("Done!");
}
}
private static Stream OpenStream(Workbook workbook)
{
IWorkbookFormatProvider formatProvider = new XlsxFormatProvider();
MemoryStream stream = new MemoryStream();
formatProvider.Export(workbook, stream);
return(stream);
}
private static void SaveWorkbook(Workbook workbook, Stream stream)
{
XlsxFormatProvider provider = new XlsxFormatProvider();
using (stream)
{
provider.Export(workbook, stream);
}
}
private void ExportXlsx()
{
#region radspreadsheet-model-import-export-xlsxformatprovider-wpf_1
Workbook workbook = new Workbook();
workbook.Worksheets.Add();
string fileName = "SampleFile.xlsx";
IWorkbookFormatProvider formatProvider = new XlsxFormatProvider();
using (FileStream output = new FileStream(fileName, FileMode.Create))
{
formatProvider.Export(workbook, output);
}
#endregion
}
private void ExportSpreadsheet()
{
#region radspreadprocessing-formats-and-conversion-xlsx-xlsxformatprovider_1
Workbook workbook = new Workbook();
workbook.Worksheets.Add();
string fileName = "SampleFile.xlsx";
IWorkbookFormatProvider formatProvider = new XlsxFormatProvider();
using (FileStream output = new FileStream(fileName, FileMode.Create))
{
formatProvider.Export(workbook, output);
}
#endregion
}
private void SaveFile_Click(object sender, EventArgs e)
{
SaveFileDialog sfd = new SaveFileDialog();
XlsxFormatProvider formatProvider = new XlsxFormatProvider();
sfd.Filter = "Excel Workbook (*xlsx)|*.xlsx|All Files (*.*)|*.*";
if (sfd.ShowDialog() == true)
{
using (Stream output = sfd.OpenFile())
{
formatProvider.Export(this.radSpreadsheet.Workbook, output);
}
}
}
protected void btnExportXLSX_Click(object sender, EventArgs e)
{
IWorkbookFormatProvider formatProvider = new XlsxFormatProvider();
Workbook workbook = createWorkbook();
byte[] renderedBytes = null;
using (MemoryStream ms = new MemoryStream()) {
formatProvider.Export(workbook, ms);
renderedBytes = ms.ToArray();
}
Response.ClearHeaders();
Response.ClearContent();
Response.AppendHeader("content-disposition", "attachment; filename=DYEP-RT-Report-" + DateTime.Now.ToString("dd-MM-yyyy") + ".xlsx");
Response.ContentType = "application/vnd.openxmlformats-officedocument.spreadsheetml.sheet";
Response.BinaryWrite(renderedBytes);
Response.End();
}
private void exportBtn_Click(object sender, EventArgs e)
{
var saveFileDialog = new SaveFileDialog();
saveFileDialog.InitialDirectory = Environment.GetFolderPath(Environment.SpecialFolder.MyDocuments);
saveFileDialog.ValidateNames = true;
saveFileDialog.DereferenceLinks = false;
saveFileDialog.Filter = "Excel |*.xlsx";
if (saveFileDialog.ShowDialog() == DialogResult.OK)
{
using (Stream output = new FileStream(saveFileDialog.FileName, FileMode.Create))
{
_formatProvider.Export(this.radSpreadsheet1.Workbook, output);
}
}
}
public void ExportWorkbookToXlsx()
{
#region radspreadsheet-model-import-export-xlsxformatprovider-silverlight_2
Workbook workbook = new Workbook();
workbook.Worksheets.Add();
SaveFileDialog saveFileDialog = new SaveFileDialog();
IWorkbookFormatProvider formatProvider = new XlsxFormatProvider();
saveFileDialog.Filter = "Excel Workbook (*.xlsx)|*.xlsx|All Files (*.*)|*.*";
if (saveFileDialog.ShowDialog() == true)
{
using (Stream output = saveFileDialog.OpenFile())
{
formatProvider.Export(workbook, output);
}
}
#endregion
}
protected virtual void ExportButton_Click(object sender, EventArgs e)
{
if (this.gridControl.MasterViewInfo.IsWaiting)
{
RadMessageBox.Show("The Data is not loaded! Please wait!");
return;
}
SaveFileDialog savefile = new SaveFileDialog();
savefile.FileName = "Document.xlsx";
savefile.Filter = "Excel files (*.xlsx)|*.xlsx|All files (*.*)|*.*";
if (savefile.ShowDialog() == DialogResult.OK)
{
var formatProvider = new XlsxFormatProvider();
using (Stream output = new FileStream(savefile.FileName, FileMode.Create))
{
formatProvider.Export(CreateWorkbook(), output);
}
}
}
public static void Export(this RadGridView grid, ExportSettings settings)
{
var dialog = new SaveFileDialog();
switch (settings.Format)
{
case ExportFormat.Pdf:
dialog.DefaultExt = "*.pdf";
dialog.Filter = "Adobe PDF 文档 (*.pdf)|*.pdf";
break;
case ExportFormat.Excel:
dialog.DefaultExt = "*.xlsx";
dialog.Filter = "Excel 工作簿 (*.xlsx)|*.xlsx";
break;
case ExportFormat.Word:
dialog.DefaultExt = "*.docx";
dialog.Filter = "Word 文档 (*.docx)|*.docx";
break;
case ExportFormat.Csv:
dialog.DefaultExt = "*.csv";
dialog.Filter = "CSV (逗号分隔) (*.csv)|*.csv";
break;
}
if (settings.FileName != null)
{
dialog.DefaultFileName = settings.FileName;
}
if (dialog.ShowDialog() == true)
{
switch (settings.Format)
{
case ExportFormat.Csv:
using (var output = dialog.OpenFile())
{
grid.Export(output, new GridViewExportOptions
{
Format = Telerik.Windows.Controls.ExportFormat.Csv,
ShowColumnFooters = grid.ShowColumnFooters,
ShowColumnHeaders = grid.ShowColumnHeaders,
ShowGroupFooters = grid.ShowGroupFooters
});
}
break;
case ExportFormat.Excel:
{
var workbook = CreateWorkBook(grid);
if (workbook != null)
{
var provider = new XlsxFormatProvider();
using (var output = dialog.OpenFile())
{
provider.Export(workbook, output);
}
}
}
break;
default:
{
var document = CreateDocument(grid, settings);
if (document != null)
{
document.LayoutMode = DocumentLayoutMode.Paged;
document.Measure(RadDocument.MAX_DOCUMENT_SIZE);
document.Arrange(new RectangleF(PointF.Empty, document.DesiredSize));
IDocumentFormatProvider provider = null;
switch (settings.Format)
{
case ExportFormat.Pdf:
provider = new PdfFormatProvider();
break;
case ExportFormat.Word:
provider = new DocxFormatProvider();
break;
}
using (var output = dialog.OpenFile())
{
if (provider != null) provider.Export(document, output);
}
}
}
break;
}
}
}
public static void Export(this RadGridView grid, ExportSettings settings)
{
var dialog = new SaveFileDialog();
if (settings.Format == ExportFormat.Pdf)
{
dialog.DefaultExt = "*.pdf";
dialog.Filter = "Adobe PDF Document (*.pdf)|*.pdf";
}
else if (settings.Format == ExportFormat.Excel)
{
dialog.DefaultExt = "*.xlsx";
dialog.Filter = "Excel Workbook (*.xlsx)|*.xlsx";
}
else if (settings.Format == ExportFormat.Word)
{
dialog.DefaultExt = "*.docx";
dialog.Filter = "Word Document (*.docx)|*.docx";
}
else if (settings.Format == ExportFormat.Csv)
{
dialog.DefaultExt = "*.csv";
dialog.Filter = "CSV (Comma delimited) (*.csv)|*.csv";
}
if (dialog.ShowDialog() == true)
{
if (settings.Format == ExportFormat.Csv)
{
using (var output = dialog.OpenFile())
{
grid.Export(output, new GridViewExportOptions()
{
Format = Telerik.Windows.Controls.ExportFormat.Csv,
ShowColumnFooters = grid.ShowColumnFooters,
ShowColumnHeaders = grid.ShowColumnHeaders,
ShowGroupFooters = grid.ShowGroupFooters
});
}
}
else
{
if (settings.Format == ExportFormat.Excel)
{
var workbook = CreateWorkBook(grid, settings);
if (workbook != null)
{
var provider = new XlsxFormatProvider();
using (var output = dialog.OpenFile())
{
provider.Export(workbook, output);
}
}
}
else
{
var document = CreateDocument(grid, settings);
if (document != null)
{
document.LayoutMode = DocumentLayoutMode.Paged;
document.Measure(RadDocument.MAX_DOCUMENT_SIZE);
document.Arrange(new RectangleF(PointF.Empty, document.DesiredSize));
IDocumentFormatProvider provider = null;
if (settings.Format == ExportFormat.Pdf)
{
provider = new PdfFormatProvider();
}
else if (settings.Format == ExportFormat.Word)
{
provider = new DocxFormatProvider();
}
using (var output = dialog.OpenFile())
{
provider.Export(document, output);
}
}
}
}
}
}
/// <summary>
/// Lancement de l'export Excel
/// </summary>
/// <param name="parameter"></param>
public void ExportExcel(object parameter)
{
SaveFileDialog dialog = new SaveFileDialog();
dialog.DefaultExt = "*.xlsx";
dialog.Filter = string.Format("{1} files (*.{0})|*.{0}|All files (*.*)|*.*", "xlsx", "Excel");
if (dialog.ShowDialog() == true)
{
//Récupération du DataPager pour imprimer toute la grid sans la pagination
bool paged = ExportAndPrintHelper.GetParameterAtIndex(parameter, ExportAndPrintHelper.RadDataPagerIndex) != null && ExportAndPrintHelper.GetParameterAtIndex(parameter, ExportAndPrintHelper.RadDataPagerIndex) is RadDataPager;
RadDataPager pager = paged ? (RadDataPager)ExportAndPrintHelper.GetParameterAtIndex(parameter, ExportAndPrintHelper.RadDataPagerIndex) : null;
int originalPageSize = 0;
int originalPageIndex = 0;
if (paged)
{
originalPageSize = pager.PageSize;
originalPageIndex = pager.PageIndex;
pager.PageSize = 0;
}
try
{
RadGridView grid = ExportAndPrintHelper.InverseVisibilityColumnsToExport(parameter,
ExportAndPrintHelper.ColumnsToExportIndex, ExportAndPrintHelper.RadGridViewIndex);
var workbook = ExportAndPrintHelper.CreateWorkBook(grid);
if (workbook != null)
{
XlsxFormatProvider provider = new XlsxFormatProvider();
using (Stream output = dialog.OpenFile())
{
provider.Export(workbook, output);
}
}
}
catch (OutOfMemoryException ex)
{
throw ex;
}
catch (IOException ex)
{
throw ex;
}
catch (Exception ex)
{
throw ex;
}
finally
{
if (paged)
{
pager.PageSize = originalPageSize;
pager.PageIndex = originalPageIndex;
}
ExportAndPrintHelper.InverseVisibilityColumnsToExport(parameter,
ExportAndPrintHelper.ColumnsToExportIndex, ExportAndPrintHelper.RadGridViewIndex);
}
}
}
private void Export_Click(object sender, RoutedEventArgs e)
{
if (SelectedVertex.Type != VertexType.Interval)
{
MessageBox.Show("Mean is undefined for non-interval type node [{0}]." + SelectedVertex);
return;
}
var workbook = new Workbook();
var worksheet = workbook.Worksheets.Add();
worksheet.Name = this.SelectedVertex.Key;
var template = new WorkSheetTemplate(worksheet);
template.AddColumn("From", 0, 1);
template.AddColumn("To", 0, 1);
template.AddColumn("Mean", 0, this.Table.DateTimes.Count());
template.AddColumn("Stdv", 0, this.Table.DateTimes.Count());
var requiredPercentileList = new List <double>();
if (!string.IsNullOrWhiteSpace(requiredPercentiles))
{
var parts = requiredPercentiles.Trim().Split("(),: ".ToCharArray(), StringSplitOptions.RemoveEmptyEntries);
foreach (var part in parts)
{
double value;
if (double.TryParse(part, out value))
{
requiredPercentileList.Add(value);
}
}
}
requiredPercentileList.ForEach(val => template.AddColumn(val.ToString(), 0, this.Table.DateTimes.Count()));
foreach (var kvp in template.GetColumns())
{
if (kvp.Key == "From" || kvp.Key == "To")
{
continue;
}
foreach (var dateTime in this.Table.DateTimes)
{
template.AddSubColumn(kvp.Key, dateTime.ToShortDateString(), 1, 1);
}
}
var noOfDateTimes = this.Table.DateTimes.Count();
var evidenceRowCount = this.BeliefsData.Values[0].Count;
for (var row = 0; row < evidenceRowCount; row++)
{
worksheet.Cells[row + 2, 0].SetValue(this.BeliefsData[this.SelectedVertex.Key][row]["From"].ToString());
worksheet.Cells[row + 2, 1].SetValue(this.BeliefsData[this.SelectedVertex.Key][row]["To"].ToString());
for (var dateTime = 0; dateTime < noOfDateTimes; dateTime++)
{
var colName = this.Table.DateTimes.ToList()[dateTime].String();
var evidence = (this.BeliefsData[this.SelectedVertex.Key][row][colName] as VertexEvidence);
var beliefValue = evidence.Value;
var mean = selectedVertex.Mean(beliefValue);
var stdv = selectedVertex.StandardDeviation(beliefValue);
var percentiles = requiredPercentileList.Select(val => new VertexPercentileComputer(val).Compute(this.Network.Vertices[this.SelectedVertex.Key], beliefValue)).ToList();
worksheet.Cells[row + 2, template.GetSubColumnPosition("Mean", row + 2)].SetValue(mean);
worksheet.Cells[row + 2, template.GetSubColumnPosition("Stdv", row + 2)].SetValue(stdv);
requiredPercentileList.ForEach((val, i) => worksheet.Cells[row + 2, template.GetSubColumnPosition(val.ToString(), row + 2)].SetValue(percentiles[i]));
}
}
var dialog = new SaveFileDialog
{
Filter = Common.LineData.FileDescription + "|*." + "xlsx",
};
var result = dialog.ShowDialog();
if (result != true)
{
return;
}
IWorkbookFormatProvider formatProvider = new XlsxFormatProvider();
using (var output = new FileStream(dialog.FileName, FileMode.Create))
{
formatProvider.Export(workbook, output);
}
}
private static void SaveWorkbook(Workbook workbook, Stream stream)
{
XlsxFormatProvider provider = new XlsxFormatProvider();
using (stream)
{
provider.Export(workbook, stream);
}
}
private void ExportToExcel()
{
this.BusyIndicator.IsBusy = true;
SaveFileDialog dialog = new SaveFileDialog();
dialog.DefaultExt = "xlsx";
dialog.Filter = "Excel Workbook (xlsx) | *.xlsx |All Files (*.*) | *.*";
var result = dialog.ShowDialog();
if ((bool)result)
{
try
{
using (var stream = dialog.OpenFile())
{
var workbook = GenerateWorkbook();
XlsxFormatProvider provider = new XlsxFormatProvider();
provider.Export(workbook, stream);
}
}
catch (IOException ex)
{
MessageBox.Show(ex.Message);
}
}
this.BusyIndicator.IsBusy = false;
}