|
I have a VB 6 code with me. The code is playing with excel. It generates worksheets and adds templates to them, sets cell values, etc. I want to rewrite the entire code into C#.Net. For that I have used Microsoft Excel 11.0 COM reference. (This is same in VB6). The problem is that I cannot find code in C#.Net equivalent to VB6 counterpart. Examples are given below:
oBook.Worksheets("General")
or this
oSheet.Rows(2).Copy oSheet.Rows(i)
There are many examples like this.
Either I don't know how to write this in .Net or there is no equivalent.
Does anybody know, where I can learn how to use Excel in .Net 2003 in good amount of depth so that I can convert any code in VB6 to .Net 2003?
Regards
Anil
|
|
|
|
|
hi anil
look at this example
http://www.codeproject.com/office/package.asp
regards
|
|
|
|
|
Joe,
Thanks! That was a nice article. That solved my Worksheet("abc") problem.
Regards,
Anil
|
|
|
|
|
In any web application in C# how we can view/edit/delete some data in the FormView control without using any databaseobject control like sqldatasource,objectdatasource .We want to connect the FormView control with sql databse by writing code in codebehind(like using DataSet).
Waiting for reply......
priyabrata
|
|
|
|
|
hey
i am also looking for the same solution that u r stuck wid ....
i want to hard code form behind in my code behind without using databaseobjects ....
i 'vl inform if i find a solution ... kindly share if u find d way to do it ...
thanx
deepayan
|
|
|
|
|
Simple question.
Is there a command to copy a directory in a different path without doing this manually on files and sub-directory contained there?
I've not found any copy command on System::IO::Directory ... it's strange! 
Thank you
Russell
|
|
|
|
|
If you wanna move the directory, use Directory.Move
![Rose | [Rose]](https://www.codeproject.com/script/Forums/Images/rose.gif)
|
|
|
|
|
No, .... sorry...I want to copy it 
Russell
|
|
|
|
|
Do you want to copy subfolders too?
|
|
|
|
|
yes...like MS-DOS command xcopy does.
Of course, I can use directly that command, ... but I'm trying to understand if there is an implemented function that does this copy that I still not know.
Thank you
Russell
|
|
|
|
|
As fas as I know there is not such built-in function but if you search codeproject for xcopy you will find what you need.
|
|
|
|
|
To my knowledge, I feel you will need to iterate and copy each file. 
|
|
|
|
|
You have to write you own recursive procedure...
Regards,
Shy.
|
|
|
|
|
Hello,
I think you are looking fot this[^]
All the best,
Martin
|
|
|
|
|
Another idea for you is to do a simple hack - use the Process class and start a process using the xcopy command like you mentioned in some of your other posts.
I actually have done this in a build app I wrote.
I've also used the process class for doing FTP and LPR (using the built-in Windows commands, since there are no easy classes in the framework for this).
David
|
|
|
|
|
Hi
I have already wrote about my problem. I have a string that comes from console app
after it i convert it with this procedure
static private string EncodeMessageForConsoleOutput(string Message)
{
//gag
if (MemoLog == null)
return Message;
if (EncodingFrom.CodePage == EncodingTo.CodePage)
return Message;
Decoder decoder = Encoding.UTF8.GetDecoder();
byte[] bytes = Encoding.UTF8.GetBytes(Message);
char[] chars = new char[bytes.Length * 5];//*2
int bytesUsed, charsUsed;
bool completed;
decoder.Convert(bytes, 0, bytes.Length,
chars, 0, chars.Length, true,
out bytesUsed, out charsUsed, out completed);
string ResultString = new string(chars, 0, charsUsed);
return ResultString;
}
but it does not work
Could you help me
what's the problem with this code?
|
|
|
|
|
Hello all,
how to compare two times using DateTime object. I need to compare hours & minutes only based on this i am showing some message.
plz help me
regards
GV Ramana
|
|
|
|
|
For hours and minutes only, without dates and seconds:
DateTime first;
DateTime second;
if (first.Hour > second.Hour)
{
}
else
if (first.Hour == second.Hour)
if (first.Minute > second.Minute)
{
}
else
if (first.Minute == second.Minute)
{
}
else
{
}
else
{
}
|
|
|
|
|
Hello,
Look at System.TimeSpan class.
All the best,
Martin
|
|
|
|
|
TimeSpan is what you need.
Smile: A curve that can set a lot of things straight!
(\ /)
(O.o)
(><)
|
|
|
|
|
Yu can use the System.TimeSpan class. Quite handy, especially when used in conjunction with System.DateTime.
<br />
DateTime dt1 = DateTime.Parse("2007/06/14 13:24:00");<br />
DateTime dt2 = DateTime.Parse("2007/06/14 12:00:00");<br />
TimeSpan ts = dt1 - dt2;<br />
double elapsed = ts.TotalHours;<br />
This will give you the total number of hours elapsed from dt1 until dt2. If you are rather interested in the total number of minutes that elapsed you can use:
double elapse = ts.TotalMiutes;
or a host of others.
|
|
|
|
|
Hi,
if you want to ignore the other fields in a DateTime, you can not easily use the available
functions, nor TimeSpan.
I then suggest something like this:
public static int CompareHourMinuteOnly(DateTime dt1, DateTime dt2) {
int diff=dt1.Hour-dt2.Hour;
if (diff==0) diff=dt1.Minute-dt2.Minute;
return diff;
}
|
|
|
|
|
Ramana. G.V wrote: how to compare two times using DateTime object. I need to compare hours & minutes only based on this i am showing some message.
If DateTimeObject1.TimeOfDay = DatTimeObject2.TimeOfDay Then<br />
'do something<br />
End If
|
|
|
|
|
Hmm,
It's not an answere to the question, and it's not C# code!
|
|
|
|
|
Another way would be to force the 2 DateTime instances to have the same date (hardcode to something like 0001-01-01) and then do a DateTime.Compare(d1, d2);
-----
Formerly MP(2)
If atheism is a religion, then not collecting stamps is a hobby. -- Unknown
|
|
|
|
General 
News 
Suggestion 
Question 
Bug 
Answer 
Joke 
Praise 
Rant 
Admin 
Submit an article or tip
