|
Thanks for the example code. Using the Ole DB interface is alot more abstract so I like the idea of using the Excel object model. However when I try to add the reference I do not have the Microsoft Excel 11.0 Object Lbrary. That is why I was asking about the DLL. Do I need to download a SDK to the object library?
Mike
|
|
|
|
|
What version of MS Office do you have? This code was built using MS Office 2003. The file being reference is the actual Excel.exe of your installed Office product.
I reject your reality and substitute my own!
- Adam Savage, Mythbuster
- George W Bush
life is like a roll of toilet paper. The closer it gets to the end, the faster it goes.
My definition of an expert in any field is a person who knows enough about what's really going on to be scared.
- PJ Plauger
|
|
|
|
|
Slight progress, I have Office Xp aka Office 2002 (10.6713.6735) SP3 for Excel. SO.. I found the Excel 10.0 Object Library under COM components. And when I try to "new" the excel object, i.e. a Excel.Application, it only has Excel.ApplicationClass. Not exactly what I need, so I am wondering if I have to upgrade to the later version of Office (2003)?
Mike
|
|
|
|
|
You want to look in the object browser. The application is actually an inerface for the Excel object. Unfortunately I don't have a system with OfficeXP on it. With was little, and I mean little, I read on this subject it should work the same. I have users that OfficeXP installed and are able to use my application that I wrote referencing Office 2003.
I reject your reality and substitute my own!
- Adam Savage, Mythbuster
-George W Bush
life is like a roll of toilet paper. The closer it gets to the end, the faster it goes.
My definition of an expert in any field is a person who knows enough about what's really going on to be scared.
- PJ Plauger
|
|
|
|
|
To use the latest version of all this stuff, you need to have .Net 2005 and Office 2003. Anything less can cause issues.
|
|
|
|
|
In Pocket PC. How i can catch event right mouse(tap and hold in screen) on a control
Nothing
|
|
|
|
|
If you want to use a context menu then you should use the ContextMenu control. If you want to override this and provide your own functionality then you have to write it manually by using the MouseDown and MouseUp events (possibly with a Timer - it depends on what you want to do, e.g. perform the action while holding, or on the MouseUp)
ColinMackay.net
Scottish Developers are looking for speakers for user group sessions over the next few months. Do you want to know more?
|
|
|
|
|
I have a program right now that can read from a bitmap and then paint each pixel to a screen (I do this instead of choosing Graphics.DrawImage for transparency reasons). However, I wanted to take any character (like 'a' or ';'), and write it to a Bitmap. Is there a way to do this?
Mike - I love to program!
|
|
|
|
|
Use the DrawString of the Graphics class to draw text. Use the FromImage method to get a Graphics object for the bitmap.
---
b { font-weight: normal; }
|
|
|
|
|
So I create a graphics object, then call DrawString, then I call the FromImage method of the Bitmap class and pass in the graphics object?
Mike - I love to program!
|
|
|
|
|
No, the other way around. You use the FromImage method of the Graphics class to create the Graphics object for the bitmap, then you use the Graphics object to draw on the bitmap.
---
b { font-weight: normal; }
|
|
|
|
|
I posted a message yesterday about my program that upload/downloads files from a MySql database. Everything is working good but I probably need to encrypt the connection string. Can anyone point out some good articles about doing this in C# 2.0 (windows forms app)?
Thanks for any responses,
Sean
|
|
|
|
|
|
Thanks. I'll have a look at that. Also I just ran into a problem that I should have seen coming. For bigger files I need to send the data to the database in packets. But I have no idea how Any articles you know of that will solve my problem?
|
|
|
|
|
Hi all
how can i write a code in C# and Managed directX that can makes me import *.X files and move them like the same way directX viewer do, i am already now can import the *.x files , but the difficult thing for me is move them like that way directX viewr did
thx all
|
|
|
|
|
That is actually nohting simple. You're going to have to transform the device based on input from the user, which is far too large a subject for this post. I suggest you ask this question over at gamedev.net's .NET game programming forums.
Tech, life, family, faith: Give me a visit.
I'm currently blogging about: Moral Muscle
The apostle Paul, modernly speaking: Epistles of Paul
Judah Himango
|
|
|
|
|
How to print the text from a richtextbox, but with the fonts it's written in it. For example
in a RTB i have a part wich is BOLD and the rest is REGULAR. How to print it as it is, and not all the text in BOLD or REGULAR ???
-- modified at 13:06 Sunday 12th March, 2006
|
|
|
|
|
|
No use of that, i want to print it anywhere on the paper, and not only that...
This example alows only to print the richtextbox text on a paper and nothing more... if you understand what i mean...
|
|
|
|
|
That article is an example so that you can modify it to your needs.
- To print anywhere on the page just change
rectToPrint to the rectangle you need to print onto. - If again, I understand you correctly you want to be able to print onto Forms as well as the printer? To do this then just redefine the Print method to accept a Graphics object instead of PrintPageEventArgs, then draw using this graphics and not the printer graphics, you can then pass a form's graphics canvas and print the contents of the richtextbox onto that form.
Ed
|
|
|
|
|
How to change te rectToPrint??? I dont won't it to be constant. I want it to be variable
|
|
|
|
|
It is a variable
Ed
|
|
|
|
|
I cant change it, it's not public, and i can't make it public, so it is a variable but it's not variable...
|
|
|
|
|
|
Ok, tnx...
I tried it before on my laptop several times, and it didnt work... Now I tried on my PC and it did... Sorry for bothering...
|
|
|
|