Hi,
i have a senario like i need to generate excel sheets by
getting certain columns into a grid quried from db
and iam generating a set of files by dividing the records so queried to the grid
set of records are writing to excel based on certain grouping criteria
i.e. suppose my app is generated 5 excel files
step one
Emp No Emp Name Dept age exp
1001, VIKRAM, D1, 20, 2
1014, PRUTHVI, D1, 34, 14
1015, MADHU, D1, 40, 16
1002, RAJU, D4, 30, 11
1004, SAGAR, D4, 19, 1
1007, LAVANYA, D4, 36, 13
1011, RAKESH, D4, 32, 7
1005, RAKESH, D5, 23, 3
1009, PADMA, D5, 20, 2
1013, ANOOSH, D5, 23, 5
1003, SUMAN, D6, 32, 19
1006, RAJENDER, D6, 45, 18
1008, ANUSHA, D6, 34, 13
1010, SHIVAKUMAR, D6, 30, 6
1012, SALMAN, D6, 19, 2
suppose the above data is generated 4 files based on "DEPT"
with file names
02Apr2011_D1_1.xls with 3 records
02Apr2011_D4_1.xls with 4 records
02Apr2011_D5_1.xls with 3 records
02Apr2011_D6_1.xls with 5 records
respectively
and suppose
my proj is in
c:\inetpub\wwwroot\EmpReports\
and the files so generated using COM class library
are generated in below location
c:\inetpub\wwwroot\EmpReports\UploadFiles\EmpDownload\
now MY Question is how to provide a means
to generate these files and get these files
to the local location from where(some machine in local network or in internet) the application is browsing thru url.