473,326 Members | 2,173 Online
Bytes | Software Development & Data Engineering Community
Post Job

Home Posts Topics Members FAQ

Join Bytes to post your question to a community of 473,326 software developers and data experts.

Generate Excel reports in ASP.NET

I developed a reporting website using ASP.NET and Microsoft Office XP.
The reports are generated using Microsoft Excel. It works perfectly as
designed in the development environment.
I deployed it on production server, which has Microsoft Office 2003
installed. The site works perfectly, except that the excel reports do
not come up. No error message is displayed.
Is it an issue with Microsoft frontpage extension or could it be a
Microsoft Office version issue.
Any help is greatly appreciated.
Thanks
Nov 18 '05 #1
6 2463
check out
Subject RE: export datagrid data to Excel file within the
Dated 3rd April
microsoft.public.dotnet.framework.aspnet.dtagridco ntrol

"Rana" <sw*******@hotmail.com> wrote in message
news:d9**************************@posting.google.c om...
I developed a reporting website using ASP.NET and Microsoft Office XP.
The reports are generated using Microsoft Excel. It works perfectly as
designed in the development environment.
I deployed it on production server, which has Microsoft Office 2003
installed. The site works perfectly, except that the excel reports do
not come up. No error message is displayed.
Is it an issue with Microsoft frontpage extension or could it be a
Microsoft Office version issue.
Any help is greatly appreciated.
Thanks

Nov 18 '05 #2
check out
Subject RE: export datagrid data to Excel file within the
Dated 3rd April
microsoft.public.dotnet.framework.aspnet.dtagridco ntrol

"Rana" <sw*******@hotmail.com> wrote in message
news:d9**************************@posting.google.c om...
I developed a reporting website using ASP.NET and Microsoft Office XP.
The reports are generated using Microsoft Excel. It works perfectly as
designed in the development environment.
I deployed it on production server, which has Microsoft Office 2003
installed. The site works perfectly, except that the excel reports do
not come up. No error message is displayed.
Is it an issue with Microsoft frontpage extension or could it be a
Microsoft Office version issue.
Any help is greatly appreciated.
Thanks

Nov 18 '05 #3
Thanks Ian!!

I have used microsoft office web components to automate Excel. I have a
predefined excel template, which I populate using an XML file.

In the development environment I included refrences to Microsoft Office
XP. On the production server, Microsoft Office 2003 is installed. Could
the different version, be the cause for the report not being displayed
on the production box?

Should I uninstall Microsoft Office 2003 and install Microsoft Office XP
on the production server to bring up the report? Or is there some other
resolution? Could you please direct me to some sample code which use
microsoft office excel component.

Thanks!!

*** Sent via Developersdex http://www.developersdex.com ***
Don't just participate in USENET...get rewarded for it!
Nov 18 '05 #4
Thanks Ian!!

I have used microsoft office web components to automate Excel. I have a
predefined excel template, which I populate using an XML file.

In the development environment I included refrences to Microsoft Office
XP. On the production server, Microsoft Office 2003 is installed. Could
the different version, be the cause for the report not being displayed
on the production box?

Should I uninstall Microsoft Office 2003 and install Microsoft Office XP
on the production server to bring up the report? Or is there some other
resolution? Could you please direct me to some sample code which use
microsoft office excel component.

Thanks!!

*** Sent via Developersdex http://www.developersdex.com ***
Don't just participate in USENET...get rewarded for it!
Nov 18 '05 #5
Microsoft office 2003 is not related to the Office web components. The OWC
is a stand-alone component. office 2003 installs a readonly license for
owc10 and owc11 on the server. It does not install the owc components. Your
client needs to install the target version of the OWC. In addition, you will
need to run the setup program for owc10 on the server since it is
stand-alone, it doesn't get installed by default. It works on your machine
because you have installed the owc. Does this make sense? see my website for
more details
http://tinyurl.com/27cok

--
Regards,
Alvin Bruney [ASP.NET MVP]
Got tidbits? Get it here...
http://tinyurl.com/27cok
"Swati Rana" <sw*******@hotmail.com> wrote in message
news:uw**************@TK2MSFTNGP12.phx.gbl...
Thanks Ian!!

I have used microsoft office web components to automate Excel. I have a
predefined excel template, which I populate using an XML file.

In the development environment I included refrences to Microsoft Office
XP. On the production server, Microsoft Office 2003 is installed. Could
the different version, be the cause for the report not being displayed
on the production box?

Should I uninstall Microsoft Office 2003 and install Microsoft Office XP
on the production server to bring up the report? Or is there some other
resolution? Could you please direct me to some sample code which use
microsoft office excel component.

Thanks!!

*** Sent via Developersdex http://www.developersdex.com ***
Don't just participate in USENET...get rewarded for it!

Nov 18 '05 #6
Microsoft office 2003 is not related to the Office web components. The OWC
is a stand-alone component. office 2003 installs a readonly license for
owc10 and owc11 on the server. It does not install the owc components. Your
client needs to install the target version of the OWC. In addition, you will
need to run the setup program for owc10 on the server since it is
stand-alone, it doesn't get installed by default. It works on your machine
because you have installed the owc. Does this make sense? see my website for
more details
http://tinyurl.com/27cok

--
Regards,
Alvin Bruney [ASP.NET MVP]
Got tidbits? Get it here...
http://tinyurl.com/27cok
"Swati Rana" <sw*******@hotmail.com> wrote in message
news:uw**************@TK2MSFTNGP12.phx.gbl...
Thanks Ian!!

I have used microsoft office web components to automate Excel. I have a
predefined excel template, which I populate using an XML file.

In the development environment I included refrences to Microsoft Office
XP. On the production server, Microsoft Office 2003 is installed. Could
the different version, be the cause for the report not being displayed
on the production box?

Should I uninstall Microsoft Office 2003 and install Microsoft Office XP
on the production server to bring up the report? Or is there some other
resolution? Could you please direct me to some sample code which use
microsoft office excel component.

Thanks!!

*** Sent via Developersdex http://www.developersdex.com ***
Don't just participate in USENET...get rewarded for it!

Nov 18 '05 #7

This thread has been closed and replies have been disabled. Please start a new discussion.

Similar topics

2
by: hari krishna | last post by:
hi, I have a web control lybrary project. i have some classes. calling that component though asp.net web form. i am using visual basic for coding. my requirement is to generate xl reports without...
1
by: hari krishna | last post by:
Actually i am doing this through ASP.Net. My webserver is Win2000 server machine, IIS 5.0. my requirement is generte excel reports through asp.net. I have a sample code to access excel component...
3
by: jijo kuruvila | last post by:
How we can Dynamically generate a MS Word document using ASP.Net? -- Jijo kuruvila trivandrum,Kerala,India
3
by: Rana | last post by:
I developed a reporting website using ASP.NET and Microsoft Office XP. The reports are generated using Microsoft Excel. It works perfectly as designed in the development environment. I deployed it...
2
by: Martin Widmer | last post by:
Hi guys I am looking for the best way to generate new reports with reporting services for SQL server 2005. The reports will be generated programmatically from a .Net VB application. So far I see...
5
by: ken | last post by:
how ASP.NET to generate excel report(office 2003) to client what component i need to reference into the asp.net application and what component i need to install to the server? Moreover, does it...
1
by: badwal | last post by:
One of the requirements of our ASP.NET 2.0 web application (developed with visual studio 2005) is to create reports in form of excel spreadsheets with data coming from Sql Server 2005 database. ...
6
by: DeniseY | last post by:
I have an Access report that is created on the fly by the user selecting the fields to be included. The Access report comes out fine, but I want it to automatically output to an Excel spreadsheet....
10
by: dancer | last post by:
How can I save the results of a fill-in form to a Microsoft Excel spreadsheet? I can insert the results into an Access table, but the reports are so tedious to make from Access. Reports are very...
15
by: =?Utf-8?B?c2hhc2hhbmsga3Vsa2Fybmk=?= | last post by:
Hi All, We are in the process of Upgrade Excel 2003 (Office 2003) to Excel 2007 (Office 2007) for one of web application. This web application is using Excel (Pivot Table) reports. With Excel...
0
by: ryjfgjl | last post by:
ExcelToDatabase: batch import excel into database automatically...
0
isladogs
by: isladogs | last post by:
The next Access Europe meeting will be on Wednesday 6 Mar 2024 starting at 18:00 UK time (6PM UTC) and finishing at about 19:15 (7.15PM). In this month's session, we are pleased to welcome back...
0
by: jfyes | last post by:
As a hardware engineer, after seeing that CEIWEI recently released a new tool for Modbus RTU Over TCP/UDP filtering and monitoring, I actively went to its official website to take a look. It turned...
0
by: ArrayDB | last post by:
The error message I've encountered is; ERROR:root:Error generating model response: exception: access violation writing 0x0000000000005140, which seems to be indicative of an access violation...
1
by: PapaRatzi | last post by:
Hello, I am teaching myself MS Access forms design and Visual Basic. I've created a table to capture a list of Top 30 singles and forms to capture new entries. The final step is a form (unbound)...
1
by: CloudSolutions | last post by:
Introduction: For many beginners and individual users, requiring a credit card and email registration may pose a barrier when starting to use cloud servers. However, some cloud server providers now...
1
by: Defcon1945 | last post by:
I'm trying to learn Python using Pycharm but import shutil doesn't work
0
by: Faith0G | last post by:
I am starting a new it consulting business and it's been a while since I setup a new website. Is wordpress still the best web based software for hosting a 5 page website? The webpages will be...
0
isladogs
by: isladogs | last post by:
The next Access Europe User Group meeting will be on Wednesday 3 Apr 2024 starting at 18:00 UK time (6PM UTC+1) and finishing by 19:30 (7.30PM). In this session, we are pleased to welcome former...

By using Bytes.com and it's services, you agree to our Privacy Policy and Terms of Use.

To disable or enable advertisements and analytics tracking please visit the manage ads & tracking page.