|
|
Thanks for the reply.
I had actually gone through the articles before, but could not find help.
I actually tried using the below code for pastiny HTML table string to excel datasheet, but it throws a pastespecial error and i'm not sure how to solve it.
-------
Excel.Application objExcelApp;
Excel.Workbook objWorkBook;
Excel.Worksheet xlWorkSheet;
object misValue = System.Reflection.Missing.Value;
objExcelApp = new Excel.Application();
objWorkBook = objExcelApp.Workbooks.Add(misValue);
xlWorkSheet = (Excel.Worksheet)objWorkBook.Worksheets.get_Item(1);
PulleyResponse respUser = PulleyOutputList.ElementAt(0).Key;
Clipboard.SetData(DataFormats.Html, respUser.htmlStressTable);
objWorkBook.ActiveSheet.Range("A1").PasteSpecial(Excel.XlPasteType.xlPasteAll,Excel.XlPasteSpecialOperation.xlPasteSpecialOperationAdd,false, false);
objWorkBook.ActiveSheet.Range("A1").Value = objWorkBook.ActiveSheet.PasteSpecial(Clipboard.GetText());
string sDesktop = Environment.GetFolderPath(Environment.SpecialFolder.Desktop);
if (objWorkBook != null)
objWorkBook.SaveAs("c:\\Test.xls", misValue, misValue, misValue, misValue, misValue, Excel.XlSaveAsAccessMode.xlNoChange, misValue, misValue, misValue, misValue, misValue);
objExcelApp.Quit();
ReleaseObject(objWorkBook);
ReleaseObject(objExcelApp);
------
I would glad if I could get some advice on this if I am doing something wrong.
Thanks,
Raesa
|
|
|
|
|
You need to look at the information in the exception to see why it's failing.
Use the best guess
|
|
|
|
|
Hello Richard,
I am getting a COMException - "
Unable to get the PasteSpecial property of the Range class " at this line
objWorkBook.ActiveSheet.Range("A1").Value = objWorkBook.ActiveSheet.PasteSpecial(Clipboard.GetText());
I am not sure what I must do.
Thanks
Raesa
|
|
|
|
|
Hello,
As an alternative, you can take a look at IPOI[^].
Cheers,
Eduardo
|
|
|
|
|
According to the documentation[^] PasteSpecial is a method of a Range object, not a WorkSheet.
Use the best guess
|
|
|
|
|
|
That link is for VBA, the link you need to use is this one[^]. Also, if you read the documentation it states "This method supports the .NET Framework infrastructure and is not intended to be used directly from your code.". You need to use the Range object, as I mentioned previously.
Use the best guess
|
|
|
|
|
Hi Richard,
Thank you for the link.
I will have a look again at my implementation.
Thanks,
Raesa
|
|
|
|
|
...
[START]
blaaa blaa blaa
T h i s
(this is an empty line)
{END]
...
another line
--------------------------------------
I have been trying to remove empty lines appearing between
[START] and {END] within a word document.
Code seems to work if I did not have a textbox at top of my document. It seems that the textbox is also cleared once such operation takes place.
wordapp = new Word.Application();
wordapp.Visible = false;
doc = wordapp.Documents.Open(wordPath);
paragraphs = doc.Paragraphs;
bool flag = false;
foreach (Word.Paragraph paragraph in paragraphs)
{
string s = paragraph.Range.Text;
string y = paragraph.Range.Text.Trim();
if (paragraph.Range.Text == "<NE>\r")
{
flag = true;
paragraph.Range.Select();
wordapp.Selection.Delete();
continue;
}
else if (paragraph.Range.Text == "</NE>\r")
{
flag = false;
paragraph.Range.Select();
wordapp.Selection.Delete();
continue;
}
else if (paragraph.Range.Text.Trim() == string.Empty )
{
if (flag)
{
paragraph.Range.Select();
wordapp.Selection.Delete();
}
continue;
}
}
doc.Save();
wordapp.Quit();
is there any other way to achieve what I do using Range in Word or dealing with a textbox in Word?
Student of life
|
|
|
|
|
Hi Saeed,
Could you clarify exactly what you mean by "textbox at top of my document" ?
I note the variable 'y you define in your code is never used.
It appears to me your code deletes the tags "<NE>" and "</NE>," as well as white-space between them: is that correct ?
yours, Bill
string test = "\r";
string afterTest = test.Trim();
MessageBox.Show(string.IsNullOrEmpty(afterTest).ToString());
MessageBox.Show(string.IsNullOrWhiteSpace(afterTest).ToString());
MessageBox.Show((afterTest == string.Empty).ToString());
“Humans are amphibians: half spirit, half animal; as spirits they belong to the eternal world; as animals they inhabit time. While their spirit can be directed to an eternal object, their bodies, passions, and imagination are in continual change, for to be in time, means to change. Their nearest approach to constancy is undulation: repeated return to a level from which they repeatedly fall back, a series of troughs and peaks.” C.S. Lewis
modified 17-May-13 8:52am.
|
|
|
|
|
Hi,
I have a Java program that signed a token using the private key and SHA1 algorithm. Now I try to verify it using the public key and SHA1. The verification fails. Is there any compatibility issue here or I am missing something? Thanks.
Best,
Jun
|
|
|
|
|
Oops wrong forum. Recommend you delete this thread and post your question in the right forum.
|
|
|
|
|
I am programming a bit counter, a method that returns a List < int > of the positions of the bits that are "on" in a UInt32. I was reviewing the code when I encountered
position--;
bit >>= 1;
To my mind these two statements need to be atomic. To achieve at least the notion of atomicity in C#, I would change the code to
position--; bit >>= 1;
I am fiercely against this in a statement body. But in this case I think it signals atomicity. Is there a better way to do this?
Gus Gustafson
|
|
|
|
|
This is coolest bitcount I've seen.
{
c = (c >> 1 & 0x55555555) + (c & 0x55555555);
c = (c >> 2 & 0x33333333) + (c & 0x33333333);
c = (c >> 4 & 0x0f0f0f0f) + (c & 0x0f0f0f0f);
c = (c >> 8 & 0x00ff00ff) + (c & 0x00ff00ff);
return (c >> 16) + (c & 0x0000ffff);
}
|
|
|
|
|
|
Nice.  Thanks.
|
|
|
|
|
Is this an answer to my question?
Gus Gustafson
|
|
|
|
|
I'm wondering what you're actually trying to achieve.
Do you just want some style that implies atomicity?
Do you want a way to ensure atomicity?
|
|
|
|
|
I'll take either.
Gus Gustafson
|
|
|
|
|
For a suggestion of a style to imply/suggest atomicity I'd probably use something like:
{
position--;
bit >>= 1;
}
Code reformatters may remove the redundant curly-braces.
I don't know of any way to ensure the two actions are performed atomically.
But, these operations should not be using values that aren't thread-safe anyway.
At least in a bit counting method.
Why the concern for atomicity?
|
|
|
|
|
Thread safty has nothing to do with it. The expressions are in a private static method.
Thanks for the thought.
Gus Gustafson
|
|
|
|
|
OK, but that's what atomicity is. A thread can safely read a value without having to worry about another thread writing to that value at the same time.
Each o of yout two statements is atomic, but together, they are not. The values can change between the execution of those two statements.
The only way to treat those two statements as a single atomic operation is to wrap it in a lock. You'll also have to modify any code that changes these values to also try and take out a lock before changing the value(s).
very  as to what you're doing and why...
|
|
|
|
|
Dave, being thread safe is not the same as atomicity. The former deals with threads within a process. The latter deals with processes across the machine. It requires the compiler writer to mask interrupts during the time that "atomic" instruction will be executed.
Thanks for your thoughts.
Gus Gustafson
|
|
|
|
|
I forgot about the system-wide process part, as I never had to deal with it.
But, in any case, the concept of atomicity, the way you describe it, doesn't exist in .NET.
|
|
|
|
General 
News 
Suggestion 
Question 
Bug 
Answer 
Joke 
Praise 
Rant 
Admin 
Submit an article or tip
