|
Hello,
I have a C# program that uses the Excel interop (Microsoft.Office.Interop.Excel) to monitor an Excel 2007 spreadsheet.
I use the delegate named WorkbookEvents_SheetChangeEventHandler which runs my custom code when any cell on the spreadsheet is updated. But the following code is not working..
I think I didn't use the delegate WorkbookEvents_SheetChangeEventHandler,correctly.Please let me know how to raise the event whenever the cell in excel file gets changed.
Thanks in advance.
using excel=Microsoft.Office.Interop.Excel;
public event excel.WorkbookEvents_SheetChangeEventHandler SheetChange;
private void WorkbookSheetChange()
{
this.SheetChange += new excel.WorkbookEvents_SheetChangeEventHandler(workSheet_SheetChange);
}
void workSheet_SheetChange(object Sh, excel.Range Target)
{
Target = range;
string changedRange = Target.get_Address(1, 1,
excel.XlReferenceStyle.xlA1, 1, 1);
MessageBox.Show("The value of " + workSheet.Name + ":" +
changedRange + " was changed.");
}
|
|
|
|
|
Hi,
According to FXCop, i must have arraylist property as read only (not setter).
i tried below method as was mentioned in msdn site(http://msdn.microsoft.com/en-us/library/ms182327(VS.80).aspx):
public ArrayList SomeStrings
{
get { return strings; }
// Violates the rule.
// set { strings = value; }
}
ArrayList newCollection = new ArrayList();
WritableCollection collection = new WritableCollection();
collection.SomeStrings = newCollection;
collection.SomeStrings.Clear();
collection.SomeStrings.AddRange(newCollection);
But at the point marked bold italic, i get error saying that the property is readonly.
I'm really stuck here, can anyone plz give m solution?
I need to set data to the arraylist, but its not FXCop compliant.
|
|
|
|
|
I do not see your problem.
The error line functionality is achieved in the two lines below it. Same effect, just slightly longer to code, and possibly slightly slower to run.
More to the point, do you have to use an ArrayList? You would be better off using List<string>. 
Henry Minute
Do not read medical books! You could die of a misprint. - Mark Twain
Girl: (staring) "Why do you need an icy cucumber?"
“I want to report a fraud. The government is lying to us all.”
|
|
|
|
|
Henry Minute wrote: do you have to use an ArrayList?
Sure, however the referenced MSDN page[^], although part of VS8, gave an example with ArrayList (which probably dated back from .NET 1.x)
Luc Pattyn [Forum Guidelines] [My Articles]
The quality and detail of your question reflects on the effectiveness of the help you are likely to get.
Show formatted code inside PRE tags, and give clear symptoms when describing a problem.
|
|
|
|
|
Why are you using an ArrayList anyway? Are you using .NET 1?
Some things you could do:
- Create the new collection in the ctor of the containing class
- Make a method that takes an ArrayList and assigns that to the field/property which can then have a private setter (or no setter, if it's a field). This is not actually a good way though, it just sidesteps the problem and may generate an other warning
- Make a method that takes items to add to the ArrayList which may then not have to be exposed to the outside anymore
- Stop caring about FXCop (hey it's possible), what it says are not rules, but just guidelines. If you have good reason to ignore its advice then do it - or at least do not blindly follow its advice, following a mere guideline can cause an actual error (as is the case now).
Following the guidelines can lead to a good design, but also to hacking around just to follow guidelines while actually making the design worse.
|
|
|
|
|
harold aptroot wrote: Why are you using an ArrayList anyway?
Right, however the referenced MSDN page[^], although part of VS8, gave an example with ArrayList (which probably dated back from .NET 1.x)
Luc Pattyn [Forum Guidelines] [My Articles]
The quality and detail of your question reflects on the effectiveness of the help you are likely to get.
Show formatted code inside PRE tags, and give clear symptoms when describing a problem.
|
|
|
|
|
Alright, so that site has an excuse, but he could/should have changed it IMO
|
|
|
|
|
Hi,
FYI: cops aren't always right, and you can change the rules if you don't like them.
The MSDN example looks OK.
You must choose between 2 possibilities:
1. SomeStrings has no setter, and collection.SomeStrings = newCollection; does not compile,
however you can use Clear() and AddRange() instead, as suggested by the MSDN page.
2. SomeStrings has a setter, collection.SomeStrings = newCollection; works, and unmodified FXCop complains, however FXCop with a new or modified rule could be made to agree
Luc Pattyn [Forum Guidelines] [My Articles]
The quality and detail of your question reflects on the effectiveness of the help you are likely to get.
Show formatted code inside PRE tags, and give clear symptoms when describing a problem.
modified on Monday, August 24, 2009 9:23 AM
|
|
|
|
|
I suggest:
public List<string> SomeStrings { get; private set; }
A train station is where the train stops. A bus station is where the bus stops. On my desk, I have a work station....
_________________________________________________________
My programs never have bugs, they just develop random features.
|
|
|
|
|
Hi all
I've a class which gets all the customers from an SQL database and puts them in a class object "Customers"
I've managed to get those customers inside a remoting server application as a singleton object.
But my main problem is to get the client application connected to this server and make it possible to change the database but still keep the singleton object intact. It should create a new object on the server preferably on the same port (tcp) but get the customers from the other database.
The reason for this is that users will have te possibility to use multiple databases while connected to 1 server.
Maybe threading is an option?
please help me out
dipak
|
|
|
|
|
I am developing an asp.net web application.I want to add rows to data gridview.But Datagridview.Rows.Add() functionality is not there..It was working fine in my vb.net windows application.Can somebody help me to sort this out?
|
|
|
|
|
u can try adding row to DataTable with which u r binding ur grid.
like
DataRow row = Datatable.NewRow();
DataTable.Rows.Add(row);
dipak
|
|
|
|
|
blankRow = dataSet.Tables[Constants.CLASSES].NewRow();
blankRow["ClassName"] = Constants.SELECT;
blankRow["ClassID"] = 0;
dataSet.Tables[Constants.CLASSES].Rows.Add(blankRow);
dipak
|
|
|
|
|
Hello all
are it possible to run MS-Chart on Linux mono?
if yes, how to do it?
Thanks
H
|
|
|
|
|
|
delete
modified 2-Apr-21 5:25am.
|
|
|
|
|
This is just speculation, but maybe it doesn't like the dot? Does it work without it? (shouldn't the * take care of the dot anyway?)
Anyway, on my computer there is only 1 directory in Firefox\Profiles\, and no files, would it be bad to just copy all of it?
edit: yea that made no sense, sorry! Better look at stancrm's post
|
|
|
|
|
string appData = Environment.GetFolderPath(Environment.SpecialFolder.ApplicationData) + @"\Mozilla\Firefox\Profiles\";
string[] dirs = Directory.GetDirectories(appData, "*.default");
|
|
|
|
|
Message Closed
modified 2-Apr-21 5:25am.
|
|
|
|
|
Hey and when i want to see the Password which he saved in a textbox of the backup Prog, who does that work?
That i can see which Pw´s i have saved!
|
|
|
|
|
hmm... I dont know, probably in some kind of database.
|
|
|
|
|
I have heard there is a chance with the dll´s files from firefox, but i don´t know!
Maybe somebody knows it please help me!
modified on Monday, August 24, 2009 8:02 AM
|
|
|
|
|
I rally want to make a Option whare i can see the Pw´s who i saved!
does nobody know how this works?
|
|
|
|
|
Hi,
I am working on a windows application. In this I have a multiline textbox for entering the text. For this textbox I fixed the height and width to particular values. For this text box don't want to extend the width and height i.e., by using scroll bar.
I want the text should be entered only in that particular area and no scroll bar should come for this textbox. I tried this by setting different properties of the textbox like scrollbar, max length etc but they are not working..
If you have any idea to solve this please reply me.
Thanks in advance.
|
|
|
|
|
Do not spam the forums.
Ask your question once, and once only in the forum of your choice. READ THE FORUM GUIDELINES!!!
Henry Minute
Do not read medical books! You could die of a misprint. - Mark Twain
Girl: (staring) "Why do you need an icy cucumber?"
“I want to report a fraud. The government is lying to us all.”
|
|
|
|
General 
News 
Suggestion 
Question 
Bug 
Answer 
Joke 
Praise 
Rant 
Admin 
Submit an article or tip
