Free Trial
Web API version
Licensing
Request A Quote
HAVE QUESTIONS OR NEED HELP? SUBMIT THE SUPPORT REQUEST FORM or write email to SUPPORT@BYTESCOUT.COM
Copy Worksheet Data To Clipboard | C#
Program.cs:
C#
using Bytescout.Spreadsheet; using System; using System.IO; using System.Text; namespace CopyWorksheetDataToClipboard { class Program { [STAThreadAttribute] static void Main(string[] args) { // Spreadsheet document using (Spreadsheet document = new Spreadsheet()) { // Load Input File document.LoadFromFile("SimpleReport.xls"); // Create stream and export CSV data to stream MemoryStream ms = new MemoryStream(); document.Worksheets[0].SaveAsCSV(ms, "\t"); // Convert memory stream to string var tabSeparatedData = Encoding.UTF8.GetString(ms.ToArray()); // Copy data to clipboard System.Windows.Forms.Clipboard.SetText(tabSeparatedData); } Console.WriteLine("Data copied to clipboard!"); Console.ReadLine(); } } }