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.

Ciaran O''Donnell wrote:
> 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.
>
>
> --
> Ciaran O''''Donnell
> http://wannabedeveloper.spaces.live.com
>
>
> "(E-Mail Removed)" wrote:
>
> > 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.
> >
> >

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