|
Hi!
I'm looking for some help - i'm using the COM Excel Spreadsheet, Version 11 and actually i'm trying to set the borders of an cell. But it fails every time - i've looked around one day for a solution - nothing - i get something like that...
Property, indexer, or event 'LineStyle' is not supported by the language; try directly calling accessor methods 'Microsoft.Office.Interop.Owc11.Borders.get_LineStyle()' or 'Microsoft.Office.Interop.Owc11.Borders.set_LineStyle(Microsoft.Office.Interop.Owc11.XlLineStyle)
What does that mean - can someone provide some code for this...
i'm using Microsoft.Office.Interop.Owc11 - because the com object as well uses Interop and not excel...
Thanks...
Ralf 
FreewareFire
|
|
|
|
|
It means you shouldn't be calling get_LineStyle() directly ... there should be a property accessor available called LineStyle (or maybe just Style) available from the Office and/or Excel Namespace.
:..::. Douglas H. Troy ::..
Bad Astronomy |Development Blogging|Viksoe.dk's Site
|
|
|
|
|
Hi!
Thanks for answer. But still i can't get it work... I'm using the AxSpreadsheet... from the Office 2003. How can i set the bordes in that control?
Here's my Code:
<br />
Microsoft.Office.Interop.Owc11.Range NewRange = GridIt.get_Range("A1","A2");<br />
<br />
NewRange.Select();<br />
<br />
NewRange.Borders[Microsoft.Office.Interop.Owc11.XlBordersIndex.xlEdgeBottom].LineStyle = Microsoft.Office.Interop.Owc11.XlLineStyle.xlContinuous;<br />
Error occurs at .. .LineStyle = !!!
What should i do?
Greets
Ralf 
FreewareFire
-- modified at 18:53 Friday 3rd February, 2006
|
|
|
|
|
Use this...it works NewRange.Borders[Microsoft.Office.Interop.Owc11.XlBordersIndex.xlEdgeBottom].set_LineStyle(Microsoft.Office.Interop.Owc11.XlLineStyle.xlContinuous);
Good Luck
Vikas Pradhan
|
|
|
|
|
is there a way to make my program control mouse?
i want it to move mouse pointer and performe some clicks on the active window(any other program running)
|
|
|
|
|
Hey there,
I'm working on a webpage using ASP and C#. At the server, I am tracking all of the live Sessions based on the HttpContext.Current.Session.SessionID value. As you probably know this is a value unique to each web browser accessing my pages.
Now my problem. I would like to know when a user closes the browser and leaves the site (assuming he/she doesn't "log out"). I am hoping to periodically check each SessionID to see if it is still current or expired. Is there a way to load a specific session based on its ID and check to see if it has expired or not?
If it matters, I am using cookies to store the session information.
Thanks in advance,
Pualee
-- modified at 11:10 Friday 3rd February, 2006
P.S. -- Im reading a few books and looking all over the web, but having difficulty finding good information about Sessions (I'm new to Web Development). If you know a good online faq or tutorial, please share the love/url here 
|
|
|
|
|
Unless you use javascript in the browser to tell the server when the user leaves the page, there is no way that the server can know when this happens. If the user doesn't log out, the server session ends 20 minutes (at default setting) after the last request.
Any information you store in a cookie is only available when a request is made, as the cookie is stored in the browser.
---
b { font-weight: normal; }
|
|
|
|
|
Guffa wrote: Unless you use javascript in the browser to tell the server when the user leaves the page, there is no way that the server can know when this happens.
I'm not so much worried about the "event" of leaving, I just want to clean up some things periodically...
While still researching this topic, I have come across the following:
System.Web.SessionState.HttpSessionState class
.Count - Gets the number of items in the session-state collection
.Keys - Gets a collection of keys for all the values in the session-state collection
Shouldn't it be possible to loop on the .Keys to compare the active Keys against the keys my application believes are active? This might not be very scalable, but I'm not expecting thousands of users to connect per hour, this is a very specialized application.
I'm going to try this for now, but I'll be rechecking this board for feedback (never know when someone else has the same problem).
Also, would keeping the session data on server side, rather than as cookies, make this possible?
Pualee
|
|
|
|
|
You may want to consider setting a short (< 5 mins.) session timeout on your app and have every page periodically (using JavaScript) retrieve a very small resource (eg: a 1x1 pixel transparent .gif) in an iframe.
/ravi
My new year's resolution: 2048 x 1536
Home | Music | Articles | Freeware | Trips
ravib(at)ravib(dot)com
|
|
|
|
|
Pualee wrote: I just want to clean up some things periodically...
Then use the Session_End event in global.asax.
Pualee wrote: Shouldn't it be possible to loop on the .Keys to compare the active Keys against the keys my application believes are active?
You are confusing session objects with session variables. Each user has one session object that each can contain several variables. The Session.Keys property contains the keys of the variables that has been stored in the session object for the current user.
The server of course keeps track of the active sessions, but it doesn't expose this list to anyone. Probably because items can be removed from the list at any time.
Pualee wrote: Also, would keeping the session data on server side, rather than as cookies, make this possible?
That depends. What is it that you store in the cookies anyway?
---
b { font-weight: normal; }
|
|
|
|
|
How can I get programaticaly the hard disk's manufacter serial number (not the volume number). If not in c#, even in c would be very usefull.
Thanks
protected internal static readonly ... and I wish the list could continue ...
|
|
|
|
|
|
Thank you for your interest, but (there is allways a but...) those methods require XP+ as an operating sistem (beeing dependent on WMI). This is exacly what I've founded myself.
I am curently looking for an other method, whitch should be suported on a 95-98-me-2000 operating system too, or two methods one for XP+ and one for the rest ...
Anyway, the WMI querry didn't returned the corect string, other programs gave me an other result.
Any further ideeas?
PS: Thank you for your help again...
protected internal static readonly ... and I wish the list could continue ...
|
|
|
|
|
Aaah, the same problem I had, although in my case the client wanted it written in VB6. this[^] is what I based my solution on. Sorry, it really is VB6, but it's largely calling onto the Win32 API so perhaps it'll get you started.
|
|
|
|
|
Thanks, you pointed me on the right track...
protected internal static readonly ... and I wish the list could continue ...
|
|
|
|
|
Hy,
I need some tools (classes not exe) to export/trnasform some text(reports) in XLS, HTML, PDF, DBF, XML... format.
Tranks,
Mihai
|
|
|
|
|
Oh that's easy.
using RG = System.ReportGenerator;<br />
<br />
ReportGenerator _generator = new ReportGenerator(new StreamReader(@"c:\sourcefile.txt"));<br />
_generator.OutputType = ReportTypes.Text;<br />
_generator.OutputType = ReportTypes.Html;<br />
_generator.OutputFile = @"c:\outputreport.html";<br />
_generator.Generate();
- Malhar
|
|
|
|
|
Hello,
Thank for your reply. It's very easy what you say, but i don't have the class System.ReportGenerator in my Microsoft .NET Framework 1.1. What framework you use? Or ReportGenerator it's a other class, not from .NET framework. If you fave this class, please send me (mihai@sln.ro).
Tranks,
Mihai
|
|
|
|
|
I was not serious about that piece of code i wrote. There is no class built in .Net framework which allows you to perform such operations.
Each of the formats (Text, PDF, XML, Excel, HTML) are meant for different purposes. There is no one-fit-all solution which allows you to perform any-to-any conversion.
It is up to you to implement the logic for this. For example, you'd have to define how to take care of
a) images in the PDF file when converting to text .. or
b) how to convert a text file containig some article in XML .. or
c) What is it that you want to "convert" from HTML to Excel .. the tags / tables / text ..?
- Malhar
|
|
|
|
|
Can anyone help me?
I have a service written in C# which runs under the System Account, and seems to be working fine. But one of the things i need to do is get the current logged in user (i.e. the person who logged into the workstation), but can't seem to get it.
I’ve tried using the Environment.UserName Property but all this seems to return is the account of person who started the current thread. Does anyone have any ideas how to get the information while running with a service?
Cheers
Paul
|
|
|
|
|
DUKEMAN wrote: But one of the things i need to do is get the current logged in user (i.e. the person who logged into the workstation), but can't seem to get it.
Uhh, I don't think you can get that with 100% certainty. The whole point of services is to insulate your code from requiring a user to be logged in. What would it return when no-one was logged in?
Maybe you could fudge it by iterating over the running processes at some interval and look for User Name not equal to "SYSTEM" or "NETWORK SERVICE" or "LOCAL SERVICE". If someone was logged in, something would be running under their context.
You can get an array of running processes with this code:
System.Diagnostics.Process.GetProcesses()
You can get the contexts of the processes using WMI with code here[^] ( I haven't tried it).
Share and enjoy.
Sean
|
|
|
|
|
Hi Sean,
Having gone over other articles and notes I think you right the only way to get the current user would be to check the running process list and cross match this with the in build accounts and this should get you the current username/s.
Cheers for this
Paul
|
|
|
|
|
Answer me this ...
I have an application that is built in .net 2.0.
It references an assembly built in .net 1.1
What happens internally when my application uses the 1.1 assembly?
Does it create a new process for the 1.1 CLR? Is it seamless?
This is important to me because if there are cross process calls I presume that there will be some sort of performance impact, am I correct?
Thanks
Ryan
|
|
|
|
|
I am not aware if the .NET Runtime (the v2 one) does run the 1.1-code itself (in that case, there should be no performance hit) or if the two runtimes interop (in that case, there WILL be a performance hit) in some kind.
Interesting question, does anyone have some answers?
Cheers,
Sebastian
--
Contra vim mortem non est medicamen in hortem.
|
|
|
|
|
The 1.1 assembly will run in the 2.0 runtime; so there is no impact on performance.
|
|
|
|
General 
News 
Suggestion 
Question 
Bug 
Answer 
Joke 
Praise 
Rant 
Admin 
Submit an article or tip
