|
I have a plugin to Excel that works normally when excel is launched as a standalone application. However, when i open up excel in a dsoframer.ocx control, it does not enable the button. We have verified any discrepancies in our code.
My question is does the dsoframer control disable all plugins to the application or is there something that we are doing differently.
|
|
|
|
|
Hi All,
Has anybody implemented copying from excel and pasting on to Datagrid.
Thanks
Ruchi
|
|
|
|
|
This should work, I just threw it together so you will need to test it, but you should be able to get the idea.
IDataObject obj = Clipboard.GetDataObject();
DataTable table = new DataTable();
string data = string.Empty;
Char delim = ',';
if(obj.GetDataPresent(DataFormats.CommaSeparatedValue))
{
StreamReader reader = new StreamReader((Stream)obj.GetData(DataFormats.CommaSeparatedValue));
while(reader.Peek() > 0)
{
data = reader.ReadLine();
string[] arr = data.Split(delim);
if(table.Columns.Count <= 0)
{
for(int i = 0; i < arr.GetUpperBound(0);i++)
table.Columns.Add();
}
DataRow row = table.NewRow();
for(int j = 0; j < arr.GetUpperBound(0);j++)
{
row[j] = arr.GetValue(j);
}
table.Row.Add(row);
}
reader.Close();
dataGrid.DataSource = table.DefaultView();
}
- Nick Parker
My Blog | My Articles
|
|
|
|
|
When you copy data in Excel, it uses several clipboard formats to store data (actually, quite a few more than "several"). Several of these will work, but your best bet is to use the "Csv" clipboard format):
IDataObject data = Clipboard.GetDataObject();
if (data != null)
{
string csv = data.GetData("Csv") as string;
if (csv != null)
{
using (StringReader reader = new StringReader(csv))
{
string line = null;
while ((line = reader.ReadLine()) != null)
}
}
}Where I've placed the comment you can either take the cheap way out and use line.Split(',').Trim('\"'), or parse it correctly by using a token reader. While there's no standard CSV format, the agreed-upon convention is to quote a field when the field value contains a comma (since the file is comma-delimited). So, when you encounter a quote set a flag (or increment a variable, whatever). When you encounter a comma, if the flag is set, then don't split the line. When you enounter the next quote, reset the flag. As long as that flag isn't set, you can split the field at the comma when you hit one.
There's other formats you can use as well. Excel 2003 copies the new standard Excel XML format to the clipboard, as well as many other formats (both text and binary formats).
You can use Mike Dunn's ClipSpy[^] to view the different formats, as well as the data those formats contain.
The real trick here is that you have to have some way to paste into the DataGrid. Once one of the cells is in edit mode, the DataGrid receives little to no notification; the control being hosted in the current cell is receiving notifications. You could either use a paste button or jump through hoops to support Ctrl+V (or the mouse) to paste into the DataGrid.
From there, it's as simple as the getting the data source (taking both DataSource and DataMember into account) and adding a new row/object for each line and, if applicable, each field in that row for each imported field from the CSV clipboard format.
And easy way is to use the CurrencyManager like so:
CurrencyManager cm = (CurrencyManager)dataGrid1.BindingContext[
dataGrid1.DataSource, dataGrid1.DataMember];
if (cm != null)
{
IList list = cm.List;
if (list is DataView)
{
DataTable dt = ((DataView)list).Table;
foreach ()
DataRow row = dt.LoadDataRow(line.Split(','), false);
}
}
Microsoft MVP, Visual C#
My Articles
|
|
|
|
|
Im trying to repaint a window from handle.
I get its handle and call and API function
RedrawWindow, but it works half of the time.
The way its set up in my program. I have a global hook to mouse, on mouse move, my program gets the window handle to the window under mouse, from that handle i get device context, from dc I get the Graphics object and then paint a red rectangle over the window. Which works but in order to erase the rectangle when mouse is moved to a different window I have to cause the repaint event I presume.
I set that up, and the red rectangle gets "erased" about 30% of the time. I noticed only when I move the mouse to the lower edge of the screen and move it around then all rectangles get deleted. This is probably confusing so here is the code that needs help.
private void MovingMonitor(object sender, MouseEventArgs e)
{
//draws rectangle over point
//get handle of mouse over window
Point mousePoint = new Point(e.X,e.Y);
//get the window
IntPtr handle = USER32.GetAncestor(USER32.WindowFromPoint(mousePoint),2);
//get dc
IntPtr currentDC = USER32.GetWindowDC(handle);
if(stillWorking)
{
}
}
else
{
stillWorking = true;
if(lastHandle.Equals(handle))
{
testDraw = Graphics.FromHdc(currentDC);
//draw box around that window
USER32.Rect dcRect= new USER32.Rect();
USER32.Rect regionRect = new USER32.Rect();
USER32.GetWindowRect(handle,ref dcRect);
USER32.GetWindowRgnBox(handle,ref regionRect);
int width,height;
switch(USER32.GetWindowRgn(handle,GDI32.CreateRectRgn(0,0,0,0)))
{
case 0:
width = dcRect.x2 - dcRect.x1;
height = dcRect.y2 - dcRect.y1;
break;
case 2:
width = (dcRect.x2 - dcRect.x1)-(regionRect.x1+(dcRect.x2 - dcRect.x1)-regionRect.x2);
height = (dcRect.y2 - dcRect.y1)-(regionRect.y1+(dcRect.y2 - dcRect.y1)-regionRect.y2);
break;
case 3:
width = dcRect.x2 - dcRect.x1;
height = dcRect.y2 - dcRect.y1;
break;
default:
MessageBox.Show("Unexpected window style. Screencap may fail. Please e-mail pacemkr@optonline.net with details.",
"Warning!",MessageBoxButtons.OK,MessageBoxIcon.Warning);
width = dcRect.x2 - dcRect.x1;
height = dcRect.y2 - dcRect.y1;
break;
}
testDraw.DrawRectangle(new Pen(Color.Red,4),regionRect.x1,regionRect.y1,width,height);
}
else if(!(lastHandle.Equals(handle)))
{
//IntPtr lastDC = USER32.GetWindowDC(lastHandle);
//testDraw = Graphics.FromHdc(lastDC);
if(last!=0)
{
USER32.Rect dcRect= new USER32.Rect();
USER32.GetWindowRect(lastHandle,ref dcRect);
USER32.InvalidateRect(lastHandle, ref dcRect,false);
USER32.UpdateWindow(lastHandle);
message.UpdateMessage(i.ToString());
i++;
}
last++;
}
lastHandle = handle;
stillWorking = false;
}
}
All I want to do is draw a box around the window that my mouse is over.
Any ideas, questions, clues, are very much welcome.
Thanks.
|
|
|
|
|
Sounds like a performance issue. Wrapping a Graphics object around an HDC is expensive enough, not to mention all the marshaling involved when you're P/Invoking native APIs.
I would recommend writing an MC++ assembly using native APIs to avoid the marshaling, and don't use a Graphics object: just use GDI APIs (they're really pretty easy for what you're doing) directly. Your C# assembly could reference this assembly and do whatever it needs to. This should greatly improve performance.
I've had to do something similar before when adding functionality to the TreeView class in the BCL and noticed the same thing. If I went slowly (slow mouse movement, etc.) the drawing was fine. It was when I moved at normal or faster speeds that the problem was most definitely obvious.
Microsoft MVP, Visual C#
My Articles
|
|
|
|
|
"I would recommend writing an MC++ assembly using native APIs to avoid the marshaling"
I'm not quite sure what marshaling is. Is it when I import the API functions? So how would I avoid that?
Thank you for the other tip on dumping the use of Graphics. I'll work on that now and get back with results. Will probably test the code for speed too. So its certain that the problem is performance. I do that using Environment.TickCount. I dont know if thats the best way, but it gives me an idea of how fast things are done during runtime.
|
|
|
|
|
Marshaling describes when memory is transfered from one context to another where the representation may not be the same (.NET marshals objects across AppDomains and ContextBoundaries, and COM (or the host) marshals objects with any external call including to and from .NET). This can be a time consuming process.
Microsoft MVP, Visual C#
My Articles
|
|
|
|
|
Hmmm. I just put
int tick = Environment.TickCount;
on top of the handler and
tick = Environment.TickCount-tick;
MessageBox.Show(tick.ToString());
on the bottom. I run the code, most messageboxes show 0, some show 16 milliseconds to run the whole function.
You still think it might be a performance problem?
I'm not sure, I'm still gonna try only using API calls.
|
|
|
|
|
Is there a program that would allow me to view the messages sent to a particular process. I really feel that the window never gets the message to repaint unless its sent a couple of dozen times. I'm using Bordlands C# Builder if thats relavant, I dont have spy++ or the C# equivalent. (if I'm even correct at assuming that spy++ does what I need)
I looked at the API calls that would draw the rectangle and it looks like only GDI+ can do DrawRectangle. And that function is part of Graphics class. Which looks like the exact equivalent of Graphics.DrawRectangle(). Even in terms of arguments. The tick count to perform DrawRectangle on the graphics object is 0 ms.
Thank you for taking the time to help out.
|
|
|
|
|
Spy++ doesn't have a C# (remember, too, that all managed languages compile to IL, so it would really be a .NET equivalent) because it doesn't need it: .NET (that's Microsoft's implementation of the Common Language Infrustructure (CLI)) wraps the common controls for Windows Forms controls so messages are passed like with any native Win32 application.
If you don't have Visual Studio (any version since 5.0, IIRC, will do) available or installed, you could try Winspector[^]. I have no idea how good it is, since I found it quickly by doing a search on google.
Microsoft MVP, Visual C#
My Articles
|
|
|
|
|
Excelent program thanks for the link.
And I was right the window never gets the WM_PAINT message untill I start moving at the top or bottom edge of the screen. So its a fault with the InvalidateRectangle and UpdateWindow calls. Any ideas?
That winispector program does exactly what I want to do, it gives you a mechanism that lets you select the window and draws a red box around the window thats under the mouse. 
|
|
|
|
|
UpdateWindow sends the WM_PAINT message to the immediate window without posting to the message queue. Just make sure you're sending client coordinates and not screen coordinates.
Microsoft MVP, Visual C#
My Articles
|
|
|
|
|
Finally fixed.
I dont know what the problem was, deffinitely related to the API functions mentioned previously. However, drawing on the desktop DC instead of the individual window DC and then updating the desktop, solved the problem. One other way to solve my problem I guess could be using PostMessage to post the WM_PAINT message to the window manualy.
Thank you very much for you help Heath. You gave me a lot of usefull information that lead me to the solution.
And here is the working code, in case someone could find it usefull. I will be working on another approach to what this handler does, something that wont cause so much flickering on the screen and as soon as I have it, I will post the code in this thread or if someone could suggest the best place to put something like this just for refference.
private void MovingMonitor(object sender, MouseEventArgs e)
{
//draws rectangle over point
//get handle of mouse over window
Point mousePoint = new Point(e.X,e.Y);
//get the window
IntPtr handle = USER32.GetAncestor(USER32.WindowFromPoint(mousePoint),2);
//get dc
IntPtr currentDC = USER32.GetWindowDC(IntPtr.Zero);
if(stillWorking)
{
}
else
{
stillWorking = true;
if(lastHandle.Equals(handle))
{
testDraw = Graphics.FromHdc(currentDC);
//draw box around that window
USER32.Rect dcRect= new USER32.Rect();
USER32.Rect regionRect = new USER32.Rect();
USER32.GetWindowRect(handle,ref dcRect);
USER32.GetWindowRgnBox(handle,ref regionRect);
int width,height;
switch(USER32.GetWindowRgn(handle,GDI32.CreateRectRgn(0,0,0,0)))
{
case 0:
width = dcRect.x2 - dcRect.x1;
height = dcRect.y2 - dcRect.y1;
break;
case 2:
width = (dcRect.x2 - dcRect.x1)-(regionRect.x1+(dcRect.x2 - dcRect.x1)-regionRect.x2);
height = (dcRect.y2 - dcRect.y1)-(regionRect.y1+(dcRect.y2 - dcRect.y1)-regionRect.y2);
break;
case 3:
width = dcRect.x2 - dcRect.x1;
height = dcRect.y2 - dcRect.y1;
break;
default:
MessageBox.Show("Unexpected window style. Screencap may fail. Please e-mail pacemkr@optonline.net with details.",
"Warning!",MessageBoxButtons.OK,MessageBoxIcon.Warning);
width = dcRect.x2 - dcRect.x1;
height = dcRect.y2 - dcRect.y1;
break;
}
testDraw.DrawRectangle(new Pen(Color.Red,2),dcRect.x1+regionRect.x1,dcRect.y1+regionRect.y1,width,height);
first=1;
}
else if(!(lastHandle.Equals(handle)))
{
//IntPtr lastDC = USER32.GetWindowDC(lastHandle);
//testDraw = Graphics.FromHdc(lastDC);
if(first!=0)
{
USER32.Rect dcRect= new USER32.Rect();
USER32.GetWindowRect(IntPtr.Zero,ref dcRect);
USER32.InvalidateRect(IntPtr.Zero, ref dcRect,false);
USER32.UpdateWindow(IntPtr.Zero);
}
}
lastHandle = handle;
stillWorking = false;
}
}
|
|
|
|
|
Well this was relatively fast and easy.
Here is a MUCH better way to draw a box around the window that the mouse is moving over.
First create a new form. Magenta background. TransparencyKey magenta. TopMost true. ShowInTaskBar false. Normal window state. Any size and position. FormBorderStyle none.
Create a new onpaint event handler.
//this basically draws a nice 3d looking border INSIDE the form
private void ControlSelectorForm_Paint(object sender, System.Windows.Forms.PaintEventArgs e)
{
Graphics myGraphics = e.Graphics;
Pen myBlackPen = new Pen(Color.Black,1);
myBlackPen.Alignment = PenAlignment.Inset;
Pen myRedPen = new Pen(Color.Red,2);
myRedPen.Alignment = PenAlignment.Inset;
myGraphics.DrawRectangle(myBlackPen,0,0,this.Width-1,this.Height-1);
myGraphics.DrawRectangle(myRedPen,1,1,this.Width-2,this.Height-2);
myGraphics.DrawRectangle(myBlackPen,3,3,this.Width-7,this.Height-7);
}
Go to your main window mouse handler (which is linked to a system hook in my case, http://www.codeproject.com/csharp/globalhook.asp)
You should make it something like this and it does the job.
//selector is a global declaration of ControlSelectorForm and it is set to new ControlSelectorForm() on mouse click
//that starts the system wide mouse hook
private void MovingMonitor(object sender, MouseEventArgs e)
{
//get handle of mouse over window
Point mousePoint = new Point(e.X,e.Y);
//get the window
IntPtr handle = USER32.GetAncestor(USER32.WindowFromPoint(mousePoint),2);
USER32.Rect dcRect= new USER32.Rect();
USER32.Rect regionRect = new USER32.Rect();
USER32.GetWindowRect(handle,ref dcRect);
USER32.GetWindowRgnBox(handle,ref regionRect);
int width,height;
switch(USER32.GetWindowRgn(handle,GDI32.CreateRectRgn(0,0,0,0)))
{
case 0:
width = dcRect.x2 - dcRect.x1;
height = dcRect.y2 - dcRect.y1;
break;
case 2:
width = (dcRect.x2 - dcRect.x1)-(regionRect.x1+(dcRect.x2 - dcRect.x1)-regionRect.x2);
height = (dcRect.y2 - dcRect.y1)-(regionRect.y1+(dcRect.y2 - dcRect.y1)-regionRect.y2);
break;
case 3:
width = dcRect.x2 - dcRect.x1;
height = dcRect.y2 - dcRect.y1;
break;
default:
MessageBox.Show("Unexpected window style.",
"Warning!",MessageBoxButtons.OK,MessageBoxIcon.Warning);
width = dcRect.x2 - dcRect.x1;
height = dcRect.y2 - dcRect.y1;
break;
}
selector.Width = width;
selector.Height = height;
selector.Left = dcRect.x1+regionRect.x1;
selector.Top = dcRect.y1+regionRect.y1;
selector.Show();
}
|
|
|
|
|
Hi,
I'd like to use "contexMenu" in my "TreeView" for
specific "Node".
eg. I have TreeViev likes below ...
Node_1
Node_1.1
Node_1.2
Node_1.3
Node_2
Node_2.1
Node_2.2
Node_2.3
...and I want to use "contexMenu_1" for "Node_1.1"
and "Node_2.1" and
"contexMenu_2" for "Node_1.2" and "Node_2.2" etc.
It looks like "Microsoft Menagement Console"
I can use
treeView1.ContextMenu = this.contextMenu1;"
but I cannot use
treeView1.Nodes[number].ContextMenu =
this.contextMenu1;
I don't know how can I use "contexMenu in this case.
Thanks for help,
Kamil
|
|
|
|
|
Add a MouseUp event handler to the TreeView. In the event handler, it would look something like
private void treeView1_MouseUp(object sender, MouseEventArgs e)
{
if(e.Button == MouseButtons.Right)
{
TreeNode clickedNode = tv.GetNodeAt(MousePosition);
if(tv == node_1.1) treeView1.ContextMenu = contextMenu1;
else if (tv == node_1.2) ... and so on
}
}
#include "witty_sig.h"
|
|
|
|
|
Judah Himango wrote:
private void treeView1_MouseUp(object sender, MouseEventArgs e){
if(e.Button == MouseButtons.Right)
{
TreeNode clickedNode = tv.GetNodeAt(MousePosition);
if(tv == node_1.1) treeView1.ContextMenu = contextMenu1;
else if (tv == node_1.2) ... and so on
}
}
Thanks for advice but it not solve my problem, because it calls "NullException....".
...by the way it should be written in this way 
private void treeView1_MouseUp(object sender, MouseEventArgs e){
if(e.Button == MouseButtons.Right) {
TreeNode clickedNode = tv.GetNodeAt(MousePosition);
if(clickedNode == node_1.1) treeView1.ContextMenu = contextMenu1;
else if (clickedNode == node_1.2) ... and so on }
}
"NullException..." isn't call in this case.
private void treeView1_MouseUp(object sender, MouseEventArgs e){
if(e.Button == MouseButtons.Right) {
TreeNode clickedNode = tv.GetNodeAt(e.X, e.Y);
if(clickedNode == node_1.1) treeView1.ContextMenu = contextMenu1;
else if (clickedNode == node_1.2) ... and so on }
}
Thanks for your help.
Kamil
|
|
|
|
|
hello,
maybe this can help
private void treeView1_MouseUp(object sender, System.Windows.Forms.MouseEventArgs e)
{
if(e.Button == MouseButtons.Right)
{
System.EventArgs a = new EventArgs();
Point ClickPoint = new Point(e.X,e.Y);
TreeNode ClickNode = treeView1.GetNodeAt(ClickPoint);
ruletree.SelectedNode=ClickNode;
if(ClickNode == null) return;
Point ScreenPoint = ruletree.PointToScreen(ClickPoint);
Point FormPoint = this.PointToClient(ScreenPoint);
ContextMenu treeRCMenu = new ContextMenu();
MenuItem mnuRenamePNode = new MenuItem("Rename Node");
if(clickedNode == node_1.1)
{
treeView1.ContextMenu = contextMenu1;
}
else if (clickedNode == node_1.2) ... and so on }
}
be sure to have named you context menu items and initialized them, to use them , you might have to add the event hadler for them.
like:
MenuItem mnuRenamePNode = new MenuItem("Rename Parent Node");
MenuItem mnuRenameCNode = new MenuItem("Rename Child Node");
mnuRenamePNode.Click +=new EventHandler(mnuRenamePNode_Click);
mnuRenameCNode.Click +=new EventHandler(mnuRenameCNode_Click);
|
|
|
|
|
Hey,
I am trying to get a string returned from my managed code to my unmanaged code. Basically what I have so far is an interface as follows:
<br />
[ComVisible(true)]<br />
[InterfaceType(ComInterfaceType.InterfaceIsIUnknown)]<br />
[Guid("")]<br />
<br />
public interface IGet<br />
{<br />
void GetString([MarshalAs(UnmanagedType.LPWStr)] out string Value);<br />
}<br />
<br />
public class PropertyGet : IGet<br />
{<br />
public PropertyGet(Item item)<br />
{<br />
m_item = item;<br />
}<br />
<br />
public void GetString(out string Value)<br />
{<br />
Property prop = m_item.GetProperty();<br />
<br />
Value = prop.ToString();<br />
}<br />
}<br />
In the managed code
<br />
HRESULT CFileProperties(BSTR fileName, IGet pIGet)<br />
{<br />
WCHAR wszWideBuffer[1024];<br />
wszWideBuffer[0] = NULL_CHARACTER;<br />
pIGet->GetString(wszWideBuffer);<br />
}<br />
So in the managed code right now, the wszWideBuffer is filled with some wierd characters. So something is not marshalling correctly and with my limited experience I am not sure where to look for the problem. Most articles seem to handle passing strings the other way (i.e. getting a string back from the unmanaged which works in my property setting code.)
Any help would be appreciated.
Brian
If you start a fire for a man, he will be warm for a day. If you start that same man on fire, he will be warm for the rest of his life.
|
|
|
|
|
You need to pass the address of wszWideBuffer. String is already a reference type (a managed pointer, if you will), so out string is a pointer to a pointer, in essense. So, you should pass &wszWideBuffer.
On a side note, you might consider marshaling your string as UnmanagedType.BStr (which is a length-prefixed wide character array). This is more common in COM and necessary for OLE automation (if you plan on support automation clients like VB6 and older).
Microsoft MVP, Visual C#
My Articles
|
|
|
|
|
Thanks for the response.
I did try that and it caused me some issues with building the unmanaged code. However I was able to change the string to a stringbuilder which is listed as a both an in and out in the built type library. This was suggested in the big purple book that I borrowed from a friend.
Thanks,
Brian
If you start a fire for a man, he will be warm for a day. If you start that same man on fire, he will be warm for the rest of his life.
|
|
|
|
|
I would like to know if I can run microsoft.office.interop 11.0 (office 2003) on the .NET 1.0 framework?? And if I have both office.interop 10.0 and 11.0 assemblies on my pc, how do I force Visual Studio to use Office.Interop.Excel 10.0??
Kind regards,
Dries
|
|
|
|
|
The Office 11 PIAs (Primary Interop Assemblies) use .NET 1.1 (1.0.5000.0 for the .NET BCL assemblies), but you can redirect assembly versions to .NET 1.0 (1.0.3300.228 for .NET 1.0 BCL assemblies with SP2). Read Redirecting Assembly Versions[^] in the .NET Framework SDK for more information.
However, you should keep in mind that if you're not using any new features of Office 11 (2003), then you can use older interop assemblies. OLE automation - when done right like it is in Office - maintain backward compatibility (rarely have there been breaking changes in the typelibs for Office). But using a new interop assembly (which is created from a typelib) may not support older versions since interface IDs may be different.
If you want to support both Office XP and 2003, use the Office XP interop assemblies. They'll still work with Office 2003. If you want to support Office 2000 and newer, create interop assemblies for Office 2000. This should work all the way back to Office 97, but I wouldn't go beyond 2000, IMO.
Microsoft MVP, Visual C#
My Articles
|
|
|
|
|
I've implemented the IDropTargetHelper and IDragSourceHelper COM interfaces to augment my drag drop support. So far I can create the IDropTargetHelper interface and call the respective methods will absolutely no problem. I should be able to use the exact same logic to create and use an IDragSourceHelper objedt. For some reason I get the following error when trying to create the object:
"COM object with CLSID {DE5BF786-477A-11D2-839D-00C04FD918D0} is either not valid or not registered."
I've triple checked and the GUID is correct for the IDragSourceHelper interface. Does anyone know what can be done here? Does somet DLL need to be registered? I'm out of ideas.
Thanks
|
|
|
|
|
General 
News 
Suggestion 
Question 
Bug 
Answer 
Joke 
Praise 
Rant 
Admin 
Submit an article or tip
