|
Hi,
Currently i'm developing a web based app. In one of the page i need to generate and show some data in excel.
I have added Excel 11.0 as a reference and using the following declarations:
Excel.Application ExcelApp = null;
Excel.Workbook ExcelWorkbook = null;
Excel.Worksheet ExcelWorkSheet = null;
and i'm using it as below
ExcelApp = new Excel.Application();
ExcelWorkbook = (Excel.Workbook)(ExcelApp.Workbooks.Add(Type.Missing));
ExcelWorkSheet = (Excel.Worksheet)ExcelWorkbook.Sheets["Sheet1"];
and it works fine.
But when i use the code below i'm getting compile time errors and for the below im not referring to Excel 11.0 library.
using Microsoft.Office.Tools;
using Microsoft.Office.Tools.Excel;
using Microsoft.Office.Interop.Excel;
The above three lines are written at the namespace declaration section.
Application ExcelApp = null;
_Workbook ExcelWorkbook = null;
_Worksheet ExcelWorkSheet = null;
ExcelApp = new Application();
ExcelWorkbook = (_Workbook)(ExcelApp.Workbooks.Add(Type.Missing));
ExcelWorkSheet = (_Worksheet)ExcelWorkbook.Sheets["Sheet1"];
One more problem is now the above codes fail to compile in machines in which their counter compile. Can any one help me on this.
Thanx,
PLS
|
|
|
|
|
Application is a property which refers to the application of page one cannot make an object of it.
Can you plz tell me what reference are you using for these name spaces I mean which library are you using?
using Microsoft.Office.Tools;
using Microsoft.Office.Tools.Excel;
using Microsoft.Office.Interop.Excel;
Shujaat
|
|
|
|
|
When I add new item to ASP.Net 2.0 project Iam having Javascript file but not VB Script File where I will get this or how this can written in Notepad
Priya
|
|
|
|
|
Javascript file has .js extension.You can use vbscript file with .vbs extension.
in source file you can use vbscript file
write this script between Head tag
<script language="vbscript">
Sub Get()
MsgBox("this is vbscript")
End Sub
</script>
call vbscript
<body onload="Get()">
........................
You can also write vbscipt file in notepad in VB language and save it with .vbs extension
Best Regard
Pathan
---------------------------------------------------
|
|
|
|
|
I can write VB script file by using script tags in the Source file but calling to the text box "ONKEYPRESS" event is not there.How to attach script function to the text box in KEYPRESS event which is not available
Priya
|
|
|
|
|
In page load of code behind file add javascript function name to it
TxtBxPhoneNumber.Attributes.Add("onkeypress", "javascript:alert('hi');");
Thanks and Regards
Sandeep
If If you look at what you do not have in life, you don't have anything,
If you look at what you have in life, you have everything... "
|
|
|
|
|
add attribute to textBox in pageload event
TxtBox.Attributes.Add("onkeypress", "FunctionName()")
If Function returns true or false,try this
TxtBox.Attributes.Add("onkeypress", "return FunctionName()")
In source File
Sub FunctionName()
MsgBox("HI")
End Sub
Best Regard
Pathan
---------------------------------------------------
|
|
|
|
|
Hi
I need to impliment functionality for online image editing that support add text to image, rotate image, ovaerlap new image to existing image, zooming image, crope.
Please give me refferance of such website that can provide tool for image editor.
I want same functionality as in http://www.buildasign.com/PowerDesign.aspx?T=4476553256504A7644356F3D
I am finding tool or source in GDI+ that support this functionality.
If you know any component, free or paid please give me refferance.
Please help me.
Thanks in advance
Mustakim Mansuri
|
|
|
|
|
How do u update a page automatically without clicking.
Well this page contains images which changes whn certain database values change.
|
|
|
|
|
duo!@# wrote: How do u update a page automatically without clicking.
Insert a Meta Refresh tag, <meta http-equiv="refresh" content="5"> which would automatically reload the page every 5 seconds.
Regards
J O H N ![Rose | [Rose]](https://codeproject.global.ssl.fastly.net/script/Forums/Images/rose.gif)
"Even eagles need a push." David McNally
|
|
|
|
|
hi friends
what is deployment?
type of deployment?
any new deployment in asp2.0
any goodlink regarding this
saravanan
|
|
|
|
|
|
hello all
in my project one div's visible false
on click of href i am setting visible true of that div
in div a datagrid exit and also a button. on click of button that grid binds with data.
but i want to bind that grid when that div's visible getting visible true.
plz help me some one.
rajeev kumar sharma
vri software pvt. ltd.
new delhi India
|
|
|
|
|
Bind gridview on pageload event.
best regard
Pathan
---------------------------------------------------
|
|
|
|
|
- Add a server-side hidden field to your page.
- If you set something (either true or false) to the visible of div, you should also set that value to this server-side hidden field.
- then, you check this hidden field from server-side whether it is true or not before binding to the datagrid..
Hope it helps..
Thanks and Regards,
Michael Sync ( Blog: http://michaelsync.net)
If you want to thank me for my help, please vote my message by clicking one of numbers beside "Rate this message". Why vote? Plz Read it here. Thank you. 
|
|
|
|
|
i am getting access denied error while parsing http xml using javascript...
how can i solve this...please any one help me...
Pradeep Reddy
|
|
|
|
|
|
Hi all i need to lock a record from edit to all other users when i am in edit mode for a certain record. Im using VS2005 and sql 2005.
|
|
|
|
|
There is no direct method available it seems. You could use a flag column and change the value when a user starts editing record. Before editing check this flag value.
|
|
|
|
|
If you use this method, make sure you have the ability to reset the column on error. (try /catch / finally). If your code crashes after setting this column for edit, and before resetting it, nobody else will be able to edit.
In C++ I would generally use RAII for something like this, but C# destructors are non deterministic, so RAII has to be implemented via 'using'.
"More functions should disregard input values and just return 12. It would make life easier." - comment posted on WTF
"I haven't spoken to my wife now for 48 hours. I don't like to interrupt her.
|
|
|
|
|
Malcolm Smart wrote: f you use this method, make sure you have the ability to reset the column on error. (try /catch / finally). If your
Yes that's correct. No will be able to edit it. Good point
|
|
|
|
|
i create an asp.net website using membership and ..
it works fine on local but when i deploy it to internet this error occures:
--------------------------
An error has occurred while establishing a connection to the server.
When connecting to SQL Server 2005, this failure may be caused by the
fact that under the default settings SQL Server does not allow remote
connections. (provider: SQL Network Interfaces, error: 26 - Error
Locating Server/Instance Specified)
---------------------------
My web config contains this:
<connectionStrings>
<remove name="LocalSqlServer"/>
<add name="LocalSqlServer" connectionString="Data Source=.
\SQLEXPRESS;Integrated Security=SSPI;AttachDBFilename=|DataDirectory|
aspnetdb.mdf;User Instance=true" providerName="System.Data.SqlClient" />
</connectionStrings>
any one can help me ..???
thanks
|
|
|
|
|
ABBASI_RA wrote: <add name="LocalSqlServer" connectionstring="Data Source=.
\SQLEXPRESS;Integrated Security=SSPI;AttachDBFilename=|DataDirectory|
aspnetdb.mdf;User Instance=true" providername="System.Data.SqlClient">
I think you can't probably use "." in hosting. You should ask your hosting service about how to connect to your SQL database. We can't say about that for sure since the connectionstring might differ from host to host...
Thanks and Regards,
Michael Sync ( Blog: http://michaelsync.net)
If you want to thank me for my help, please vote my message by clicking one of numbers beside "Rate this message". Why vote? Plz Read it here. Thank you.
|
|
|
|
|
thanks
i ask it and they dont support sqlexpress
i found its way...
thanks again
|
|
|
|
|
Iam using ASP.Net2.0 with VB.Net.
Iam having a code for validation to the controls which can be called on KEYpress Event i.e. checking for each keypress event related to that control where I have written this code in vbscript.How that function can be called in application or to a control
Can anybody give me the exact syntax to this or help in writing easiest way fro validation of all the controls.
Priya
|
|
|
|
General 
News 
Suggestion 
Question 
Bug 
Answer 
Joke 
Praise 
Rant 
Admin 
Submit an article or tip
