473,320 Members | 2,202 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,320 software developers and data experts.

Excel export does not work on othet computers

Hello everybody,

I have implemented a windows form in C# .NET to export data from a listbox
to Excel. I work on a Windows XP machine with Office 97 and .NET framework
1.1 SDK installed. I use Visual Studio .NET 2003, German version, Service
Pack 1. The Excel Export works fine on my developement machine, but I
cannot export data into Excel on other computers.
I tried to run the program on 2 other machines. One is a Windows XP and the
other a Windows 2000 system. Both computers have MS Office 97 (the same
version as on the development machine) and .NET framework 1.1 SDK installed
and I have administrator rights.

I found out that the command:

Excel.Application oXL;
oXL = new Excel.ApplicationClass();

is passed without errors, but when I try to set or change any attributes of
Excel object, f.e.

oXL.Visible = false;

I get an exception saying "Error HRESULT: 0x8007FA08. Line: Interop.Excel
at Excel.ApplicationClass.set_Visible(Boolean RHS)\r\n"

I already read many postings for similar issues, but none of the solutions
worked for me:
I checked the rights of the ASP.NET user on both machines, the permissions
are same as on my developement machine. I also checked if maybe the culture
settings are incorrect (there is a Microsoft support article about that),
but my Visual Studio version is in German, my MS Office 97 is in German and
the computer's region settings are also set to German.
I even installed Visual Studio .NET on the Win2000 computer and compiled
the source files again on this machine, but I still get the same error.

Does anybody have any idea what causes this error or what else I can try ?

Thanks in advance,

Robert
Nov 17 '05 #1
0 1509

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

Similar topics

2
by: brazilnut52 | last post by:
I am going to outline the steps I go through to produce the problem. Hopefully this will help you understand the problem better I have created a simple COM DLL in .NET by using the COM class...
6
by: Robin Cushman | last post by:
Hi all, I need some help -- I'm working with an A2K database, using DAO, and am trying to read records into a Crystal Report and then export it to a folder on our network as an Excel...
2
by: Kenneth | last post by:
How do I remove the limitation in Access that deny me from exporting 24000 rows and 17 columns (in a query) into Excel? Kenneth
2
by: Regnab | last post by:
I've got my code working so that it'll count the number of columns in the table and move across (eg Range A-P and then range Q-W). Problem is when I get to the end of the single letters and get...
0
by: Max Mayer | last post by:
Hello everybody, I have implemented a windows form in C# .NET to export data from a listbox to Excel. I work on a Windows XP machine with Office 97 and .NET framework 1.1 SDK installed. I use...
3
by: David Reynolds | last post by:
Does anyone know how I could stream Excel to the browser for download without saving the file somewhere first. I wasn't sure how I would go about it.
0
by: dana lees | last post by:
Hello, I am developing a c# asp.net application. I am trying to export a datagrid to excel by using: Response.Clear(); Response.Buffer= true; Response.ContentType =...
1
by: smaczylo | last post by:
Hello, I've recently been asked to work with Microsoft Access, and while I feel quite comfortable with Excel, I'm at a complete loss with databases. If someone could help me with this issue I'm...
15
by: patf | last post by:
Hi - experienced programmer but this is my first Python program. This URL will retrieve an excel spreadsheet containing (that day's) msci stock index returns. ...
0
by: DolphinDB | last post by:
Tired of spending countless mintues downsampling your data? Look no further! In this article, you’ll learn how to efficiently downsample 6.48 billion high-frequency records to 61 million...
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...
1
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...
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)...
0
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...
0
by: Defcon1945 | last post by:
I'm trying to learn Python using Pycharm but import shutil doesn't work
0
by: af34tf | last post by:
Hi Guys, I have a domain whose name is BytesLimited.com, and I want to sell it. Does anyone know about platforms that allow me to list my domain in auction for free. Thank you

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.