Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
How to store custom data into Excel cell
Hello experts,
I'm writing a custom add-in for Excel. I need to store some custom data within Excel document/sheet/cell. Similar to "Web query" in Excel - when it is put in Excel sheet, it saves information about original URL and cells can be updated later. Similar to that, I would like to save some other information for each of the cells I will create from my add-in. For example: I would create 3 cells from my add-in and would like for each of those cells to save the information about some IDs, source of that cell (for example - file name) or anything else. It would be enough for me if I can save my string in any of the properties of Cell/Document/Sheet. It would be good enough to save it in a document or sheet because I can save it in XML or some other format and later deserialize it. What is important to me is that information have to be saved when user saves document and have to be available to my application when document is open next time. Is there anyone who know how this can be done? Which property can be used or can I use my custom class as a Cell property? Thanks in advance, Sasa |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Format Cell as custom type but data doesn't display like I custom. | Excel Discussion (Misc queries) | |||
Data Validation: Store cell address instead of value in the cell? | Excel Discussion (Misc queries) | |||
Store data from Windows Explorer in Excel | Excel Worksheet Functions | |||
Store Hidden Data in the Cell | Excel Programming | |||
Using controls in excel to store data | Excel Programming |