copy xls cells info into structure

[Eran.Yasso]

Hi,

I have a structure which has 4 memebers.
I also have xls file which has 4 columns and x rows.
I need to copy each column to a member in the struct.
After that to add the struct to the stack and copy the next row.

I already knows how to insert to stack. all i need to know is how to
copy cells contetnt one by one and put it in struct members.

Writing to xls file would be great also.

TIA.

 

[Eran.Yasso]

You will need to look at Excel control through COM Automation. put this into
google and you'll get good samples. This is only for client applications
where excel is allowed to be made visible. If its for server side processing
then you need to get a 3rd party component for reading the xl file format or
get the user to save it to csv, them use a normal stream.

I don't excel to be visible. I need it to be invisible. I copy from and
to gridview.