private void ExportToExcel_Clicked(object sender, EventArgs e)
{
isExporting = true;
DataGridExcelExportingController excelExport = new DataGridExcelExportingController();
DataGridExcelExportingOption exportOption = new DataGridExcelExportingOption();
if (Device.OS == TargetPlatform.iOS)
{
exportOption.ExportColumnWidth = false;
exportOption.DefaultColumnWidth = 150;
}
var excelEngine = excelExport.ExportToExcel(this.dataGrid, exportOption);
var workbook = excelEngine.Excel.Workbooks[0];
MemoryStream stream = new MemoryStream();
workbook.SaveAs(stream);
workbook.Close();
excelEngine.Dispose();
if (Device.OS == TargetPlatform.WinPhone || Device.OS == TargetPlatform.Windows)
{
Xamarin.Forms.DependencyService.Get <ISaveWindowsPhone>().Save("DataGrid.xlsx", "application/msexcel", stream);
}
else
{
Xamarin.Forms.DependencyService.Get <ISave>().Save("DataGrid.xlsx", "application/msexcel", stream);
}
}
private void ExportToExcel(object sender, EventArgs e)
{
DataGridExcelExportingController excelExport = new DataGridExcelExportingController();
var excelEngine = excelExport.ExportToExcel(this.SfGrid , new DataGridExcelExportingOption() {ExportRowHeight = false,ExportColumnWidth = false , DefaultColumnWidth = 100, DefaultRowHeight = 60});
var workbook = excelEngine.Excel.Workbooks[0];
MemoryStream stream = new MemoryStream();
workbook.SaveAs(stream);
workbook.Close();
excelEngine.Dispose();
Save("DataGrid.xlsx", "application/msexcel", stream);
}
public void ExportStatisticsData(SfDataGrid dataGrid)
{
DataGridExcelExportingController excelExport = new DataGridExcelExportingController();
var excelEngine = excelExport.ExportToExcel(dataGrid);
var workbook = excelEngine.Excel.Workbooks[0];
MemoryStream stream = new MemoryStream();
workbook.SaveAs(stream);
workbook.Close();
excelEngine.Dispose();
DependencyService.Get <ISave>().Save("LoanCalculator.xlsx", "application/msexcel", stream);
}
private void ExportToExcel(object sender, EventArgs e)
{
DataGridExcelExportingController excelExport = new DataGridExcelExportingController();
var excelEngine = excelExport.ExportToExcel(this.SfGrid, new DataGridExcelExportingOption()
{
ExportRowHeight = false, ExportColumnWidth = false, DefaultColumnWidth = 100, DefaultRowHeight = 60
});
var workbook = excelEngine.Excel.Workbooks[0];
MemoryStream stream = new MemoryStream();
workbook.SaveAs(stream);
workbook.Close();
excelEngine.Dispose();
Save("DataGrid.xlsx", "application/msexcel", stream);
}
private void ExportToExcel() // https://help.syncfusion.com/xamarin-android/sfdatagrid/exporting
{
DataGridExcelExportingController excelExport = new DataGridExcelExportingController();
var excelEngine = excelExport.ExportToExcel(TableData, new DataGridExcelExportingOption()
{
ExportRowHeight = false,
ExportColumnWidth = false,
DefaultColumnWidth = 100,
DefaultRowHeight = 60
});
var workbook = excelEngine.Excel.Workbooks[0];
MemoryStream stream = new MemoryStream();
workbook.SaveAs(stream);
workbook.Close();
excelEngine.Dispose();
Save($"{(MainActivity.SpinnerPos == (int)MainActivity.AnalysisType.OneDA ? "OneDA" : "RegrCorA")}_Table",
"application/msexcel", stream, TableData.Context);
}
private void ExportToExcel()
{
isExporting = true;
DataGridExcelExportingController excelExport = new DataGridExcelExportingController();
DataGridExcelExportingOption exportOption = new DataGridExcelExportingOption();
if(Device.OS == TargetPlatform.iOS)
{
exportOption.ExportColumnWidth = false;
exportOption.DefaultColumnWidth = 150;
}
var excelEngine = excelExport.ExportToExcel(this.dataGrid,exportOption);
var workbook = excelEngine.Excel.Workbooks[0];
MemoryStream stream = new MemoryStream();
workbook.SaveAs(stream);
workbook.Close();
excelEngine.Dispose();
if (Device.OS == TargetPlatform.WinPhone || Device.OS == TargetPlatform.Windows)
Xamarin.Forms.DependencyService.Get<ISaveWindowsPhone>().Save("DataGrid.xlsx", "application/msexcel", stream);
else
Xamarin.Forms.DependencyService.Get<ISave>().Save("DataGrid.xlsx", "application/msexcel", stream);
}
/// <summary>
/// Export the DataGrid to Excel
/// </summary>
/// <param name="obj">object type parameter</param>
private void ExportToExcel(object obj)
{
DataGridExcelExportingController excelExport = new DataGridExcelExportingController();
DataGridExcelExportingOption exportOption = new DataGridExcelExportingOption();
if (Device.RuntimePlatform == Device.iOS)
{
exportOption.ExportColumnWidth = true;
}
var excelEngine = excelExport.ExportToExcel(this.dataGrid, exportOption);
if (excelEngine == null)
{
return;
}
var workbook = excelEngine.Excel.Workbooks[0];
if (workbook == null)
{
return;
}
MemoryStream stream = new MemoryStream();
workbook.SaveAs(stream);
workbook.Close();
excelEngine.Dispose();
if (Device.RuntimePlatform == Device.UWP)
{
Xamarin.Forms.DependencyService.Get <ISaveWindowsPhone>().Save("DataGrid.xlsx", "application/msexcel", stream);
}
else
{
Xamarin.Forms.DependencyService.Get <ISave>().Save("DataGrid.xlsx", "application/msexcel", stream);
}
}
