MetaData in an Excel Cell

Question

Hi,

i have a question. is there any way to save more than one Information in only ONE Excel Cell?  i.e. Table_id, Subject, other Strings,.... like MetaData

I have a Table with lots of Entries, like a Database and i want to Insert them into an excel sheet. But i dont need only the values of the columns. I also need some more imformations and i asked me if i can save the "more Information" and the Value in one Cell.

I know i can save some Infomation in the Cell Formula, but i think the performance is more than bad if i read information out of the FormulaString from a list of over 1000 enties.

Have some Idea??
 

Answer 1

How do u mean this ??
i dont want to use the Excel Formular zu add some Date in the Cell. so how do u mean this "use "||" to separate"

rg.Cells[2, 2] = 15 || 16;  ???

or how u mean this?
 
sorry im a noob at excel Programming :(

Answer 2

yes you can save data...use "||" separator string for saving data