|
Here is a code snippet from a class I'm using to export some data from an excel sheet. I think it answers your question.
private Excel.ApplicationClass m_objExcel = null;
private Excel.Workbooks m_objBooks = null;
private Excel._Workbook m_objBook = null;
private Excel._Worksheet m_objSheet = null;
private Excel.Range m_objRange = null;
private object oMissing = System.Reflection.Missing.Value;
try
{
FileInfo inf = new FileInfo(excelFileName);
m_objExcel = new Excel.ApplicationClass();
m_objExcel.Visible = false;
m_objBooks = m_objExcel.Workbooks;
m_objBook = m_objBooks.Open(inf.FullName, oMissing, oMissing,
oMissing, oMissing, oMissing, oMissing, oMissing, oMissing,
oMissing, oMissing, oMissing, oMissing, oMissing, oMissing);
m_objSheet = (Excel._Worksheet)m_objBook.Sheets[2];
string transformFileName = string.Format(@"{0}\{1}.cvt",inf.DirectoryName,inf.Name);
m_objSheet.SaveAs(transformFileName,Excel.XlFileFormat.xlTextWindows,oMissing,oMissing,oMissing,false,false,oMissing,oMissing,oMissing);
activeFile = new FileInfo(transformFileName);
}
catch(Exception ex)
{
throw ex;
}
finally
{
if( m_objBook != null)
{
m_objBook.Close(false, oMissing, oMissing);
System.Runtime.InteropServices.Marshal.ReleaseComObject (m_objBook);
m_objBook = null;
System.Runtime.InteropServices.Marshal.ReleaseComObject (m_objBooks);
m_objBooks = null;
m_objExcel.Quit();
System.Runtime.InteropServices.Marshal.ReleaseComObject (m_objExcel);
m_objExcel = null;
}
}
ed
Regulation is the substitution of error for chance.
|
|
|
|
|
Hi , ive asked this before , but does ANYONE know how to make a borderless window behave like a tooltip?
meaning , it should not steal focus from the app that shows it (grayout the apps caption)
i need to be able to place controls on the 'tooltip' but they dont need to be able to hold focus , just as long as i can click them and the click events work...
currently im doing some nasty wndproc hack , scanning for the wm_ncactivate message , and setting focus back to the parent window... but this causes the parents caption to redraw , so there is some minor flicker (but still annoying)
any idea?
//Roger
|
|
|
|
|
If you're using Windows 2000 or higher, you can override the CreateParams property, and add WS_EX_NOACTIVATE to the ExStyle property:
class TooltipForm : Form
{
...
protected const int WS_EX_NOACTIVATE = 0x08000000;
protected override CreateParams CreateParams
{
get
{
CreateParams cp = base.CreateParams;
cp.ExStyle |= WS_EX_NOACTIVATE;
return cp;
}
}
}
"These people looked deep within my soul and assigned me a number based on the order in which I joined." - Homer
|
|
|
|
|
hmmm.. it dont seem to work ...
using win2k and c# , setting the window to "Topmost=true"
it still steal focus..
//Roger
|
|
|
|
|
Excuse-me for my stupid question, In WebForm, I would like to create a button that allow to open html page.(link with parameter ex: qsdf.asp?Text=tete) in the same browser (and other browser). How can I do that?
-=zoltx=-
|
|
|
|
|
In your event handler for your Button you can Response.Write your javascript code to load a new window and change the location of your current browser. This gives you a dynamic effect.
js references
window.open, href.location
example:
public void OnClickButton1(object sender, EventArgs e){<br />
Response.Write("<javascript>window.open("www.codeproject.com");</javascript> );<br />
<br />
}
Note: code was written from memory, it is meant only for a guide
R.Bischoff | C++
.NET, Kommst du mit?
|
|
|
|
|
Sorry I tested and you code don't work, I modify your in this manner Response.Write("<javascript>window.open(\"www.codeproject.com\"); ")");
but it is not enough..
-=zoltx=-
|
|
|
|
|
how to do the same with C# as scripting language
|
|
|
|
|
I"m curious..
I'm changing settings in my machine.config so my web service runs properly. Problem is .. I can't tell which configuration change is making it work properly. It seems to me like the machine.config file is being cached.
Is it? if so is there a way to prevent it from being cached ?
thks
|
|
|
|
|
Hey there,
When using Form.Close and you try to show the form again, it shows without a Titlebar
How do you close a form knowing that you will want to load the form again at a later stage?
|
|
|
|
|
form.Hide() / form.Show()
or
after Close/Dispose, use new Form().
Who is this miscrosoft, and what devilish plans have they for us?
|
|
|
|
|
I´m creating an application that does some automation with excel. The problem is that Excel sometimes is busy doing some tasks and can´t respond to my method calls. To solve this I´m using something similar to this;
while(true)
{
try
{
oWorkbook.Range(...);
}
catch(System.RunTime.Interop.COMException)
{
System.Threading.Thread.Sleep(100)
}
catch(Exception exp)
{
throw(exp);
break;
}
}
The problem is that I have TONS of this oWorkbook.Range(...); lines... and I don´t want to write this bunch of code to all of them. Does anyone know some alternative way to do this (some kinda template maybe) ? I know I can write a wrapper to do this... but it´ll give me a lot of work... and I´m trying to find a better solution.
Mauricio Ritter - Brazil
Sonorking now: 100.13560 MRitter
Life is a mixture of painful separations from your loved ones and joyful reunions, without those two we'd just be animals I guess. The more painful the separation, that much more wonderful will be the reunion - Nish
"Th@ langwagje is screwed! It has if's but no end if's!! Stupid php cant even do butuns on forms! VISHAUL BASICS ARE THE FUTSHURE!" - Simon Walton
|
|
|
|
|
I've written a small app that retrieves the MAC-address from computors, using ManagementClass, ManagementObjectCollection and so on, eventually ManagementBaseObject.get_Item("MacAddress"); which turns out to work fine for most computors. Lately however I have discovered that for some computors a different series of numbers is retrieved. Looking into it a bit deeper I found that on all computors not one, but serveral items could be found calling get_item("MacAddress"). So my program did work for computors where the real MACaddress was the first to be returned (and apparently this included most computers).
Have I missed something? How can I tell which one is the real MAC address, and what are the other numbers?
Kind regards
/EnkelIk
Below a snippet of my code:
ManagementClass mc;
ManagementObjectCollection moc;
ManagementBaseObject mbo;
ManagementObjectCollection.ManagementObjectEnumerator moe;
string strMAC="",strTmp;
mc = new ManagementClass("Win32_NetworkAdapterConfiguration");
moc = mc.GetInstances(); // Get network adapter instance
moe=moc.GetEnumerator();
//Loop till MAC address found
while(moe.MoveNext())
{
mbo=moe.Current;
if(mbo["IPEnabled"]!=null)
{
Object pObj;
//Get MAC address
pObj=mbo["MacAddress"];
if(pObj!=null)
{
strTmp=pObj.ToString();
strMAC=string.Concat(strMAC,strTmp);
//Remove colon
strMAC=strMAC.Replace(":","");
break;
}
}
}
|
|
|
|
|
The answer is often simple when you know it... Debugging more carefully I found that mbo["IPEnabled"] is a System.Boolean -it is either true or false, but never null.
/EnkelIk
|
|
|
|
|
How to get Sysmenu in Winforms?
|
|
|
|
|
use pinvoke and call the getsysmenu api
/Roger
|
|
|
|
|
Hi,
I am developing usercontrol drag and drop.
DragSource: UserControl
DragDest: DataGrid
My Quesiton here is can I change Cursor (mouse icon) while draging? It gives Drag Effects for the Cursor like Move,Copy, None etc. I want to change the Cursor type say for example IBeam or Hand type Cursor instead of Move Effect. (Letting the Move effect remain same with having Cursor Image changed) is it possible ?
Could someone lead me to some direction or give me some link ?
kindda stuck
Thanx,
Paresh
|
|
|
|
|
anyone knows let me know ASAP...
|
|
|
|
|
I'm allowing the client user to upload his file onto my server. Now how do I find out the file's ORIGINAL last modified date and time?
If I use any of these File methods:
File.GetCreationTime()
File.GetLastAccessTime()
File.GetLastWriteTime()
I get the same date and time, namely, the time corresponding to the instant the file was uploaded. But that's not the file's original modified date. How do I get the original modified date of the (as seen by the client)?
|
|
|
|
|
It's probably part of the HTTP response header (Last-Modified).
Todd Smith
|
|
|
|
|
I have Panel control on Form. But, when I change context in it, I want to repaint it.
How to force Panel, to be repainted ?
10x
best regards, sebastijan
|
|
|
|
|
sv7874 wrote:
How to force Panel, to be repainted ?
You could call Invalidate() .
Nick Parker
The only man who never makes a mistake is the man who never does anything. - Theodore Roosevelt
|
|
|
|
|
Hi all,
I have a c# class derived from MenuItem that I am using for ownerdraw menu items. I set the OwnerDraw property to true, added the DrawItem & MeasureItem methods. I tested my class with a form, attaching the context menu to the form, and it worked great, the DrawItem & MeasureItem methods get called. However, if I try to use the context menu with a traybar application, the methods don't get called. Is this a known issue or what am I doing wrong or is there a workaround?
thanks
warbler
|
|
|
|
|
Salamo 3alekom
I tried to open a PE file with a program called PEExplorer .. Opend the header & discoverd that all the items in the header is correct..
but i found something strange i igot "the address of entry point" field from the header but when i checked that address i found it's so different from the contents that the PEExplorer program shows...
i found that the "image base" field is added some times 2 the address of the entry point field...
for example the address of entry point is: 0000E67Ch
& the image base is: 01000000h
but when i run the disassembler view of the PEExplorer i find that the address of the entry point is 0100E67Ch & this address can't be located coz the file size is smaller than it & the contents that the disassembler show in this location 0100E67Ch i can find it in another different place in my file
plz does any one knows how is this operation handled & how can i reach 2 the real entry point of an exe file...
my email is
blacksun_damn@yahoo.com,
ashshab_beh@yahoo.com
blacksun
|
|
|
|
|
you can launch a file using system.Diagnostic but how can i pass it command line args... i have not need of this right now...just curious about it
Feeding my ever growing hunger of C#...
Jesse M
|
|
|
|