|
Hello all,
Excel.Application excel = new Excel.Application();
Excel._Workbook book = new Excel._Workbook();
Excel._Worksheet sheet = new Excel._Worksheet();
Excel.Range range = new Excel.Range();
After adding a reference to the Excel Object Library in my VC# project, these few lines start the process of opening a 'new' workbook. But, how do you open a workbook that already exists?
I would like to point to the link to the existing book, if possible.
Thanks
|
|
|
|
|
excel.Workbooks should have an Open(...) method in it.
|
|
|
|
|
|
You're welcome. 
|
|
|
|
|
This method really stinks. Why is this in the object model? http://msdn.microsoft.com/en-us/library/bb179167.aspx
Thanks
|
|
|
|
|
it's there so you can open existing workbooks . I'm not sure about the 2007 version, but with the Office XP version you can get away with passing in System.Reflection.Missing.Value for all the parameters except the first one - provided that you don't care what those params are.
|
|
|
|
|
Hello,
I'm trying to create an application, using c#, that takes a .cs source file, parses it (I just need to extract class name, methods, properties, structs, enums) and then lets the user to perform some operations like add new method, delete a method or insert some line of code in an existing method.
At the moment to achieve it, I use a parser library (NRefactory from SharpDevelop) and then I thought to perform these operations using CodeDom functions.
But using CodeDom it's painful!! Is there any other library that I could use?
Is the method I described (NRefactory + CodeDom) the best way or is there something else I should try?
Thanks
|
|
|
|
|
MikiR wrote: the best way
Best in comparison to what? Measuring with what criteria?
Your question, or lack of one, suggests you might be better served focusing on getting something, anything to work.
|
|
|
|
|
Ok, forget "best way" phrase. It's the worst expression I ever used and
trust me, I'll never use it in my life! I promise!!
Now..Can I have an answer about my problem? It's there an easy ("easy" in comparison to what?) way (some libray, some helper class) that help me to use CodeDom to inserting piece of code, adding/removing methods to an already parsed c# class?
|
|
|
|
|
How can I read a connection string in web.config file from a windows app?
The ConfigurationManager.ConnectionStrings is not available from a windows project.
modified on Monday, March 16, 2009 12:07 PM
|
|
|
|
|
dptalt wrote: How can I accesses a web.config from a windows app?
From your post it is not clear what the technical problem is, nor what your question really is.
web.config is a file. Do you not know how to open a file?
|
|
|
|
|
Hi,
I am working under C# 2008 and SQL 2005 express edition.
To connect to database I used with Typed Dataset and all insert command I used with same object. I had over million rows.
At this object I implement Insert command. I glance in “TypedDataset.Designer.cs” file under my Typed Dataset at Insert command and see that Adapter open and close the connection after each insert execution.
My questions are:
1. This is necessary to open and close the connection all the time?
2. We cannot to leave the connection open?
3. What about performance?
4. There is another way to insert large quantities of rows to database?
Thanks,
Ido
|
|
|
|
|
Most modern database+platform systems use connection pooling[^] so the connection is not actually opened and closed each time.
|
|
|
|
|
hi,
Thanks.
so, the behavior is normally in spite of that i see on SQL Server Profiler Audit Login Audit Logout for each execution?
|
|
|
|
|
Ido wrote: so, the behavior is normally
You mean "normal"?
Ido wrote: in spite of that i see on SQL Server Profiler
I don't know what you are seeing. The generated code is designed to be used in pooling environments because that is very very common today. You may in fact not have one. If you don't there is a problem and you need to solve it. There may be many solutions and one or more might include modifying database server configurations.
|
|
|
|
|
Yes, I mean normal.
Thanks a lot you help me to understand about my problem.
Ido
|
|
|
|
|
Hope you get it worked out.
Why are your posts all in bold? It makes them difficult to read. You should stop doing that.
|
|
|
|
|
|
Hello
I've tried a lot of things already, but haven't got/found a satisfying solution.
Problem:
I have a custom control that inherits from Button. It's properties are shown in a PropertyGrid.
This control has some additional properties (which is no problem), but
I don't want to show all the standard properties like the whole Accessibility-Category and some more.
So is it possible to tell the propertygrid or the control which properties are going to be shown and which are not?
I have found to override and set the properties to "Browsable(false)", but isn't there more elegant and cleaner way to do this?
Is it possible to exclude a whole category?
The ideal case would be that my customButton only shows the Appearance, Behaviour, Design and Layout Cetagory and my own properties, but nothing else.
Thanks a lot in advance for your help
|
|
|
|
|
No, unfortunately not. That's the idea behind inheritance, you add to something, not take away from it. MS do it themselves of course but they don't give us the option.
The best you can do is declare the property as new instead of override, that way you can make it readonly by only providing a getter and decorating with these attributes.
[Browsable(false),
DesignerSerializationVisibility(DesignerSerializationVisibility.Hidden),
Obsolete]
public new string Text
{
get { return base.Text; }
}EditorBrowsable(EditorBrowsableState.Never) has no effect.
DaveBTW, in software, hope and pray is not a viable strategy. (Luc Pattyn)Visual Basic is not used by normal people so we're not covering it here. (Uncyclopedia)
|
|
|
|
|
Thanks a lot
I implemented it that way then.
But then occurs another question:
- I am not able to hide the "Desgin-Category" properties like (Name) and Locked.
and i couldn't find a solution on net, just some more asking for help
Is it possible to hide it, because the name is simply irrelevant in my application.
Thanks
|
|
|
|
|
No you can't. The Name property is just the name given to that particular instance of the class. Just like doing
TextBox textBox = new TextBox();
The Name of that particular instance is now textBox. It's extremely rare that the Name isn't needed.
For future reference, if you derive from System.ComponentModel.Component you don't get any of the superfluous properties, events or methods. You also get a Component not a Control though. Control derives from Component however so it may be possible to create your own Control class from Component with some work, that doesn't have the unecessary stuff. That would make a great article!
The Control class definition is
public class Control : Component, IDropTarget, ISynchronizeInvoke, IWin32Window, IBindableComponent, IComponent, IDisposable
{
}
DaveBTW, in software, hope and pray is not a viable strategy. (Luc Pattyn)Visual Basic is not used by normal people so we're not covering it here. (Uncyclopedia)
|
|
|
|
|
Java is open source language. Microsoft .Net Framework is not open source. I can open Microsoft .Net dll files with using reflector. Example for Abs function in Net Framework;
mscorlib --> System --> Math --> Abs
public static int Abs(int value)
{
if (value >= 0)
{
return value;
}
return AbsHelper(value);
}
private static int AbsHelper(int value)
{
if (value == -2147483648)
{
throw new OverflowException(Environment.GetResourceString("Overflow_NegateTwosCompNum"));
}
return -value;
}
So I can see dll files code and I can modify it. Thus it became open source, will you?
|
|
|
|
|
1) Java is a language, .NET is a framework, you're comparing apples with beef. If you want to compare languages, try and compare Java to C#. Or compare the Virtual Machines. Or.. learn what the definition means
2) Being able to "read" compiled source doesn't make it open source.
3) What are you trying to achieve with this post?
I are troll
|
|
|
|
|
Eddy Vluggen wrote: Java is a language, .NET is a framework, you're comparing apples with beef.
Actually, .Net would be pork, as in "full of".
"Why don't you tie a kerosene-soaked rag around your ankles so the ants won't climb up and eat your candy ass..." - Dale Earnhardt, 1997
-----
"...the staggering layers of obscenity in your statement make it a work of art on so many levels." - Jason Jystad, 10/26/2001
|
|
|
|
General 
News 
Suggestion 
Question 
Bug 
Answer 
Joke 
Praise 
Rant 
Admin 
Submit an article or tip
