Manipulate ExcelRange

Add-in Express™ Support Service
That's what is more important than anything else

Manipulate ExcelRange
How to save, store... 
Michał Głębowski




Posts: 42
Joined: 2015-06-08
Dear Sirs,

Is there any way to save ExcelRange for later use?
I mean sth. ExcelRange.SaveToFile.
To be able to restore values and formatting later with ExcelRange.LoadFromFile.

Michal
Posted 27 Jul, 2015 08:44:10 Top
Andrei Smolin


Add-in Express team


Posts: 14140
Joined: 2006-05-11
Hello Michał,

You can use Range.Value to get (and set) an array of cell values. Please find some details at https://www.add-in-express.com/creating-addins-blog/2011/09/29/excel-read-update-cells/.

Regards from Belarus (GMT+3),

Andrei Smolin
Add-in Express Team Leader
Posted 27 Jul, 2015 09:12:42 Top
Michał Głębowski




Posts: 42
Joined: 2015-06-08
Dear Andrei,

Your link directs to samples in C# and VB.NET. In code there is assignment to string array. I use delphi and code:


ClipArr: array of array of String;
(...)
ARange := AWindow.RangeSelection;
ClipArr := ARange.Value;

does not work.

And one more question: does your code copies also cells formatting or only values (text/formulas)?

Michal
Posted 27 Jul, 2015 15:46:17 Top
Andrei Smolin


Add-in Express team


Posts: 14140
Joined: 2006-05-11
Hello Michał,

The Range.Value property is described at https://msdn.microsoft.com/en-us/library/office/ff195193%28v=office.15%29.aspx. I've found a Delphi example at http://www.delphigroups.info/2/9/1015688.html.

This property returns an array of cell values; formatting isn't included. To retrieve formatting, you'll need to scan every cell and use the properties providing the required information.

Regards from Belarus (GMT+3),

Andrei Smolin
Add-in Express Team Leader
Posted 28 Jul, 2015 05:20:32 Top
Michał Głębowski




Posts: 42
Joined: 2015-06-08
Thank you Andrei for your hint. I coped with problem copying range to system clipboard and then using either HTML or rtf format to store formatting. Works perfectly.
Posted 09 Aug, 2015 05:32:39 Top
Andrei Smolin


Add-in Express team


Posts: 14140
Joined: 2006-05-11
Thank you for letting me know.

Regards from Belarus (GMT+3),

Andrei Smolin
Add-in Express Team Leader
Posted 10 Aug, 2015 02:12:04 Top