Update Cell Value into Excel Cell like 2009.03 and it become 2009.3 - C# Discussion Boards

Re: How to send commands to a running application from the command line?

3-Mar-10 0:30

Ted On The Net wrote:
(like: broadcast / broadcast error file not found: aFile.exe). The broadcaster and receiver tools are all built in Delphi. I want to rebuild it using C# as my first project

Two applications to migrate, starting with the broadcaster. As soon as you create a new console-application you'll see where to get the command-line arguments from. Are all options specified as arguments, or will you be reading user-input directly from the console?

Coming from Delphi, I guessed that it's now based on the Indy-components? You might be interested in the example on the UdpClient[^] class.

I are Troll Suspicious | :suss:

OriginalGriff2-Mar-10 23:42

OriginalGriff

2-Mar-10 23:42

There is no simple way to do this. You would have to write a command line application that communicated to the running application, either via Remoting or via a common text file or database. I would recommend Remoting[^] as it will be more flexible and less processor / disk intensive.

You should never use standby on an elephant. It always crashes when you lift the ears. - Mark Wallace

C/C++ (I dont see a huge difference between them, and the 'benefits' of C++ are questionable, who needs inheritance when you have copy and paste) - fat_boy

Re: How to send commands to a running application from the command line?

Ted On The Net2-Mar-10 23:44

Ted On The Net

2-Mar-10 23:44

the command sent from commandline is part of a batchfile running. perhaps I should split the tool like i said in the reply to Eddy on the other thread.

- Life would be so much easier if I had the source code!
- If C# had true garbage collection, most applications would delete themselves upon execution Wink | ;)

Re: How to send commands to a running application from the command line?

PIEBALDconsult3-Mar-10 3:51

PIEBALDconsult

3-Mar-10 3:51

The program would have to have that capability built in. One simple way would be having the application check a database for actions to take. Then you just deposit your instructions there.

Another way is to use a Windows Service and send custom actions to it.

create word file

Milind Panchal2-Mar-10 22:33

Milind Panchal

2-Mar-10 22:33

I have developed window application in C#.net. I am creating word file from this. But if I am going to save changes in word file I got the below error.

a.doc may contain features that are not compatible with plain text format. Do you want to save tha document in this format ?

How to save file in word format

Thanks in advance

Re: create word file

Eddy Vluggen2-Mar-10 23:41

Update Cell Value into Excel Cell like 2009.03 and it become 2009.3

2-Mar-10 23:41

A Word-document contains special tokens to identify tables, lines, pictures and stuff. A plain text-file doesn't contain these things, as a plain text-file can only contain text.

You can use the Visual Studio for Office[^]-extensions if you're going to work with Word.

As an alternative; Microsoft Word can also read the "Rich Text File" format (RTF) and HTML files Smile | :)

I are Troll Suspicious | :suss:

pankaj.calm2-Mar-10 22:17

pankaj.calm

2-Mar-10 22:17

Hi,

I am updating a Excel Worksheet cell value to 2009.03 and it become change to 2009.3.

I tried may ways to solve the issue but value always changed to "2009.3" instead of "2009.03" on Server. It is working on my system but not on Win XP 2003 Server System.

I used to set excel cell NumberFormat to "@", "0.00", "####.##"
and even tried to concatenated "'" before value but result not come.
The excel file is of 2007 format(.xlsx).
<u>>My Code is</u>
Microsoft.Office.Interop.Excel.Workbook WorkBook = null;
Microsoft.Office.Interop.Excel.Worksheet Sheet = null;
WorkBook = Utility.GetWorkbook2007(templateFileWPath);
Sheet = (Microsoft.Office.Interop.Excel.Worksheet)WorkBook.Worksheets[1];
Microsoft.Office.Interop.Excel.Range TPCellRange = (Microsoft.Office.Interop.Excel.Range)Sheet.Cells[this.GetRowIndex(Sheet, this.CellAddress), this.GetColumnIndex(Sheet, this.CellAddress)];
TPCellRange.set_Value(Microsoft.Office.Interop.Excel.XlRangeValueDataType.xlRangeValueDefault,"2009.03");

or also tried
CellValueRange.NumberFormat = "@";
CellValueRange.set_Value(Microsoft.Office.Interop.Excel.XlRangeValueDataType.xlRangeValueDefault, "2009.03");

plz reply me if any solution is possible

Thanks @ regards

Re: Update Cell Value into Excel Cell like 2009.03 and it become 2009.3

Eddy Vluggen3-Mar-10 0:55

Re: Update Cell Value into Excel Cell like 2009.03 and it become 2009.3

3-Mar-10 0:55

Could it be that the "." (the decimalseparator) is interpreted as a thousand-separator?

I are Troll Suspicious | :suss:

pankaj.calm3-Mar-10 0:59

pankaj.calm

3-Mar-10 0:59

"." is not a thousandseperator
its like a date value seperator or date is in yyyy.mm format
but i need actual value like "2009.03" where 2009 is year and 03 is month.

Re: Update Cell Value into Excel Cell like 2009.03 and it become 2009.3

Eddy Vluggen3-Mar-10 1:39

Re: Update Cell Value into Excel Cell like 2009.03 and it become 2009.3

3-Mar-10 1:39

Have you tried setting the numberformat to "yyyy.mm"?

I are Troll Suspicious | :suss:

pankaj.calm3-Mar-10 2:02

pankaj.calm

3-Mar-10 2:02

yes i tried

Re: Update Cell Value into Excel Cell like 2009.03 and it become 2009.3

Eddy Vluggen3-Mar-10 3:03

3-Mar-10 3:03

I've created a test-sheet in Excel (2007) and succesfully changed the NumberFormat using an adapted version of your code;

using XL = Microsoft.Office.Interop.Excel;

[...].
object oMissing = System.Reflection.Missing.Value;
XL.Application App = new XL.ApplicationClass();			
XL.Workbook WorkBook = App.Workbooks.Open("C:\\Book1.xlsx", 
	oMissing, oMissing, oMissing, oMissing, oMissing, oMissing,
	oMissing, oMissing, oMissing, oMissing, oMissing, oMissing, 
	oMissing, oMissing);
XL.Worksheet Sheet = (XL.Worksheet)WorkBook.Worksheets[1];
XL.Range thisRange = (XL.Range)(Sheet.Cells[1, 1]);
thisRange.NumberFormat = "yyyy.mm";
WorkBook.Save();
WorkBook.Close(false, oMissing, oMissing);

Some points to keep in mind;

You'll need the correct Office Interop assemblies
The value that you're formatting needs to be a "real" date. (Not a string that contains month & year)

Hope this helps Smile | :)

I are Troll Suspicious | :suss:

Remote administration

kebedetesema2-Mar-10 22:10

2-Mar-10 22:10

Hi, all,
My application involves installation of different parts of the project in different computers on a local network. I want the administrator to check and/or start/stop different services on different PC's remotely using command line. I use C#. I don't know what technology to use. Should I use telnet/ssh or is use of WMI(System.Management Name Space) enough?.Or is there another method?. I don't want to use remote desktop or window's built-in telnet client. Nor do I want to use remote admin software like pcAnywhere. If it is possible to use both telnet/ssh and WMI, which one is better?.

Eddy Vluggen2-Mar-10 23:51

2-Mar-10 23:51

You can use the SC[^] command to control services, somewhat similar to this;

sc \\MyComputerName stop "NameOfTheService"

I are Troll Suspicious | :suss:

kebedetesema3-Mar-10 1:56

3-Mar-10 1:56

yes you are right Eddy Vluggen. But i want to start/stop exe's, not registered services alone. also, I want to make the commands simple, for example, by giving list of numbers to choose and choosing the number runs something or brings another list of choices.

Eddy Vluggen3-Mar-10 2:09

3-Mar-10 2:09

kebedetesema wrote:
i want to start/stop exe's

You can use the GetProcesses[^] method to generate a Proces class for all executables on the remote machine Smile | :)

I are Troll Suspicious | :suss:

kebedetesema3-Mar-10 3:38

3-Mar-10 3:38

Yes you are right but I also want to start/stop exe's, not installed services alone. also I want to make the commands simple, for example, by giving a list of choice(number) and selecting a number runs a service or exe file etc

Eddy Vluggen3-Mar-10 5:09

3-Mar-10 5:09

kebedetesema wrote:
but I also want to start/stop exe's, not installed services alone.

Starting and stopping executables is done over the Process class, if you have the required permissions. Services can't be killed that way, hence the suggestion to use the SC.exe command.

That would enable you to start/stop executables and to start/stop services. If that's not what you want then I have misinterpreted the question.

kebedetesema wrote:
also I want to make the commands simple, for example, by giving a list of choice(number) and selecting a number runs a service or exe file etc

I'm imagining a console-application that shows a menu, am I close?

I are Troll Suspicious | :suss:

kebedetesema3-Mar-10 19:34

3-Mar-10 19:34

Yes Exactly. I want console-application that shows a menu,but then do you mean I can use The Process class in the console application and that is enough?

Eddy Vluggen4-Mar-10 4:09

4-Mar-10 4:09

kebedetesema wrote:
do you mean I can use The Process class in the console application and that is enough?

Yup, should be enough to start or stop processes on another computer Smile | :)

I are Troll Suspicious | :suss:

Regrding Control

Anil Kumar.Arvapalli2-Mar-10 22:07

Anil Kumar.Arvapalli

2-Mar-10 22:07

Guys,

Iam very nave to this community. If some body is using Vista or W-7, we get search option on Top right of the exlplorer. The moment we type some sam, it searches and the list will be displayed, from where we can we double click the appopriate window will be displayed.

I want to know that what is the control that he is using and how he is displaying the window upon double click.

Can any body help me out.. I want to develop a Search Engine tool same like W-7 or Vista.

Thanks in Advance.... Smile | :)

Re: Regrding Control

Eddy Vluggen3-Mar-10 0:02