473,804 Members | 3,958 Online
Bytes | Software Development & Data Engineering Community
+ Post

Home Posts Topics Members FAQ

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 2490
check out
Subject RE: export datagrid data to Excel file within the
Dated 3rd April
microsoft.publi c.dotnet.framew ork.aspnet.dtag ridcontrol

"Rana" <sw*******@hotm ail.com> wrote in message
news:d9******** *************** ***@posting.goo gle.com...
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.publi c.dotnet.framew ork.aspnet.dtag ridcontrol

"Rana" <sw*******@hotm ail.com> wrote in message
news:d9******** *************** ***@posting.goo gle.com...
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*******@hotm ail.com> wrote in message
news:uw******** ******@TK2MSFTN GP12.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*******@hotm ail.com> wrote in message
news:uw******** ******@TK2MSFTN GP12.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
1242
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 installig XL on that web server machine. i will fetch data from stored procedures and that data to be sent to each cells in to XL sheet without opening the XL (also there will be no installation of XL). kindly help me how to do that. pls mail...
1
1420
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 and send the information to excel work book cells. Actually it works fine through VB.Net (windows forms application), But it does not work with ASP.Net (web application) because to access the excel component (Excel.application) it seems i should...
3
9342
by: jijo kuruvila | last post by:
How we can Dynamically generate a MS Word document using ASP.Net? -- Jijo kuruvila trivandrum,Kerala,India
3
286
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 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...
2
8207
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 the only way to do it is to feature my objects (text blocks, pictures, tables drawn from excel and databases etc.) with a "render to RDL"- function and thus create an RDL definition of the report, then push that one to the server using the...
5
1848
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 free?
1
1387
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. Some points are as follows: 1) User should be able to filter data included in reports like choose among cycles, cars etc or all of them (I.e. Sql query is generated dynamically based on user choice) 2) Data is retrieved from database and...
6
5229
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. Again, I have this part working. But the fields in the resulting spreadsheet are in a different order than the Access report. (Example: The fields in the Access report might go FirstName, LastName,Address,City--in the Excel spreadsheet, they come up...
10
1682
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 easy to make using Excel as the data source. Since there will not be multiple tables or queries, I don't really need Access.
15
5362
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 2003 application (Reports) works ok. But when Office 2003 is upgraded to Office 2007 Excel reports stops working. It Log the error “Exception from HRESULT: 0x800A03EC.” In database.
0
9585
by: Hystou | last post by:
Most computers default to English, but sometimes we require a different language, especially when relocating. Forgot to request a specific language before your computer shipped? No problem! You can effortlessly switch the default language on Windows 10 without reinstalling. I'll walk you through it. First, let's disable language synchronization. With a Microsoft account, language settings sync across devices. To prevent any complications,...
0
10586
Oralloy
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, it seems that the internal comparison operator "<=>" tries to promote arguments from unsigned to signed. This is as boiled down as I can make it. Here is my compilation command: g++-12 -std=c++20 -Wnarrowing bit_field.cpp Here is the code in...
1
10323
by: Hystou | last post by:
Overview: Windows 11 and 10 have less user interface control over operating system update behaviour than previous versions of Windows. In Windows 11 and 10, there is no way to turn off the Windows Update option using the Control Panel or Settings app; it automatically checks for updates and installs any it finds, whether you like it or not. For most users, this new feature is actually very convenient. If you want to control the update process,...
0
10082
tracyyun
by: tracyyun | last post by:
Dear forum friends, With the development of smart home technology, a variety of wireless communication protocols have appeared on the market, such as Zigbee, Z-Wave, Wi-Fi, Bluetooth, etc. Each protocol has its own unique characteristics and advantages, but as a user who is planning to build a smart home system, I am a bit confused by the choice of these technologies. I'm particularly interested in Zigbee because I've heard it does some...
0
9161
agi2029
by: agi2029 | last post by:
Let's talk about the concept of autonomous AI software engineers and no-code agents. These AIs are designed to manage the entire lifecycle of a software development projectplanning, coding, testing, and deploymentwithout human intervention. Imagine an AI that can take a project description, break it down, write the code, debug it, and then launch it, all on its own.... Now, this would greatly impact the work of software developers. The idea...
1
7622
isladogs
by: isladogs | last post by:
The next Access Europe User Group meeting will be on Wednesday 1 May 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 a new presenter, Adolph Dupr who will be discussing some powerful techniques for using class modules. He will explain when you may want to use classes instead of User Defined Types (UDT). For example, to manage the data in unbound forms. Adolph will...
0
5658
by: adsilva | last post by:
A Windows Forms form does not have the event Unload, like VB6. What one acts like?
2
3823
muto222
by: muto222 | last post by:
How can i add a mobile payment intergratation into php mysql website.
3
2997
bsmnconsultancy
by: bsmnconsultancy | last post by:
In today's digital era, a well-designed website is crucial for businesses looking to succeed. Whether you're a small business owner or a large corporation in Toronto, having a strong online presence can significantly impact your brand's success. BSMN Consultancy, a leader in Website Development in Toronto offers valuable insights into creating effective websites that not only look great but also perform exceptionally well. In this comprehensive...

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.