|
This error might be occured in different scenarios
(1) if you try to access the Excel cells which is not existis like Cells[-1,0].
(2) When you try to insert an Excel Worksheet before a worksheet and after another worksheet using the Sheets.Add() method
(3) When you write the content of a two dimentional array having some special chanracters like '=''%' in the array elements into some range of cells.
Check whether the above scenarios occured in the server side.
Also instead of using Microsoft.Office.Interop.Excel.ApplicationClass in your automation code, try to use
Microsoft.Office.Interop.Excel.Application class to create the Excel application instance.
Hope this will help you.
|
|
|
|
|
Thanx dude changing my code to Microsoft.Office.Interop.Excel.Application worked
|
|
|
|
|
I am facing the same error!
this is my code:
Dim appExcel As Excel.Application
Dim wbBook As Excel.Workbook
Dim wsSheet As Excel.Worksheet
Dim strSheetName As String
On Error GoTo 0
Set appExcel = New Excel.Application
Set appExcel = CreateObject("Excel.Application")
Set wbBook = appExcel.Workbooks.Open(txtFile.Text, False, True)
If (wbBook Is Nothing) Then
Debug.Print "Invalid workbook"
End If
|
|
|
|
|
Hi All
I have created a web application where I load controls on different callbacks. So When User click on a button "Security" I have to load a security control using ajax which works fine. The problem I am facing is the following.
in Security Control I have one javascript function say ShowDetail(){ some js code here } which is required to be called when this control is loaded. When the control loads it does nto trigger , for testing I placed a button on contrl and on click I call ShowDetail() and it says that undefined function.
on another control I have Javascript with a variable say var id = '<%=this.ClientID%>'
so when I try to access "id" variable after loading that control Javascript rasie error with id is undefined.
Can any one help me out with these issues ?
Best Regards
Rizwan Bashir
Rizwan Bashir
<a href="http://www.alm-soft.com/">ALM Soft</a>[<a href="http://www.alm-soft.com/" target="_blank" title="New Window">^</a>]
|
|
|
|
|
i made a website which is working correctly on iis 6.0 but when i shift it to iis 7.0 it gives some errors i don't know how to fix it.
the error is as below
Could not load the assembly 'App_Web_xqefcnyj'. Make sure that it is compiled before accessing the page.
i republish the site but the error remain the same
Microsoft .NET Framework Version:2.0.50727.1434; ASP.NET Version:2.0.50727.1434
the assamblies version used in web.config is
<add assembly="System.Web.Extensions, Version=1.0.61025.0, Culture=neutral, PublicKeyToken=31bf3856ad364e35">;
<add assembly="System.ServiceProcess, Version=2.0.0.0, Culture=neutral, PublicKeyToken=B03F5F7F11D50A3A">
amirzada
|
|
|
|
|
Member 1405179 wrote:
Could not load the assembly 'App_Web_xqefcnyj'. Make sure that it is compiled before accessing the page.
i republish the site but the error remain the same
Microsoft .NET Framework Version:2.0.50727.1434; ASP.NET Version:2.0.50727.1434
the assamblies version used in web.config is
Dou you have installed required framework for IIS ? Did you register it with ASP.NET using aspnet_regiis?
Here is one of my complete article on IIS 7.0, this may help you .
Deploying ASP. Net Websites on IIS 7.0
|
|
|
|
|
Hi,
i am working on embedding rss feeds in my site
it has worked fine in my local server
but when i have uploaded that one in web
it shows the following error
Exception Details:-
------------------
System.Security.SecurityException: Request for the permission of type 'System.Net.WebPermission, System, Version=2.0.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089' failed.
Source Error :-
--------------
Line 41: {
Line 42: clrFeed.DataSource = "http://in.news.yahoo.com/myyahoo/rss/national-general.xml";
Line 43: clrFeed.DataBind();
Line 44:
Line 45: rssRediff.DataSource = "http://www.rediff.com/rss/inrss.xml";
My web.config file :-
--------------------
<location allowoverride="false">
<system.web>
<compilation debug="true">
<assemblies>
<add assembly="System.Core, Version=3.5.0.0, Culture=neutral, PublicKeyToken=B77A5C561934E089">
<add assembly="System.Web.Extensions, Version=3.5.0.0, Culture=neutral, PublicKeyToken=31BF3856AD364E35">
<add assembly="System.Data.DataSetExtensions, Version=3.5.0.0, Culture=neutral, PublicKeyToken=B77A5C561934E089">
<add assembly="System.Xml.Linq, Version=3.5.0.0, Culture=neutral, PublicKeyToken=B77A5C561934E089">
--------------------------------------------------------------------------------------------------------------------
I dint embed the trust level tag in web.config. ( You can see the commented one )
my service provider provides medium trust level.
when i have applied trust level as medium in my web.config
it shows an error like
location allowoverride="false"
then i have changed the allowoverride to true. But its not working.
Can you please help me out in this regard
thanks in advance
|
|
|
|
|
Shared hosting servers will not allow you to change trust level higher than "Medium", you can replicate the same error on local machine by adding
<trust level="Medium" originUrl=""/> in web.config.
Sagar
|
|
|
|
|
Hi,
I am a new comer to web development,and i would like to know how IIS is configured in
Windows server 2003 for ASP.NET2.0 and how i could run the application after precompiling my project.
Plz help
|
|
|
|
|
|
If you are already familiar with the IIS console (Start button, Administrative tools, Internet Information Services Manager (also exists as a snap-in to a stand alone MMC)), the ASP .Net 2.0 part is easy. Right click on your web site in the IIS management console and select properties. There will be an ASP.Net tab in the properties window. Click on the tab and the ASP.Net version selection is the first drop down list.
As far as running the project, I don't quite understand your question. Just visit the web page you built as part of the project to run it. If you are doing it from the local server, simple use http://localhost/etc..
|
|
|
|
|
|
Hi
I have a nasty problem with my visual studio. I cannot enter Debug mode when click Start Debugging button its opening the web page of my solution but the solution is not in the Debug mode, I still see Start Debugging button instead of Stop and it never hits the breakpoints as it's not in debug mode.
I do the iisreset several times and remove the temporary asp.net files and iisreset and clean the solution and close and do the same thing, no change it's always the same case.
Can any one please tell me if any of you have the same problem.
Thanks in advance,
Aruna
--
http://ashakthi.blogspot.com
http://kids-articles.blogspot.com
|
|
|
|
|
gottimukkala wrote: I do the iisreset several times and remove the temporary asp.net files and iisreset and clean the solution and close and do the same thing, no change it's always the same case.
So, your site is hosted in IIS and you want to debug it from Visual Studio ?
If yes,
Did you Attach the worker Process ? Which IIS Version are you using ?
|
|
|
|
|
I am using IIS 5.1 but My site doesn'z host on IIS Server. I just did iisreset if the visual studio catches something. It was working fine since 5 days I am having this problem.
--
http://ashakthi.blogspot.com
http://kids-articles.blogspot.com
|
|
|
|
|
Hi,
If you are not using IIS then there is no sense that IISRESET will work for you.
Are you a debugger user? Is debugging enabled for the current user?
Have you set compilation debug = true for the current project?
Either you love IT or leave IT...
|
|
|
|
|
Thanks for your replies. I attched our webserver process to the debug and its working now.
--
http://ashakthi.blogspot.com
http://kids-articles.blogspot.com
|
|
|
|
|
gottimukkala wrote: I attched our webserver process to the debug and its working now.
I didn't get you ?
|
|
|
|
|
I am using following script to add gridview templatefield textbox values dynamically...
function ShowTotal(id)
{
//since the code is used with in UpdatePanel (Ajax) $get is used
//for normal application $get will be replaced with document.getElementById(idOfControl)
//txtQuantity is the textbox place inside the grid
//lblTotalQuantity is the lable in the footer that will display total
//$get(id + '_ctl0' + i + '_txtQuantity this line will actually access the control
//containers like GridView/Datalist they put prefixes with control's ID
var grid = $get(id);
if (grid.rows.length > 0)
{
var qty = 0;
for (i=2; i<grid.rows.length;i++)
{
// i=i+1;parseInt
if ($get(id + '_ctl0' + i + '_marksobt').value != "")
qty = qty +parseFloat($get(id + '_ctl0' + i + '_marksobt').value);
}
var tid = grid.rows.length;
$get(id + '_ctl0' + tid + '_TextBox2').innerText = qty;
}
}
And I add following code for gridview rowdatabound
protected void Gridview1_RowDataBound(object sender, GridViewRowEventArgs e)
{
if (e.Row.RowType == DataControlRowType.DataRow)
{
TextBox marksobt = (TextBox)e.Row.FindControl("marksobt");
marksobt.Attributes.Add("onchange", "javascript:ShowTotal('" + this.grdResultCreate.ClientID + "');");
string str = marksobt.ClientID.ToString();
}
}
All these things works properly with IE,Google Crome but it is not working with mozilla.
Can anybody help me to fix this problem.
|
|
|
|
|
Which version of Firefox ? any errors that you have received ?
|
|
|
|
|
Thanks For Your Reply..
I am using Mozilla Firefox2.0 in my local system.
I am not receiving any error.Calculations are not taking place
in gridview footer.While this script runs fine with other browsers.
Any Help can u provide.
Thank you.
|
|
|
|
|
Please Anybody Tel me the varous script injection
problems and it solutions
Shaikh Tauhid Hasan
|
|
|
|
|
|
Are you talking abt Java script injection ? However Google is there as he said.
|
|
|
|
|
Hi,
i am starter in aps.net , and i've created a webproject in asp.net2.0 and SqlServer2000 in Windows 2003 server.My doubt is ,
The images are in the folder named "img" and when i added the image to the Webpage
the is like this "../img/he.jpeg" .When i upload this site will the images with this path be displayed or not?
Plz help.
|
|
|
|