|
|
Hi All,
I like to do some Excel File operation in my C# windows application.
but i cant find this Microsoft Excel 11.0 Object Library in Add Reference ---> com tab
where can i find this.....?
plz help me out
With Regards
Amjath
|
|
|
|
|
There is a seperate download for interop with Office, that could be what you need. The COM objects yuo need are also not installed unless the right version of Office is installed. Nothing comes with the IDE, least of all the express edition.
Christian Graus - Microsoft MVP - C++
"I am working on a project that will convert a FORTRAN code to corresponding C++ code.I am not aware of FORTRAN syntax" ( spotted in the C++/CLI forum )
|
|
|
|
|
Amjath Rahman wrote: Microsoft Excel 11.0 Object Library
It is installed with MS Office 2003...
"Real programmers just throw a bunch of 1s and 0s at the computer to see what sticks" - Pete O'Hanlon
|
|
|
|
|
I created a static MFC DLL in VC++ 8.0 in .NET and created a method and put the export declaration in both header and source file as __declspec(dllexport) for that function.Then .NET i created a wrapper DLL in C# like
[DllImport("XCENSettingsManager.dll", EntryPoint = "CreatePatientFolders",
CallingConvention = CallingConvention.StdCall)]
public static extern int CreatePatientFolders(string pPatientID);
XCENSettingsManager.dll is the VC++ DLL.Now i created a windows application in C# and called the method i.e.CreatePatientFolders which is a method in XCENSettingsManager.dll.Now it is giving error saying "Could not able to load XCENSettingsManager.dll or the module is not found.Can any one help me.
|
|
|
|
|
hi!
is it possible to create my own report writer? wherein the end-user of the application will be the one who will customize the report. if it is how could it be done?
any suggestions will be greatly appreciated!
|
|
|
|
|
What do you mean by creating your own report writer? Do you mean your own reporting engine like Crystal Reports or Report Viewer, etc?
"Real programmers just throw a bunch of 1s and 0s at the computer to see what sticks" - Pete O'Hanlon
|
|
|
|
|
here is the background of what i am doing.. i need to create a application wherein the user will be the one customizing the report to their liking. For example they would just drag and drop fields that they want to be included in the report.
|
|
|
|
|
Well, if you've committed to doing it, it's probably too late to ask if it's possible. It obviously is possible, but perhaps a fair amount of work.
Christian Graus - Microsoft MVP - C++
"I am working on a project that will convert a FORTRAN code to corresponding C++ code.I am not aware of FORTRAN syntax" ( spotted in the C++/CLI forum )
|
|
|
|
|
is there any guide out there on how to do this?
|
|
|
|
|
Thats almost like asking whether there's a "designing skyscrapers for beginners" book for new building architects!
By way of some pointers, you are going to want to do a few things
1) Display to the user all of the fields available to report on
2) Provide the user a way to select one or more fields
3) Provide the user a way to aggregate data (sum, avg, etc)
4) Provide a view of the selected data in a graphical or tablulated way.
There are plenty of apps out there that do this, and I would personally evaluate a number of them before embarking on writing this myself. One I have used (but didnt like much) was called Viper by a company called SmartFocus (i think).
|
|
|
|
|
i actually dont have any idea how to start on it. i searched on the net for any sample apps and i cant find Viper.
|
|
|
|
|
I assume then that you've not done too much programming - in which case this is probably too ambitious for a first project!
|
|
|
|
|
this is not my first project. my other projects are not like this.
i came here to ask for some guide or help or any suggestions and not to be commented like this.
|
|
|
|
|
Sorry, but you asked such a broad-ranging question there is no other answer possible.
Try reading the suggestions for getting a decent response to your question!
|
|
|
|
|
There really isn't going to be anything out there that you can just do this. It is a task of pretty good size like the others have said. Best thing you could probably do is to have some kind of form that the user creates his/her reports and apply their designed "report" to an already existing reporting engine like Crystal Reports or Report Viewer. The steps required/code required to do this is beyond the scope of a discussion forum.
"Real programmers just throw a bunch of 1s and 0s at the computer to see what sticks" - Pete O'Hanlon
|
|
|
|
|
Hi there
I've done something a little like it years back :
Let the end-user define a word document with fields, and then use your c# program to start word and fill the word fields.
This wey your user get to define their own design, and you get a programing project that can be done i relative short time. (compared to writng a new report designer).
Yours
Wilco
|
|
|
|
|
wilcodk wrote: Let the end-user define a word document with fields, and then use your c# program to start word and fill the word fields.
I've seen that done, and it really isn't that difficult to implement. Maybe it is something the OP ought to consider 
"Real programmers just throw a bunch of 1s and 0s at the computer to see what sticks" - Pete O'Hanlon
|
|
|
|
|
I have one question. I asked in several forums about it but i got no reply.... Hope I will get some ideas here...
My code is as following.
mshtml.HTMLDocumentClass objHTMDocCls = base.Explorer.Document as mshtml.HTMLDocumentClass;
I'd like to call like "objHTMDocCls.childNodes.length" or "objHTMDocCls.childNodes.item(1)". But there is no property like that in childNodes.
How can I get the length and subitem of childNodes?
Note: Explorer is a WebBrowserClass.
Thanks in advance.
|
|
|
|
|
I got the answer as below from sonal.india[^]
To get the child count of an element IHTMLDocument2 can be used like this:
IHTMLDocument2 doc = this.browser.Document as IHTMLDocument2;
IHTMLElementCollection elemCollection = doc.all as IHTMLElementCollection;
IHTMLElement elem = elemCollection.item(name, null) as IHTMLElement;
IHTMLElementCollection elemChildren = (IHTMLElementCollection)elem.children as IHTMLElementCollection;
int childCount = elemChildren.length;
and IHTMLDocument3's childNodes property gives direct children of a document.
sonal
Thanks a lot. Sonal.
|
|
|
|
|
if some one can tell how to block pages.
i have small website and have abought 10 pages but when i copy
and put it in browser they open i want block that want to redirect them to login page .
thank you
|
|
|
|
|
daku1 wrote: if some one can tell how to block pages.
.
I'm not so sure what you meant by "how to block pages". 
daku1 wrote: when i copy
and put it in browser
How did you put all of your 10 pages in browser?
I think your question may be related to ASP.NET or web development. so please ask in ASP.NET section.
Maybe. you may use "Form authentication" in your project to achieve that goal..
|
|
|
|
|
I feel a bit dumb, but: How do I add an icon resource to a custom Windows Forms control? I want to draw that icon in the OnPaint override.
|
|
|
|
|
Hi,
you can add an .ico file to your project, then set the build action to "embedded
resource". In order to access it, you need some code I can't remember, but
Visual knows how, so set your form's icon to it with the Designer, then watch
what code got generated to do it.
But then you want to paint it in an OnPaint method ? Normally you don't paint
icons, you can paint text, lines, images. Icons are special, they get used
first and forall by the form. No painting involved, just set the form's Icon
properety to point to it.
If you want to draw an image (not an icon!) somewhere inside your form,
you can store that too as a resource; almost the same procedure.
|
|
|
|
|
Hello,
Like Luc suggested:
you can add an .ico file to your project, then set the build action to "embedded
resource".
To instanciate the Icon, you would have to use following constructor:
http://msdn2.microsoft.com/de-de/library/b5bzkwt9(VS.80).aspx[^]
The parameters are
1) A Type, which represents the Assembly in which the ressource is expected.
2) A string, which represents the name of the ressource.
To Draw the Icon, you could use: Graphics.DrawIcon
private System.Drawing.Icon yourIcon = null;
protected override void OnPaint(PaintEventArgs e)
{
if(yourIcon==null)
{
yourIcon = new Icon(typeof(YourNameSpace.ExampleControlClass), "YourIconName");
}
if(yourIcon!=null)
{
e.Graphics.DrawIcon(yourIcon, 10,10);
}
base.OnPaint (e);
}
All the best,
Martin
|
|
|
|
General 
News 
Suggestion 
Question 
Bug 
Answer 
Joke 
Praise 
Rant 
Admin 
Submit an article or tip
