C# Discussion Boards - CodeProject

17-May-13 0:35

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

Richard MacCutchan17-May-13 1:04

17-May-13 1:04

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

raesark17-May-13 1:11

17-May-13 1:11

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

Richard MacCutchan17-May-13 1:37

17-May-13 1:37

You need to look at the information in the exception to see why it's failing.

Use the best guess

raesark17-May-13 1:46

17-May-13 1:46

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

Eduardo Antonio Cecilio Fernandes17-May-13 2:00

17-May-13 2:00

Hello,

As an alternative, you can take a look at IPOI[^].

Cheers,

Eduardo

Richard MacCutchan17-May-13 2:20

17-May-13 2:20

According to the documentation[^] PasteSpecial is a method of a Range object, not a WorkSheet.

Use the best guess

raesark17-May-13 2:29

17-May-13 2:29

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

Richard MacCutchan17-May-13 3:00

17-May-13 3:00

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

raesark17-May-13 3:10

replace a Text in winword within a range

17-May-13 3:10

Hi Richard,

Thank you for the link.
I will have a look again at my implementation.

Thanks,
Raesa

Cyrus-IRA16-May-13 20:38

Cyrus-IRA

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

BillWoodruff16-May-13 21:38

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 17-May-13 8:52am.

How to verify the signature signed by Java?

Jun Du16-May-13 11:16

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

Re: How to verify the signature signed by Java?

Abhinav S16-May-13 16:50

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

Atomicity in C#

gggustafson16-May-13 9:14

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_dex16-May-13 9:30

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 Heffron16-May-13 9:44

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[^]

dusty_dex16-May-13 10:15

dusty_dex

16-May-13 10:15

Nice.

Thanks.

gggustafson16-May-13 11:43

16-May-13 11:43

Is this an answer to my question?

Gus Gustafson

Matt T Heffron16-May-13 10:34

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?

gggustafson16-May-13 11:45

16-May-13 11:45

I'll take either.

Gus Gustafson

Matt T Heffron16-May-13 12:05

Matt T Heffron

16-May-13 12:05

For a suggestion of a style to imply/suggest atomicity I'd probably use something like:

{
  // Atomic:
  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?

gggustafson17-May-13 5:32