Is there any way to get multiple range in cellrange

[trehanson]

As question, I want to know is there any way to get multiple range in CellRange object like following:-

Since, I am doing a copy row function, but i need to copy the formula and style from the original row to multple range
xlSheet.InsertRow(wiStrRow, wiExpRow - 1);
CellRange waOrgRange = xlSheet.Range[xlSheet.Rows[wiStrRow].RangeAddress];
CellRange waNewRange = xlSheet.Range[xlSheet.Rows[wiStrRow].RangeAddress + "," + xlSheet.Rows[wiStrRow + wiExpRow - 1].RangeAddress];
xlSheet.Copy(waOrgRange, waNewRange);

Example, xlSheet.Range["A13:F13, A66:F66"], but it becomes error.

Anyone can tell me the correct syntax, Thanks a lot!

[Betsy.jiang]

Dear trehanson,

Thanks for your inquiry.
Sorry that at present Spire.XLS doesn't support do that. But in your case, you can use two Ranges to achieve your target, like this:

Code: Select all

xlSheet.Range["A13:F13"].
xlSheet.Range["A66:F66"].

If there is any question, please let me know.

Sincerely,
Betsy
E-iceblue support team

[trehanson]

Hi Betsy,

Thanks for reply.

[Betsy.jiang]

Dear trehanson,

Thanks for your feedback.
Please feel free to contact us if there is any question .

Sincerely,
Betsy
E-iceblue support team