|
Try Next Code:
Excel._Application m_app = null;
Excel.Workbook m_workBook = null;
Excell.Worksheet m_workSheet = null;
m_app = new Excel.ApplicationClass();
m_app.Visible = false;
m_app.UserControl = true;
m_workBook = m_app.Workbooks.Open(filename, false, false, Type.Missing......Type.Missing);
m_workSheet = m_app.Worksheets[shet] as Excel.WorkSheet;
//************************
m_workSheet.Cells[x,y] = "Yes";
//************************
m_workBook.Close(false,"", Type.Missing);
m_app.Quit();
m_workBook = null;
m_workSheet = null;
m_app = null;
GC.Collect();
devers@inbox.ru
|
|
|
|
|
hi,
Please let me know if anybody has idea about showing the graphical representation similar to performance graph available with Task Manager which show the graphical representation of cpu usage.
i wanted to implement the similar functinality into the .Net (winforms) application.
Please help me.
Regards,
Rajesh Khubchandani
|
|
|
|
|
hi,
in my application i need to develop a program that has its visual design some how like the outlook. it is compsed of two panels. one on the left that contains the buttons and the other is empty. when each button is clicked different forms should appear in panel2. To do that, I created diffrent userControls that i designed to work like the forms i need. When clicking on any button for the first time, the user control is assigned to the panel2. but clicking on different button after that should assign another user control to the panel2; but that is not happening. i don't know why.
i used different methods to free the panel2 from the old usercontrol and assign the new one to it but nothing is working.
for example i used this method:
panel2 = new Panel();<br />
usercontrol2.Parent = panel2;<br />
if any body can help i will appreciate that
best regards
Jamil Abou Khalil
|
|
|
|
|
Hello,
//Add a control to your panel
You have to work with the "Controls" property of the panel.
this.panel2.Controls.Add(usercontrol2);
//clear panel
this.panel2.Controls.Clear();
Hope that helps you.
All the best,
Martin
|
|
|
|
|
Hi all,
Yesterday i had the problem when i tried to convert a string to DateTime
I wanted to do the following:
string _appDate=_CurrentSelectedDate.Date.ToString("yyyy/MM/dd");<br />
string _fromDateTime = _appDate+" "+startTime;<br />
string _endDateTime = _appDate+" "+endTime;<br />
<br />
FromTime = Convert.ToDateTime(_fromDateTime);<br />
ToTime = Convert.ToDateTime(_endDateTime);
Now in this example the value of _appDate is "2006/11/07"
the value of _startTime is "4:00 PM"
the value of _endTime is "5:00 PM"
That makes the value of _fromDateTime = "2006/11/07 4:00 PM"
and the value of _endDateTime = "2006/11/07 5:00 PM"
I checked and it is...
Now when i try to Convert.ToDateTime for the FromDate and the ToDate
The value of FromTime is 7/11/2006
and value of ToTime is 7/11/2006 
on the other computer the values are correct but not on mine...
The regional settings are the same...
Please help
"Many of life's failures are people who did not realize how close they were to success when they gave up." Thomas A. Edison
|
|
|
|
|
What exactly is the problem? Arent you getting the time values?
Mubashir
Every job is a self portrait of the person who did it.
|
|
|
|
|
Oh no sorry...
I only get the date back like this...
"11/7/2006"
I want it to work like it does on the other PC
"2006/07/11 4:00:00 PM"
It worked on my PC too but i haven't changed the regional settings, i haven't altered the code of this segment...only now to try and fix it.
I don't know... 
"Many of life's failures are people who did not realize how close they were to success when they gave up." Thomas A. Edison
|
|
|
|
|
Hi,
This problem has a whole new twist....
Everywhere in my code where i use the Covert.ToDateTime i have the same problem... it doesn't show me the time any more...
only the date but not even in the yyyy/MM/dd format, now it is in the dd/MM/yyyy
format.
Do you think that if i built the installer and and installed it onto another computer that it would work... I mean there is nothing wrong with the code, it's just weird...
i checked the regional settings again => same as the other computer...
before i build the installer, and find a pc to install it on... do you think it would work correctly on another PC if it's acting weird on mine?
"Many of life's failures are people who did not realize how close they were to success when they gave up." Thomas A. Edison
|
|
|
|
|
Ha, it works....
there must be something wrong on my pc... some setting or something...
Thank you for your time...
I think i need to reinstall my PC.  But, this at least will speed up my system a little... 
"Many of life's failures are people who did not realize how close they were to success when they gave up." Thomas A. Edison
|
|
|
|
|
i have this question, but i use two datetimepicker later:
dt1 =DateTime .Parse(dateTimePicker11.Value.ToLongDateString()+" "+dateTimePicker12.Value.ToLongTimeString());
it is right.
Sorry ...
|
|
|
|
|
i am using a treeView control in which i want to display image against its every node. the images are placed in project directiory's \bin\release folder. now the tree is popupulated when the form is loaded i.e the statements of populating the tree are after calling
InitializeComponent();
in the constructor of new form. at first time when i come 2 this form (calling it against the NEXT button of a prevous form) then no problems occur and the images are loaded without any complication but when i go back to a previous form and come back to this form through same path and using same NEXT button then fileNotFound exeception occurs at this line
Image img = Image.FromFile("pic1.jpg");
but previously images were displayed successfully...!
i am facing same problem when i rightclick and create a contextMenu against a node. images are displayed against each optin of contextMenu successfully at first but when i click some option of contextMenu then work n then rightclick same node then the same exeception fileNotFound occurs(while populating ContextMenu) at same sort of lines...
further more if i am debugging the project then these fileNotFoundException occurs even for the first time when i populate the tree.but when i run the project no error comes for the first time and the images are loaded successfully....but only for first time..!
i canot understand where the problem lies??
May God help u solv ur problems as well,thx in advance!!
|
|
|
|
|
Hi
I can't exactly tell you what is the problem but it seems that there's a problem in finidng the directory of images.If that's the problem ,you can use Application.ExecutablePath property to get the path then combine it with the file name (for example Path.Combine(Application.ExecutablePath,"image1.pic")
Regards
|
|
|
|
|
By default we assign absolute path to the initialdirectory of the openfile/savefile dialog control how can we assign a relative path that checks in the current directory.
thanks.
|
|
|
|
|
kalaveer wrote: that checks in the current directory.
Directory.GetCurrentDirectory(); could help.
V.
Stop smoking so you can: enjoy longer the money you save.
|
|
|
|
|
neither dialog control nor form has the method of Directory.GetCurrentDirectory(); can you please tell me with which and how can i use this.
thanks.
|
|
|
|
|
System.IO.Directory.GetCurrentDirectory();
|
|
|
|
|
Hi, Dear Respected Programmers
Kindly help me and convert following VB6 command into C# language.
Thank you
Text1.Text = IIf(Check1.Value = 1, "GOOD", "BAD")
|
|
|
|
|
Text1.Text = ( Check1.Value == 1 ) ? "GOOD" : "BAD";
--------------------------------------------------------
My portfolio & development blog
Q:What does the derived class in C# tell to it's parent?
A:All your base are belong to us!
|
|
|
|
|
|
What's the diffenrence between these two assemblies?
I encountered with an error when i tried to move a VS 2005 Shared Add-in project from one computer to another. The original machine has got VS 2005 Team Suite on it while the second one has got VS 2005 Professional Edition. During the original development on the first computer, I referred to an assembly "Microsoft.Office.Interop.Outlook"(which is added via: Add references -> COM -> Microsoft Outlook Object Library 11.0). However, the second machine cannot find the assembly and I have to manully change it to "Interop.Outlook"(which is also added via: Add references -> COM -> Microsoft Outlook Object Library 11.0). And I have to do some modification to the codes in order for the project to build successfully.
Why did the problem occur? What's the reason behind it?
OctopusThu
|
|
|
|
|
Hi everybody,I'm new here and I have a question... I'd like to create a form which would simulate a perspective view, so my form will have to have a trapeze shape. I don't want to use Region(myShape) because that will clip my form and I want to have the entire form.
Thanks in advance for any suggestions.
|
|
|
|
|
U have to create a image of the same shape as u want the form to be.(set some color in the image region e.g. black)
then set this image as the background image of the form.
and then set the transparency key of the form to the image's color i.e. Black
Hope that works for u.
Thanks & Regards,
Pramod
"Everyone is a genius at least once a year"
|
|
|
|
|
10x for the suggestion, but as I said, I want to know if there is a way to reshape the form, I dont want to use transparency keys or to overwrite OnPaint method
|
|
|
|
|
How Can we configure icon Files to asp .net web applications using C# Codebehind  confused: :
|
|
|
|
|
Hello, friends
I want to know how to create a chm help file ahe how access it through
C#.Net.
Rahul Kulkarni
|
|
|
|
General 
News 
Suggestion 
Question 
Bug 
Answer 
Joke 
Praise 
Rant 
Admin 
Submit an article or tip
