Interactively Copy a Range from a spreadsheet

Thread ID:	Created:	Updated:	Platform:	Replies:
150909	Jan 24,2020 01:20 AM UTC	Jan 27,2020 09:12 AM UTC	WinForms	3

Subscribe to this post

Tags: Spreadsheet

Spotty

Asked On January 24, 2020 01:20 AM UTC

Im looking to select a specific range from a spreadsheet and copy the content so that it can be pasted into an Excel sheet

Preferably not show to make the selection visible but to copy it to the clipboard so its ready to paste into excel.

I know the rows/columns of the cells i need to select

Reply | Reply with quote

Arulpriya Ramalingam [Syncfusion]

Replied On January 24, 2020 08:31 AM UTC

Hi Spotty,

Thank you using Syncfusion products.

In order to copy the content in Spreadsheet cells, the Copy() method of CopyPaste property can be used. We already provided a user guide document to achieve this scenario and please make use of below code and UG.

Example code

//To perform copy operation for selected ranges

GridRangeInfo range = spreadsheet.ActiveGrid.SelectedRanges.ActiveRange;

spreadsheet.CopyPaste.Copy(range, false);

//To perform Copy operation

spreadsheet.CopyPaste.Copy();

UG link: https://help.syncfusion.com/windowsforms/spreadsheet/interactive-features#clipboard-operations

Please get back to us, if you have any other queries.

Regards,

Arulpriya

Reply | Reply with quote

Spotty

Replied On January 24, 2020 12:51 PM UTC

This assumes that I have manually selected the range and its active.

What if I want to select a range of cells programmatically but not make this visible to the UI.

The purpose is that I want to take data from the spreadsheet - copy it to another hidden sheet where I manipulate the data into a different format and then select the massaged data to copy to the clipboard.

So I really don't want to make the selection on the original spreadsheet obvious to the user.

Reply | Reply with quote

Kanimozhi Bharathi [Syncfusion]

Replied On January 27, 2020 09:12 AM UTC

Hi Spotty,

You can achieve your requirement by making the copied range as GridRangeInfo type and pass it to Copy method of SpreadsheetCopyPaste class. Please find the code example for reference,

spreadsheet.WorkbookLoaded += Spreadsheet_WorkbookLoaded;

private void Spreadsheet_WorkbookLoaded(object sender, WorkbookLoadedEventArgs args)

{

var range = GridRangeInfo.Cells(4, 5, 6, 6); //E4:F6

spreadsheet.CopyPaste.Copy(range, false);

}

Please let me know if you need any clarifications.

Regards

Kanimozhi B

Reply | Reply with quote

Interactively Copy a Range from a spreadsheet

Thread ID:

Created:

Updated:

Platform:

Replies:

Please sign in to access our forum

CONTACT US