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.
3  1862 
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/micro...1439ff12d7473d
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" <Pa**@discussions.microsoft.comwrote in message
news:12**********************************@microsof t.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.
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/micro...1439ff12d7473d
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" <Pa**@discussions.microsoft.comwrote in message
news:12**********************************@microsof t.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.
You can also use a DTS package on the database to directly export your data
to an excel file.
"Paul" <Pa**@discussions.microsoft.comwrote in message
news:94**********************************@microsof t.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/micro...1439ff12d7473d
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" <Pa**@discussions.microsoft.comwrote in message
news:12**********************************@microso ft.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.
This thread has been closed and replies have been disabled. Please start a new discussion. Similar topics
by: Deepa |
last post by:
I am writing a console app in c# wherein am converting a dataset into a CSV
file. It works fine. But I have some values in the dataset which have a comma
within(eg. A,B,C). When I view the CSV file...
|
by: Paul |
last post by:
I was wondering if anyone has had an issue where using vba code to
read an excel file and import the data into an access table some
records are not imported from the excel file. It seems looking at...
|
by: Tomas Vera |
last post by:
Hello All,
I'm having trouble writing some special characters to an XML file.
I need to output a XMLSS formatted file to be read by Excel.
In some cells there will be some text that contains...
|
by: RJN |
last post by:
Hi
I've a template excel file which has all the calculations defined. There
are certain input values to be entered which gives a lot of output to
the user. I don't want to expose the excel sheet...
|
by: RahimAsif |
last post by:
I am designing a data acquisition program that peridically collects
data from a panel and writes to a file. The way I am doing it right
now, every time I have data from the panel, I open the file,...
|
by: arvind1083 |
last post by:
I need help for writing a excel file.
As in one excel file there could be more than one sheets so I want to know how can I give name to different sheets and select a particular sheet for writing or...
|
by: shintu |
last post by:
Hallo,
I am trying to write french accented characters é è ê in Excel worksheet using my perl script , But I am stuck here as I couldnt find a way of writing it !:
My code:
use strict;...
|
by: thanawala27 |
last post by:
Hi,
I had problems writing in an existing Excel File.
There is an excel file with a worksheet. I would like to open this existing Excel file and add another worksheet and write data into it....
|
by: =?Utf-8?B?ZmhpbGxpcG8=?= |
last post by:
We have a code snippet that downloads data to Excel. it is writing row by
row. This causes a performance issue. Any ideas on how to speed this up will
be appreciated.
Please find below an...
|
by: Marin Brkic |
last post by:
Hello all,
please, let me apologize in advance. English is not my first language
(not even my second one), so excuse any errors with which I'm about to
embarass myself in front of the general...
|
by: taylorcarr |
last post by:
A Canon printer is a smart device known for being advanced, efficient, and reliable. It is designed for home, office, and hybrid workspace use and can also be used for a variety of purposes. However,...
|
by: aa123db |
last post by:
Variable and constants
Use var or let for variables and const fror constants.
Var foo ='bar';
Let foo ='bar';const baz ='bar';
Functions
function $name$ ($parameters$) {
}
...
|
by: ryjfgjl |
last post by:
If we have dozens or hundreds of excel to import into the database, if we use the excel import function provided by database editors such as navicat, it will be extremely tedious and time-consuming...
|
by: ryjfgjl |
last post by:
In our work, we often receive Excel tables with data in the same format. If we want to analyze these data, it can be difficult to analyze them because the data is spread across multiple Excel files...
|
by: BarryA |
last post by:
What are the essential steps and strategies outlined in the Data Structures and Algorithms (DSA) roadmap for aspiring data scientists? How can individuals effectively utilize this roadmap to progress...
|
by: Sonnysonu |
last post by:
This is the data of csv file
1 2 3
1 2 3
1 2 3
1 2 3
2 3
2 3
3
the lengths should be different i have to store the data by column-wise with in the specific length.
suppose the i have to...
|
by: marktang |
last post by:
ONU (Optical Network Unit) is one of the key components for providing high-speed Internet services. Its primary function is to act as an endpoint device located at the user's premises. However,...
|
by: Oralloy |
last post by:
Hello folks,
I am unable to find appropriate documentation on the type promotion of bit-fields when using the generalised comparison operator "<=>".
The problem is that using the GNU compilers,...
|
by: jinu1996 |
last post by:
In today's digital age, having a compelling online presence is paramount for businesses aiming to thrive in a competitive landscape. At the heart of this digital strategy lies an intricately woven...
| |
