C# Discussion Boards - CodeProject

23hrs 4mins ago

Hello Experts, I am working on an Excel application and I have input in the form of an HTML table string.I need to past this string in my excel work sheet. Please let me know how can I do this? Thanks, Raesa
Sign In·View Thread·Permalink

22hrs 35mins ago

Use the Excel interop namespace[^] to manipulate Excel worksheets. There are also various samples in http://www.codeproject.com/search.aspx?q=excel+c%23[^]. Use the best guess
Sign In·View Thread·Permalink

22hrs 28mins ago

Hello Richard,

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

22hrs 2mins ago

You need to look at the information in the exception to see why it's failing. Use the best guess
Sign In·View Thread·Permalink

21hrs 53mins ago

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

Eduardo Antonio Cecilio Fernandes

21hrs 39mins ago

Hello, As an alternative, you can take a look at IPOI[^]. Cheers, Eduardo
Sign In·View Thread·Permalink

21hrs 19mins ago

According to the documentation[^] `PasteSpecial` is a method of a `Range` object, not a `WorkSheet`. Use the best guess
Sign In·View Thread·Permalink

21hrs 10mins ago

Hi Richard, Thanks for the reply. Please check the link below. http://msdn.microsoft.com/en-us/library/office/aa195818(v=office.11).aspx[^] PasteSpecial is also a method of Worksheet. Thanks, Raesa
Sign In·View Thread·Permalink

20hrs 39mins ago

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
Sign In·View Thread·Permalink

replace a Text in winword within a range

20hrs 29mins ago

Hi Richard, Thank you for the link. I will have a look again at my implementation. Thanks, Raesa
Sign In·View Thread·Permalink

Saeed Rahimi

16 May '13 - 20:38

...
[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;
                    }
 
                }
 
                // Save the document and close document 
                doc.Save();
                // Quit the word application 
                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

Re: replace a Text in winword within a range [modified]

BillWoodruff

16 May '13 - 21:38

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();
 
// true
MessageBox.Show(string.IsNullOrEmpty(afterTest).ToString());
 
// true
MessageBox.Show(string.IsNullOrWhiteSpace(afterTest).ToString());
 
// true
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 20 hrs ago.

How to verify the signature signed by Java?

Jun Du

16 May '13 - 11:16

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
Sign In·View Thread·Permalink

Re: How to verify the signature signed by Java?

Abhinav S

16 May '13 - 16:50

Oops wrong forum. Recommend you delete this thread and post your question in the right forum. WP Apps - Color Search \| Arctic \| XKCD \| Sound Meter \| Speed Dial
Sign In·View Thread·Permalink

Atomicity in C#

gggustafson

16 May '13 - 9:14

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

dusty_dex

16 May '13 - 9:30

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);
  }

Matt T Heffron

16 May '13 - 9:44

Take a look at: A C# implementation of AI MEMO 239, Item 169- Count the one bits in a number[^]
Sign In·View Thread·Permalink

dusty_dex

16 May '13 - 10:15

Nice. Thanks.
Sign In·View Thread·Permalink

gggustafson

16 May '13 - 11:43

Is this an answer to my question? Gus Gustafson
Sign In·View Thread·Permalink

Matt T Heffron

16 May '13 - 10:34

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?
Sign In·View Thread·Permalink

gggustafson

16 May '13 - 11:45

I'll take either. Gus Gustafson
Sign In·View Thread·Permalink