private void Btn_ExportarDatosINMContacto_Click(object sender, RoutedEventArgs e) // eventodel boton Exportar Excel que me permite exportar a un archivo excel. los datos que tengo en el DataGrid { try { grid_InmueblesPropietarios.SelectAllCells(); grid_InmueblesPropietarios.ClipboardCopyMode = DataGridClipboardCopyMode.IncludeHeader; ApplicationCommands.Copy.Execute(null, grid_InmueblesPropietarios); String resultat = (string)Clipboard.GetData(DataFormats.CommaSeparatedValue); String result = (string)Clipboard.GetData(DataFormats.Text); grid_InmueblesPropietarios.UnselectAllCells(); SaveFileDialog salvar_archivo = new SaveFileDialog(); //creando ventana de guardado salvar_archivo.Filter = "archivo xml|*.xls"; //filtro para la extencion como se puede guardar el archivo salvar_archivo.Title = "Guandar archivo excel"; //nombre de la ventana de guardado salvar_archivo.ShowDialog(); //abre la ventana de guardado if (salvar_archivo.FileName != "") { //System.IO.FileStream fileStream = (System.IO.FileStream)salvar_archivo.OpenFile(); System.IO.StreamWriter file1 = new System.IO.StreamWriter((System.IO.FileStream)salvar_archivo.OpenFile()); file1.WriteLine(result.Replace(',', ' ')); file1.Close(); } MessageBox.Show("se exportaron los datos correctamente"); } catch (Exception ex) { logger.Error("ERROR al exportar inmueblesfiltro-> {0}", ex.ToString()); MessageBox.Show("error exportar"); } }
private string GetClipboardContent() { if (WinClipboard.ContainsText()) { return(WinClipboard.GetText()); } // ReSharper disable once InvertIf if (WinClipboard.ContainsImage()) { MemoryStream imageStream = (MemoryStream)WinClipboard.GetData(DataFormats.Dib); BitmapSource imageBitmap = DibToBitmapConverter.Read(imageStream); if (imageBitmap == null) { Logger.Error("Unable to create bitmap from image copied into the clipboard!"); return(null); } using (MemoryStream rawImage = new MemoryStream()) { BitmapEncoder encoder = new PngBitmapEncoder(); encoder.Frames.Add(BitmapFrame.Create(imageBitmap)); encoder.Save(rawImage); return($"{pngImageHeader}{Convert.ToBase64String(rawImage.ToArray())}"); } } return(null); }
/// <summary> /// Executes the CSV export process /// </summary> /// <param name="sender"></param> /// <param name="e"></param> private void ExportButton_Click(object sender, RoutedEventArgs e) { try { // select all cells ResultGrid.SelectAllCells(); // copy data to clipboard ResultGrid.ClipboardCopyMode = DataGridClipboardCopyMode.IncludeHeader; ApplicationCommands.Copy.Execute(null, ResultGrid); // clipboard contains data... unselect all cells ResultGrid.UnselectAllCells(); // save data from clipboard to variable var result = (string)Clipboard.GetData(DataFormats.CommaSeparatedValue); // data is in variable, clear clipboard Clipboard.Clear(); // create a Save-File Dialog var sfd = new System.Windows.Forms.SaveFileDialog(); sfd.Filter = @"CSV files (*.csv)|*.csv"; // if dialog displayed successfully if (sfd.ShowDialog() == System.Windows.Forms.DialogResult.OK) { // write data to file using a StreamWriter var writer = new StreamWriter(sfd.OpenFile()); writer.WriteLine(result); writer.Close(); MessageBox.Show("CSV Export complete"); } } catch (Exception ex) { MessageBox.Show("CSV Export failed. \n" + ex.Message); Debug.WriteLine(ex); } }
private void ExportButton_Click(object sender, RoutedEventArgs e) { try { ResultGrid.SelectAllCells(); ResultGrid.ClipboardCopyMode = DataGridClipboardCopyMode.IncludeHeader; ApplicationCommands.Copy.Execute(null, ResultGrid); ResultGrid.UnselectAllCells(); var result = (string)Clipboard.GetData(DataFormats.CommaSeparatedValue); Clipboard.Clear(); var sfd = new System.Windows.Forms.SaveFileDialog(); sfd.Filter = @"CSV files (*.csv)|*.csv"; if (sfd.ShowDialog() == System.Windows.Forms.DialogResult.OK) { var writer = new StreamWriter(sfd.OpenFile()); writer.WriteLine(result); writer.Close(); } MessageBox.Show("CSV Export complete."); } catch (Exception ex) { MessageBox.Show("CSV Export failed. \n" + ex.Message); } }
public static bool TryGetLinkedWClipboardId(out Guid guid) { var guidObj = SysClipboard.GetData(LinkedWClipboardIdFormat); guid = guidObj is Guid guidCasted ? guidCasted : Guid.Empty; return(guid != Guid.Empty); }
private void SaveDataGridToExcel(string filename, DataGrid grid) { EnsureDirectoryExists(filename); grid.SelectAllCells(); grid.ClipboardCopyMode = DataGridClipboardCopyMode.IncludeHeader; ApplicationCommands.Copy.Execute(null, grid); String resultat = (string)Clipboard.GetData(DataFormats.CommaSeparatedValue); String result = (string)Clipboard.GetData(DataFormats.Text); grid.UnselectAllCells(); System.IO.StreamWriter file1 = new System.IO.StreamWriter(filename); file1.WriteLine(result.Replace(',', ' ')); file1.Close(); }
private string SaveReportInFile() { StringBuilder sb = new StringBuilder(); String result = ""; var replacedStr = ""; if (FormRow.Items.Count > 0) { FormRow.SelectAllCells(); FormRow.ClipboardCopyMode = DataGridClipboardCopyMode.IncludeHeader; ApplicationCommands.Copy.Execute(null, FormRow); CBlowingRow.UnselectAllCells(); result = (string)Clipboard.GetData(DataFormats.CommaSeparatedValue); // replacedStr = result.Replace(",", ";"); sb.Append(result); } if (BlowingRow.Items.Count > 0) { BlowingRow.SelectAllCells(); BlowingRow.ClipboardCopyMode = DataGridClipboardCopyMode.IncludeHeader; ApplicationCommands.Copy.Execute(null, BlowingRow); BlowingRow.UnselectAllCells(); result = (string)Clipboard.GetData(DataFormats.CommaSeparatedValue); replacedStr = result.Replace(",", ";"); sb.Append(replacedStr); } if (CBlowingRow.Items.Count > 0) { CBlowingRow.SelectAllCells(); CBlowingRow.ClipboardCopyMode = DataGridClipboardCopyMode.IncludeHeader; ApplicationCommands.Copy.Execute(null, CBlowingRow); CBlowingRow.UnselectAllCells(); result = (string)Clipboard.GetData(DataFormats.CommaSeparatedValue); replacedStr = result.Replace(",", ";"); sb.Append(replacedStr); } return(sb.ToString()); }
public void ClipboardToLayer() { if (!ActiveWindowHelper.MainWindowActive || !IsActive) { return; } try { GeneralHelpers.ExecuteSta(() => { var data = (string)Clipboard.GetData("layer"); if (data == null) { return; } var layerModel = JsonConvert.DeserializeObject <LayerModel>(data); if (layerModel == null) { return; } if (SelectedLayer != null) { SelectedLayer.InsertAfter(layerModel); } else { SelectedProfile.Layers.Add(layerModel); SelectedProfile.FixOrder(); } Execute.OnUIThread(() => UpdateLayerList(layerModel)); }); } catch (Exception) { // ignored } }
public DataPackageView GetContent() { var dataPackage = new DataPackage(); if (Clipboard.ContainsImage()) { dataPackage.SetDataProvider(StandardDataFormats.Bitmap, async ct => { var bitmap = Clipboard.GetImage(); var bitmapStream = new MemoryStream(); var bitmapEncoder = new BmpBitmapEncoder(); bitmapEncoder.Frames.Add(BitmapFrame.Create(bitmap)); bitmapEncoder.Save(bitmapStream); // Letting a MemoryStream run around does not cause problems. // The GC will take care of it, just like a byte[]. return(RandomAccessStreamReference.CreateFromStream(bitmapStream.AsRandomAccessStream())); }); } if (Clipboard.ContainsText()) { // Copying significant amounts of text still makes Clipboard.GetText() slow, so // we'll still use the SetDataProvider dataPackage.SetDataProvider(StandardDataFormats.Text, async ct => { return(Clipboard.GetText()); }); } if (Clipboard.ContainsData(DataFormats.Html)) { dataPackage.SetDataProvider(StandardDataFormats.Html, async ct => { return(Clipboard.GetData(DataFormats.Html)); }); } if (Clipboard.ContainsData(DataFormats.Rtf)) { dataPackage.SetDataProvider(StandardDataFormats.Rtf, async ct => { return(Clipboard.GetData(DataFormats.Rtf)); }); } if (Clipboard.ContainsFileDropList()) { dataPackage.SetDataProvider(StandardDataFormats.StorageItems, async ct => { var list = Clipboard.GetFileDropList(); var storageItemList = new List <IStorageItem>(list.Count); foreach (var path in list) { var attr = File.GetAttributes(path); if (attr.HasFlag(global::System.IO.FileAttributes.Directory)) { storageItemList.Add(await StorageFolder.GetFolderFromPathAsync(path)); } else { storageItemList.Add(await StorageFile.GetFileFromPathAsync(path)); } } return(storageItemList); }); } return(dataPackage.GetView()); }