>I am building an application to capture student data. This data will need to tie into the pre-formatted excel spreadsheet that the university already uses. So the first name, last name etc cells will always be A1 or A3 etc etc. The spreadsheet has (3) sheets to it.
>
>Any ideas on how I can tie the data into the spreadsheet given I know which cells the data should be bound to?
Hi Jeffrey
Have look at Rep2excel and/or CodeRep here in downloads.
They both contain rich automation class which you can use to easily poke values into
cells of excel template.
Class is made in such way that you manipulate excel as if it was 3d array.
So you can address and write any cell using Sheet>Row>Col as 'coordinate system'.
There are many methods there which make writing of excel sheet very easy. You can write entire array in one go, or spread delimited string across the range of cells, or write group of table records etc.
HTH
Sergio