|
I'm using a WebBrowser to open Excel documents in a C# app. It all works as planned until you have a session of Excel already open - then I can't move focus back to the existing Excel session. Any ideas?!
Thanks.
|
|
|
|
|
Win32 API to find out which window you want and then use the API to select the window?
Ed
|
|
|
|
|
Hi, I'm not quite sure what you are saying... I'm not trying to programatically set focus to Excel, when Excel is clicked on by the user, the hosted document in the webbrowser stays active and won't shift to the actual instance of Excel. Are you suggesting to intercept the WMessages? If so, how do you distinguish between those on the hosted document and those of a valid excel document? Thanks.
|
|
|
|
|
Sorry I'm still not 100% clear on what you're attempting.
Is it:
- When the user runs Excel and your program together, your program will not allow Excel to receive focus?
- You're launching Excel based on a link in the hosted document?
![Beer | [beer]](https://codeproject.freetls.fastly.net/script/Forums/Images/beer.gif) Ed
|
|
|
|
|
No problem, appreciate the help! The sequence that doesn't work is:
1. A user opens and starts using excel.
2. Later, they open my app which has a webbrowser that can load office docs.
3. When viewing an excel file loaded into the webbrowser, the user can't return to their original excel docs (openned natively in excel).
Cheers.
|
|
|
|
|
Is the excel sheet inside the browser or does the browser load the doc in Excel itself?
Ed
|
|
|
|
|
|
So if I understood you correctly you have an Excel instance open (standalone) with a.xls open.
You open your program and open say b.xls inside the browser and cannot while your program is open access or set the focus to the instance of excel which has a.xls open until you close your program?
I can't think of anything at the moment which would cause this, would it be possible to have a copy of the program or some sample code which exhibits the same problem? (I'm running Win2K & Office 2003 for your information)
Ed
|
|
|
|
|
If you:
1. Start a new c# windows app project.
2. drag a webbrowser onto the form.
3. drag a openfiledialog onto it.
4. at the end of the constructor, put:
openFileDialog1.Filter = "Excel Files (*.xls)|*.xls";
if (DialogResult.OK == openFileDialog1.ShowDialog())
{
axWebBrowser1.Navigate(openFileDialog1.FileName);
}
5. open excel and start a workbook.
6. run your app and open a workbook.
7. try to activate (5).
Cheers.
|
|
|
|
|
Interesting behaviour, I see if I can find some time to look into it, but I've got deadlines to meet with coursework and exams coming up soon so it's a bit hit or miss.
Sorry, but at least you're not the only one. Does this happen with word docs as well?
Ed
|
|
|
|
|
No. Word was ok - although when playing around with Word I found some equally dubious problems but can't remember what exactly they were... Thanks for taking the time out.
|
|
|
|
|
Typical MS
Ed
|
|
|
|
|
Has anyone had any luck solving this problem?
I'm currently experiencing a similar problem, only I am displaying 2 excel files in 2 child WebBrowser controls. After the second WebBrowser navigates to its respective excel file (with the first WebBrowser already displaying its excel file) and then setting the focus back to the first window the strange things happen when you try to manipulate cell data or worksheets. (When editing a cell, the text is not displayed in the cell but is displayed on the formula bar on the second WebBrowser. When switching worksheets via the tabs, the sheet disappears from the first WebBrowser and shows up in the second WebBrowser.) It's like the last WebBrowser that opens an Excel file monopolizes the focus of the Excel App instance.
As a test, I tried opening the files in 2 separate Internet Explorer windows to see if the behavior could be reproduced. It isn't. The two excel files can be worked with without any problems.
|
|
|
|
|
It might be something to do with the fact that the WebBrowser control's a wrapper around the OCX version but I know that I've got a PITA problem where the browser grabs focus even though it's hidden, disabled, told to handle nothing and it's wrapped around inside a Component that's on the form.
It'd be nice if someone wrote a fully managed browser...
As of how to accomplish that have you ever tried Google?
Failing that try ![Badger | [badger,badger,badger,badger...]](https://codeproject.freetls.fastly.net/script/Forums/Images/badger.gif) .
|
|
|
|
|
i need an example to create graph from C#
|
|
|
|
|
I want in my RichTextBox this action to do: Backspace key takes the same action like left arrow key. Speaking generally I don`t want to delete characters by backspace key inside the textBox field unless it is the last character.
This code works in TextBox (do the action which I want) but unfortunatelly doesn`t work in RichTextBox.
private void textBox1_KeyPress(object sender, System.Windows.Forms.KeyPressEventArgs e)<br />
{<br />
<br />
char c = e.KeyChar;<br />
int start = textBox1.SelectionStart;<br />
int lenght = textBox1.Text.Length;<br />
<br />
if(c == (short)Keys.Back && start!=lenght)<br />
{<br />
e.Handled = true;<br />
SendKeys.Send("{LEFT}");<br />
return;<br />
}<br />
}
Can anyone help me?
|
|
|
|
|
Describe "how it is not working".
Do you get a error or what?
And aI think making this kind of behaviour is bad. There are standards and I hope you have a really god reason for doing this...
Q:What does the derived class in C# tell to it's parent?
A:All your base are belong to us!
|
|
|
|
|
You asked me why it doesn`t work. It takes two action in the same time. First it deletes charakters (so backspace key works like should work), second it moves cursor to left like I want.
In textBox works only second action which exactly I want. In richTextBox work both of them.
e.Handled = true; code should make a backspace key action not allowed.
Why is that?
I need this action in my richTextBox to validate text which I enter to this.
|
|
|
|
|
hi
i need an example for creating a report in excel file from C# code
thanks
|
|
|
|
|
|
Hi
I need also to create a graph(in Excel) from the data i have in C# code
thanks
|
|
|
|
|
Where are you getting errors? Post
the code you tried.
|
|
|
|
|
Errors and Excel, I recently have resolved a major pain when using OLE DB. If you are using the Excel Object Model then ignore this. Basically I was glad to finally discover some info buried on MSDN that helped me resovle reading (importing) data from Excel via OLE DB.
Two things:
In your Connection String Extended Options there is a setting called IMEX. It can have one of the following values:
<br />
0 = Export<br />
1 = Import<br />
2 = Update<br />
Thus, let's say you want to read an Excel file that has a few questionable cells (i.e. IMEX=1). Well without some further intervenion in the Registry, OLE DB still may not fetch the records properly because it uses the first 8 cells in the column to guess the data type. Easy to fix but you have to know about this to make it work.
Nip into REGEDIT and goto to:
<br />
HKEY_LOCAL_MACHINE\SOFTWARE\Microsoft\Jet\4.0\Engines\Excel<br />
Then you have to tweak the value of a setting called no less than TypeGuessRows. You can choose a value that makes sense in your context, say it might take 100 cells to determine the type in your estimation. Then here it's definitely OK to try 100 as the value. This is an execise in tuning verus trial and error. If you have a humongous spreadsheet, you can use 0 which causes the Type Guess to scan up to 16,000 rows. That's a tad excessive for most apps, so like I said trial and error.
BUT Wait there's more.... when you finally go to deploy your application MAKE SURE your MSI updates the Registry!
Mike Luster
CTI/IVR/Telephony SME
|
|
|
|
|
How to use settimeout property in C#
can any one pls help me out
Neelam Ravi Kumar
|
|
|
|
|
try this link
http://www.dotnet247.com/247reference/a.aspx?u=http://www.kbalertz.com/Feedback_314190.aspx
Neelam Ravi Kumar
|
|
|
|
General 
News 
Suggestion 
Question 
Bug 
Answer 
Joke 
Praise 
Rant 
Admin 
Submit an article or tip
