Hi Frank,
The framework is vast, and while the Microsoft documentation is actually
very detailed. However, if you don't know what you are searching for then
finding it in MSDN is frustrating to say the least. The best tip I can give
you is to try Google, this will at a minimum provide you with a better
vocabulary with which to search MSDN. For example I didn't know anything
about your specific challenge. However after searching Google with -
asp.net export excel - I now know a whole lot about it. As a matter of fact
the first hundred or so links take you directly to code examples that you
can download and run.
Your best bet is to run that search. Create a very scaled down, simple
example of what you are trying to do and see if it works. Then if it
doesn't post back here with code. When you post back be sure to make clear
which line of code your application is bombing on and the exact wording of
the error you are getting. Armed with that the people on the group will be
in a much better position to help you. (Many will probably go straight to
Google and search based on the information you would have just provided.)
You also need to be clear on what you are trying to accomplish. Your
description is that you want to "export Excel spreadsheets to the client
machine". Do you mean that you have spreadsheets on the server and you want
to query them for a subset of data and display this data in a web page? Or
are you trying to move an Excel file? Good luck! Ken.
"frankvfox" <fr*******@discussions.microsoft.com> wrote in message
news:78**********************************@microsof t.com...
I am struggling to export Excel spreadsheets to the client machine in an
ASP.Net application. Everything was great until exporting Excel got into
the act. Documentation on MSDN is so poor regarding this subject it is
pathetic. Following examples on MSDN lead me to using
CreateObject("Excel.Application") which of course bombs in .Net! I finally discovered the
Microsoft.Office.Interop.Excel object and thought my problems were over.
When I got to "Dim xls As New Microsoft.Office.Interop.Excel.Application"
ASP.Net abruptly threw another error saying the ASPNET user account didn't
have permission to use my new found resource. Looking in the User folder I
can't even find ASPNET as a user. (I am strictly a developer and don't
know Shinola about network administrator type duties). My platform is Windows
Small Business Server 2003. Maybe I'm not supposed to be developing on
this?
I am an independent contractor and the extent of my frustration and anger
at Microsoft at this stage of the game is immense!
I am also a Certified Partner who can't get any direct help from the
bureaucracy. What a waste of money dealing with Microsoft.
Is there anybody out there who can help me solve this problem? I am at the
end of my rope. My client has been waiting almost a month for my final
version of this thing and I am no closer to a solution than in the
beginning.
Maybe I should just scrap everything and learn Java. Are you listening
Ballmer?
How can something so simple become so difficult?
Frank Fox
fr*******@hotmail.com