C# Discussion Boards - CodeProject

Re: Opening Excel workbook

25-Sep-02 12:56

Debug.WriteLine(string text);

Trace.WriteLine(string text);

Console.WriteLine(string text);

Give them a chance! Do it for the kittens, dear God, the kittens!
As seen on MS File Transfer: Please enter an integer between 1 and 2.

Opening Excel workbook

Donald Blachly25-Sep-02 10:26

Donald Blachly

25-Sep-02 10:26

I am trying to open an Excel workbook to use in my C# application. I have found many examples of opening a blank (new) workbook using new Excel.Application(). How do I open a specific xls file using Excel.Application ?

//open Excel with new workbook
Excel.Application excel = new Excel.Application();
excel.Application.Workbooks.Add(true);
excel.Application.Visible = true;

I have been able to open a specific file using Process

string path = "C:\\";
string file = "flow.xls";
System.Diagnostics.Process xlProcess = new System.Diagnostics.Process();
xlProcess.EnableRaisingEvents = false;
xlProcess.StartInfo.FileName = "excel";

xlProcess.StartInfo.Arguments = path + file;
xlProcess.Start();

as long as the path has no spaces.

But with a path like
string path = "C:\\Documents and Settings\\userName\\My Documents\\data\\FlowData\\flow.xls";

I also tried a verbatim string
string path = @"C:\Documents and Settings\userName\My Documents\data\FlowData\flow.xls";

How do I add the spaces to the path?

When you come to a fork in the road, take it! Y. Berra

Stephane Rodriguez.25-Sep-02 21:11

Stephane Rodriguez.

25-Sep-02 21:11

Excel.Application excel = new Excel.ApplicationClass();
excel.Visible = true; // remove this line to keep excel silent
Excel._Workbook wbk2 = excel.Workbooks.Open(@"c:\mydoc.xls",true,true,true,true,true,true,true,true,true,true,true,true);

if you start putting in too manay features, it no longer remains useful for beginners
quote in a CP article comment, shiraz baig

Re: Opening Excel workbook

Donald Blachly26-Sep-02 3:50

Donald Blachly

26-Sep-02 3:50

Great

Thanks

When you come to a fork in the road, take it! Y. Berra

How to activate event procedure

D Shen25-Sep-02 9:42

25-Sep-02 9:42

Hi,

I am looking for a way to activate an event procedure, such as combox_clicked, without really clicking on the control . I remember in VB we can do thing like that (combox_clicked = true). Just wonder can we do this in C#? I appreciate your inputs.

leppie25-Sep-02 9:57

25-Sep-02 9:57

Hi
You just need to call the event handler Smile | :)

Like:

First derive from Button, then add the following:

public void CallButtonClick()
{
base.OnClick(this, EventArgs.Empty);
}

Now , call the function from your code Smile | :)

Hope this helps, there seems to be many ways to do this though.

Give them a chance! Do it for the kittens, dear God, the kittens!

D Shen25-Sep-02 10:51

25-Sep-02 10:51

Hi Leppie,

I am not sure if I understand what you mean by Confused | :confused:

leppie wrote:
First derive from Button, then add the following:

public void CallButtonclick()
{
base.onclick(this, EventArgs.Empty);
}

Can you please give more detailed explaination? I really appreciate that!!;)

leppie25-Sep-02 11:55

25-Sep-02 11:55

D Shen wrote:
I am not sure if I understand what you mean by

It's the beauty of inheritance Smile | :)

OK. Lets see how/why I say that Smile | :)

1. What we want is a button that we can programatically fire events. It makes sense to add this functionality to the Button class. So we make one:

public class ButtonEx():System.Windows.Forms.Button
{
  public void CallButtonclick()
  {
    base.OnClick(EventArgs.Empty); // sorry mistake in first post :)
  }
}

2. We replace our existing Button in the in the form with our new ButtonEx.

private System.Windows.Forms.Button button1; //now becomes
private ButtonEx button1;

And in the windows forms designer region, change :

button1 = new System.Windows.Forms.Button(); //now changes to
button1 = new ButtonEx();

Be sure to save before viewing in the designer(in fact close it beforehand, it does more harm than good Laugh | :laugh:

).

3. Finally we just call our new ButtonEx's CallButtonClick methods as follows:

button1.CallButtonClick();

NOTE: If you'll be calling this method from thread u will need to invoke it. I'm not 100% sure, but it would look something like this:

button1.Invoke( new MethodInvoker(button1.CallButtonClick));

Hope this adds some insight Smile | :)

Give them a chance! Do it for the kittens, dear God, the kittens!

D Shen26-Sep-02 3:50

26-Sep-02 3:50

Thank you, leppie. It really helps! Laugh | :laugh:

D Shen26-Sep-02 4:15

26-Sep-02 4:15

leppie,

Here comes a minor problem Blush | :O

When I compile the code, I got "...does not contain a definition for..." this button1.
I followed the order you post here, but.... Unsure | :~

Please help!!

D Shen26-Sep-02 4:26

26-Sep-02 4:26

leppie,

I found the problem, it was so stupid.....(typo Blush | :O

)

leppie26-Sep-02 7:17

26-Sep-02 7:17

Hehe, thought it was either that or the designer screw'd up the UI Laugh | :laugh:

Give them a chance! Do it for the kittens, dear God, the kittens!
As seen on MS File Transfer: Please enter an integer between 1 and 2.

leppie25-Sep-02 12:08

multiple search patterns with Directory.GetFiles?

25-Sep-02 12:08

Sorry, I'm a bit DOPEY Blush | :O

I didnt see that it was a combobox you were talking about, but the way to do it is the same, just follow the steps Smile | :)

Give them a chance! Do it for the kittens, dear God, the kittens!

Wjousts25-Sep-02 9:41

Wjousts

25-Sep-02 9:41

Does anybody know if there is a way to use the GetFiles method to retrive files using more than one search pattern (similar to what you can do with the OpenFileDialog class). For example, I want to use the GetFiles method to return all image files with the *.jpg, *.bmp, *.gif, etc extensions but it seem the method will only take one at a time and won't accept a string in the same format as the the FileDialog class. I thought about making multiple calls to GetFiles and putting the results into a stack and then popping them out one-by-one to sort them together into one array but I wanted to see if anybody could come up with an easier way.
Thanks

Re: multiple search patterns with Directory.GetFiles?

Paul Riley25-Sep-02 10:29

Paul Riley

25-Sep-02 10:29

There isn't a very easy way but you could get all the files, regardless of extension and then remove all the ones that don't fit the profile (a quick RegEx will do that neatly).

Paul

Here is a tough one - DataGrid throwing exception while repainting

Luis Alonso Ramos25-Sep-02 7:25

Luis Alonso Ramos

25-Sep-02 7:25

I have this code in my Clear() routine:

ds.Tables[0].Rows.Clear();
grdProducts.Refresh();

ds is an in-memory DataSet, not associated with any database, a simple way to access what's in the DataGrid. grdProducts if of course a DataGrid.

The problem is that most of the times I run this code there's an unhandled NullReferenceException exception ("Object reference not set to an instance of an object").

Looking at the stack trace, it happens when the DataGrid is painting itself (after a WndPaint event). If I omit the grdProducts.Refresh() call in my code, I don't see any of my functions in the stack trace, but adding it makes the function in progress appear several levels down the trace (obvious).

Any ideas??

-- LuisR

──────────────
  Luis Alonso Ramos
  Chihuahua, Mexico
  www.luisalonsoramos.com

"Do not worry about your difficulties in mathematics, I assure you that mine are greater." -- Albert Einstein

Re: Here is a tough one - DataGrid throwing exception while repainting

leppie25-Sep-02 7:45

Re: Here is a tough one - DataGrid throwing exception while repainting

25-Sep-02 7:45

Hi
I cant seem to see the problem... Confused | :confused:

But I have a suggestion is that as you are trying the clear the rows, clearing the table would have the same effect, so will clearing the Columns. Perhaps a cross reference is causing the null reference exception.

Hope this helps Smile | :)

Give them a chance! Do it for the kittens, dear God, the kittens!

Luis Alonso Ramos25-Sep-02 9:05

Luis Alonso Ramos

25-Sep-02 9:05

leppie wrote:
But I have a suggestion is that as you are trying the clear the rows

I'm trying to clear the records that the user added. Any other way to do it??

One time, and only one time, I saw another exception about a negative row number. Confused | :confused:

-- LuisR

──────────────
  Luis Alonso Ramos
  Chihuahua, Mexico
  www.luisalonsoramos.com

"Do not worry about your difficulties in mathematics, I assure you that mine are greater." -- Albert Einstein

Re: Here is a tough one - DataGrid throwing exception while repainting

leppie25-Sep-02 9:20

Re: Here is a tough one - DataGrid throwing exception while repainting

25-Sep-02 9:20

Hmm, DataTable.Rows.RemoveAt() ??? Very strange indeed!

Give them a chance! Do it for the kittens, dear God, the kittens!

Luis Alonso Ramos26-Sep-02 5:31

Luis Alonso Ramos

26-Sep-02 5:31

I added a if(dt.Tables[0].Rows.Count > 0) before clearing all rows, and it seems to work now...

-- LuisR

──────────────
  Luis Alonso Ramos
  Chihuahua, Mexico
  www.luisalonsoramos.com

"Do not worry about your difficulties in mathematics, I assure you that mine are greater." -- Albert Einstein

OpenFileDialog slowing me down?!

Zombies with Coffee, LLC25-Sep-02 6:41

Zombies with Coffee, LLC

25-Sep-02 6:41

I am calling a DLL function from my C# application, but when the application is executed, it takes approximately 5 seconds to complete it.

But if I throw a breakpoint before the call, and step thru it, the function runs in only 1 second?!?

I am letting it run 10 times with and without break points, and it stays consistent.

This is sooo backwards from what I was expecting. Any ideas on why breaking to debug mode speeds up the process!?

See the 3rd message down for a better description of what is happening

Re: Slow function calls when no breakpoint set?!

leppie25-Sep-02 7:03