Re: Read Excel - C# Discussion Boards

Christian Graus6-Jul-08 9:19

Christian Graus

6-Jul-08 9:19

There is a Microsoft Toolkit for Office, you can control Excel from C# with that.

Christian Graus

Please read this if you don't understand the answer I've given you. If you're still stuck, ask me for more information.

DaveyM696-Jul-08 9:26

DaveyM69

6-Jul-08 9:26

Gembox[^] do a cool .net dll. Very simple to use and you don't need Excel installed. The free version has some rows/sheets limits but is otherwise fully functional.

Dave

5do86-Jul-08 16:24

5do8

6-Jul-08 16:24

for excel 2003+,It is xml file in fact.and low versoin,i remeber CP had some article about it,you can search try.

Disable form when closing child form

Christian Graus6-Jul-08 16:40

Christian Graus

6-Jul-08 16:40

No, the XML format started in 2008.

Christian Graus

Please read this if you don't understand the answer I've given you. If you're still stuck, ask me for more information.

Deresen6-Jul-08 7:05

Deresen

6-Jul-08 7:05

Hello everyone,

I have an question about forms in C#.
This is a problem which I have had since the start of programming in C#.

This is the problem:
In the (main) Form there is a button to open another (child) Form.
But when I use that Form I would like to have the main Form to be enabled. This is no problem. But when I close the child Form I would like to disable the main Form.
But I want the main form to do this.

So not something like this:

//Form main:
public void createForm(){
Child child = new Child(this);
child.show();
this.Enabled = true;
}
public void show(){
this.Enabled = false;
}
//Form child
public Child(Main m){
this.main = m;
}
public void Dispose(){
main.show();
}

I would rather like to have something like this:

//Form main
public void createForm(){
Child child = new Child();
child.show();
this.Enabled = true;
}
public void child_Disposed(object sender, EventArgs e){
this.Enabled = false;
}

If I'm not wrong, I'll have to work with delegates. But I don't know how, can somebody help me?

Re: Disable form when closing child form

Harvey Saayman6-Jul-08 7:28

Harvey Saayman

6-Jul-08 7:28

you might be able to catch the childs onFormClosing event on the parent and the disable the parent in the handler...

read my article on Delegates And Events[^]

Harvey Saayman - South Africa
Junior Developer
.Net, C#, SQL
you.suck = (you.passion != Programming)

Re: Disable form when closing child form

N a v a n e e t h6-Jul-08 7:29

N a v a n e e t h

6-Jul-08 7:29

Your second code looks OK, only thing is you haven't hooked the Disposed event.

//Form main
public void createForm(){
   Child child = new Child();
   child.Disposed += this.child_Disposed;
   child.show();
   this.Enabled = true;
}

private void child_Disposed(object sender, EventArgs e){
   this.Enabled = false;
}

All C# applications should call Application.Quit(); in the beginning to avoid any .NET problems.- Unclyclopedia

How to use google | Ask smart questions

problem with converting to Double

Rick van Woudenberg6-Jul-08 7:01

Rick van Woudenberg

6-Jul-08 7:01

Dear all,

I have a little problem converting a string that contains a ',' into a double.
Double needs a value devided by a dot ( or so I've read )

So , in my code , the following occurs :

string lat = p[u].X.ToString().Replace(',', '.');
MessageBox.Show(lat);

The output will be for example : 55.38978 ( which shows up perfect in the messagebox )

However, if i do the following :

MessageBox.Show(Convert.ToDouble(lat).ToString());

The output will be : 5538978
That doesn't make a whole lot of sense to me. So that dot is somehow bothering Double or am I not converting properly ?

Cheers Smile | :)

Re: problem with converting to Double

Deresen6-Jul-08 7:13

Deresen

6-Jul-08 7:13

Well the problem is that double works with a komma in stead of a dot.

See it like this:

string ss = "55,5493";
string lat = ss.ToString().Replace(',', '.');
double d = Convert.ToDouble(ss);
double dd = Convert.ToDouble(lat);
MessageBox.Show("" + d); //output: 55,5493
MessageBox.Show("" + dd); //oubput: 555493

So you should change this one:

string lat = ss.ToString().Replace(',', '.');

into this one:

string lat = ss.ToString().Replace('.', ',');

Good luck

Re: problem with converting to Double

Luc Pattyn6-Jul-08 7:23

Luc Pattyn

6-Jul-08 7:23

Hi Rick,

ToString() when applied to numbers will by default use the regional settings of your system,
which define a "decimal point" (not necessarily a period) and a "thousands separator" (not
necessarily a comma).

Parse() and TryParse() will observe the "decimal point" and ignore the "thousands separator".

If you have a number formatted one way (say West-European way, with decimal comma, and thousands
period) and parsed another way (say US way), you will get wrong results, and even an Exception
when more than one thousands separator is present.

The solution is NOT to replace periods by comma and vice versa, the solution is to apply
the appropriate settings, by using a FormatProvider or CultureInfo.

The above applies not only to doubles, but also to floats and decimals.

Smile | :)

Luc Pattyn [Forum Guidelines] [My Articles]

Voting for dummies? No thanks. Dead | X|

How Do I Save the Contents of a WebPage without using A WebBrowser?

That Asian Guy6-Jul-08 6:40

That Asian Guy

6-Jul-08 6:40

How do I write the contents of a webpage without a webbrowser? I am aware of

webBrowser.Navigate("http://www.google.com");
using (StreamWriter sw = File.CreateText(path))
{
sw.Write(webBrowser.DocumentText);
}

However, I was trying to use another way to do it without using a webBrowser.

Thanks in advance.

Re: How Do I Save the Contents of a WebPage without using A WebBrowser?

Luc Pattyn6-Jul-08 7:24

Luc Pattyn

6-Jul-08 7:24

Hi,

have a look at WebRequest and HttpWebRequest classes and the GetResponse method.

Smile | :)

Luc Pattyn [Forum Guidelines] [My Articles]

Voting for dummies? No thanks. Dead | X|

Check for the status of Windows Form

ASysSolvers6-Jul-08 4:21

ASysSolvers

6-Jul-08 4:21

In my application, when I showing a new form I do,
Form2 frm2=new Form2();
This.hide();
frm2.TopMost = true;
frm2.Show();

I do like that..again when I come to first form. I do the same being in second form.(imagine I am in Form2 now.)

this.Close();
frm1.Show(); // this is my first form.

Problem is some times I cant see my first form.it is still hiden. So it is happens sometimes.
Are there any way to know (some status) to know my form is already hiden or shown.
What is the best practice of this kind of situation?

Re: Check for the status of Windows Form

Luc Pattyn6-Jul-08 4:43

Luc Pattyn

6-Jul-08 4:43

Hi,

Show/Hide methods and Visible property always correspond.

Smile | :)

Luc Pattyn [Forum Guidelines] [My Articles]

Voting for dummies? No thanks. Dead | X|

Is Interface implementation Correct

Navneet Hegde6-Jul-08 3:37

Navneet Hegde

6-Jul-08 3:37

Dear All,
To know the IEnumerable Interface I have done one demo Aplication please let me know whether there is anything wrong in my approach.

class MyFile : FileSystemInfo
 {
     private FileInfo _strFile;
     public MyFile(FileInfo strFile)
     {
         _strFile = strFile;
     }

     public override void Delete()
     {
         _strFile.Delete();
     }

     public override bool Exists
     {
         get
         {
             if (_strFile.Exists)
             {
                 return true;
             }
             else
             {
                 return false;
             }

         }
     }

     public override string Name
     {
         get { return _strFile.Name;}
     }
 }

class MyFiles : IEnumerable<MyFile>
 {
     private string _directoryPath;
     private string _fileExtension = "xml";

     public MyFiles(string directoryPath)
     {
         _directoryPath = directoryPath;
     }

     public string FileExtension
     {
         get { return _fileExtension; }
         set { _fileExtension = value; }
     }

     #region IEnumerable<MyFile> Members

     public IEnumerator<MyFile> GetEnumerator()
     {
         DirectoryInfo di = new DirectoryInfo(_directoryPath);
         FileInfo[] rgFiles = di.GetFiles("*." + _fileExtension);
         foreach (FileInfo fi in rgFiles)
         {
             MyFile ss = new MyFile(fi);
             yield return ss;
         }
     }

     #endregion

     #region IEnumerable Members

     IEnumerator IEnumerable.GetEnumerator()
     {
         DirectoryInfo di = new DirectoryInfo(_directoryPath);
         FileInfo[] rgFiles = di.GetFiles("*." + _fileExtension);
         foreach (FileInfo fi in rgFiles)
         {
             MyFile ss = new MyFile(fi);
             yield return ss;
         }
     }

     #endregion

 }

Here is it's implementation :

static void Main()
   {
       MyFiles myFS = new MyFiles(@"D:\TestInterface");
       foreach(MyFile FS in MyFiles)
       {
           Console.WriteLine(FS.Name);
           Console.ReadLine();
       }

   }

Here I am trying to Iterate the Files in Certain directory, and it's further implementation would be to Add New Methods to MyFile Class so as to get Certain required Data from the Files.So far it looks good .
I only wanted to know whether my Interface Implementation is Wrong anywhere or require any changes.

Thanks in Advance.

Develop2Program & Program2Develop

Re: Is Interface implementation Correct

leppie6-Jul-08 3:52

can i drive a class from a delegate

6-Jul-08 3:52

Navneet Hegde wrote:
IEnumerator IEnumerable.GetEnumerator()

You dont really need to provide an implementation for that too. Simply return the generic IEnumerable, ie: return GetEnumerator();

Everything else looks fine Smile | :)

xacc.ide - now with TabsToSpaces support
IronScheme - 1.0 alpha 4a out now (29 May 2008)

Pankaj Garg6-Jul-08 3:29

Pankaj Garg

6-Jul-08 3:29

Please provide an example.
Thank You

If you have an apple & I have an apple and we exchange our apples, then each of us will still have only one apple but if you have an idea & I have an idea and we exchange our ideas, then each of us will have two ideas!

leppie6-Jul-08 3:53

6-Jul-08 3:53

delegate types are sealed, so no.

xacc.ide - now with TabsToSpaces support
IronScheme - 1.0 alpha 4a out now (29 May 2008)

leppie6-Jul-08 3:55

6-Jul-08 3:55

You can 'modify' a delegate though. As an example, see how I make Action delegates parallel in my latest article[^].

xacc.ide - now with TabsToSpaces support
IronScheme - 1.0 alpha 4a out now (29 May 2008)

Pete O'Hanlon6-Jul-08 8:55

Pete O'Hanlon

6-Jul-08 8:55

I still like that article. I still cannot think of a single instance where I'd use it, but who cares because it's cool.

Deja View - the feeling that you've seen this post before.

My blog | My articles

leppie6-Jul-08 9:17