How to use Excel "Function Argument" Dialog in C#.net.

Question

I would like to take the function name, Argument name and value from Excel cell using c#.net
 

Answer 1

The SoapFormatter class can only serialize objects that could have been created with .NET 1.1.

As generic types were not introduced until .NET 2.0, they cannot therefore be serialized.

If you're trying to serialize a List<T>, then you could use an ArrayList instead or, if you're trying to serialize a generic Dictionary then you could use a Hashset.

Otherwise, I'd use the BinaryFormatter instead.