writing into an excel file

Hi I have an sql database and I need to do the following, hoping there are
some examples I can look at to impliment.
1. Copy an excel file on the server, just using a new name.
For example template.xls is an existing file on the server so the .net
application
would copy it on the server and name it new_day_year.xls.
2. insert data from an sql database (would first fill a dataset using a
stored procedure that would get data from an SQL database). I would need to
insert data into specific cells in the excel file (called new_day_year.xls)
from the.net application.
Thanks.
--
Paul G
Software engineer.

Re: writing into an excel file

Here are some great ways to create Excel output:
http://SteveOrr.net/articles/ExcelExport.aspx

Here's a free control that can help with Excel output (and Word, PowerPoint,
and WordPerfect output):
http://SteveOrr.net/articles/ExportPanel.aspx

Or You could open an existing Excel file and modify it as an ADO.NET data
source:
http://groups.google.com/group/microsoft.public.excel.progra mming/browse_thread/thread/f716314d90e974e5/571439ff12d7473d %23571439ff12d7473d

And here are a couple good 3rd party products that can make your chores
easy:
http://SteveOrr.net/reviews/AsposeExcel.aspx
http://SteveOrr.net/reviews/OfficeWriter.aspx

--
I hope this helps,
Steve C. Orr,
MCSD, MVP, CSM, ASPInsider
http://SteveOrr.net
http://iPhonePlaza.net

"Paul" wrote in message
news:12AAF55C-8FF3-4E2C-958C-14D8926804DA@microsoft.com...
> Hi I have an sql database and I need to do the following, hoping there are
> some examples I can look at to impliment.
> 1. Copy an excel file on the server, just using a new name.
> For example template.xls is an existing file on the server so the .net
> application
> would copy it on the server and name it new_day_year.xls.
> 2. insert data from an sql database (would first fill a dataset using a
> stored procedure that would get data from an SQL database). I would need
> to
> insert data into specific cells in the excel file (called
> new_day_year.xls)
> from the.net application.
> Thanks.
> --
> Paul G
> Software engineer.

Re: writing into an excel file

Hi thanks for the information. I am hoping to not run into any concurency
issues but expecting about
10-12 max users at one time and for each user they will be able to create
thier own report,
but all based off of the same template file.
--
Paul G
Software engineer.


"Steve C. Orr [MCSD, MVP, CSM, ASP Inside" wrote:

> Here are some great ways to create Excel output:
> http://SteveOrr.net/articles/ExcelExport.aspx
>
> Here's a free control that can help with Excel output (and Word, PowerPoint,
> and WordPerfect output):
> http://SteveOrr.net/articles/ExportPanel.aspx
>
> Or You could open an existing Excel file and modify it as an ADO.NET data
> source:
> http://groups.google.com/group/microsoft.public.excel.progra mming/browse_thread/thread/f716314d90e974e5/571439ff12d7473d %23571439ff12d7473d
>
> And here are a couple good 3rd party products that can make your chores
> easy:
> http://SteveOrr.net/reviews/AsposeExcel.aspx
> http://SteveOrr.net/reviews/OfficeWriter.aspx
>
> --
> I hope this helps,
> Steve C. Orr,
> MCSD, MVP, CSM, ASPInsider
> http://SteveOrr.net
> http://iPhonePlaza.net
>
> "Paul" wrote in message
> news:12AAF55C-8FF3-4E2C-958C-14D8926804DA@microsoft.com...
> > Hi I have an sql database and I need to do the following, hoping there are
> > some examples I can look at to impliment.
> > 1. Copy an excel file on the server, just using a new name.
> > For example template.xls is an existing file on the server so the .net
> > application
> > would copy it on the server and name it new_day_year.xls.
> > 2. insert data from an sql database (would first fill a dataset using a
> > stored procedure that would get data from an SQL database). I would need
> > to
> > insert data into specific cells in the excel file (called
> > new_day_year.xls)
> > from the.net application.
> > Thanks.
> > --
> > Paul G
> > Software engineer.
>

Re: writing into an excel file

You can also use a DTS package on the database to directly export your data
to an excel file.

"Paul" wrote in message
news:94CC397B-CC4A-4AFC-9C17-A78B6E35CFBC@microsoft.com...
> Hi thanks for the information. I am hoping to not run into any concurency
> issues but expecting about
> 10-12 max users at one time and for each user they will be able to create
> thier own report,
> but all based off of the same template file.
> --
> Paul G
> Software engineer.
>
>
> "Steve C. Orr [MCSD, MVP, CSM, ASP Inside" wrote:
>
>> Here are some great ways to create Excel output:
>> http://SteveOrr.net/articles/ExcelExport.aspx
>>
>> Here's a free control that can help with Excel output (and Word,
>> PowerPoint,
>> and WordPerfect output):
>> http://SteveOrr.net/articles/ExportPanel.aspx
>>
>> Or You could open an existing Excel file and modify it as an ADO.NET data
>> source:
>> http://groups.google.com/group/microsoft.public.excel.progra mming/browse_thread/thread/f716314d90e974e5/571439ff12d7473d %23571439ff12d7473d
>>
>> And here are a couple good 3rd party products that can make your chores
>> easy:
>> http://SteveOrr.net/reviews/AsposeExcel.aspx
>> http://SteveOrr.net/reviews/OfficeWriter.aspx
>>
>> --
>> I hope this helps,
>> Steve C. Orr,
>> MCSD, MVP, CSM, ASPInsider
>> http://SteveOrr.net
>> http://iPhonePlaza.net
>>
>> "Paul" wrote in message
>> news:12AAF55C-8FF3-4E2C-958C-14D8926804DA@microsoft.com...
>> > Hi I have an sql database and I need to do the following, hoping there
>> > are
>> > some examples I can look at to impliment.
>> > 1. Copy an excel file on the server, just using a new name.
>> > For example template.xls is an existing file on the server so the .net
>> > application
>> > would copy it on the server and name it new_day_year.xls.
>> > 2. insert data from an sql database (would first fill a dataset using
>> > a
>> > stored procedure that would get data from an SQL database). I would
>> > need
>> > to
>> > insert data into specific cells in the excel file (called
>> > new_day_year.xls)
>> > from the.net application.
>> > Thanks.
>> > --
>> > Paul G
>> > Software engineer.
>>