Click here to Skip to main content
15,887,477 members
Home / Discussions / C#
   

C#

 
GeneralRe: A question on WCF Pin
Dewald17-May-13 2:35
Dewald17-May-13 2:35 
QuestionHow to Conect two computers in different networks Pin
AntonioJesus17-May-13 0:35
professionalAntonioJesus17-May-13 0:35 
AnswerRe: How to Conect two computers in different networks Pin
Pete O'Hanlon17-May-13 0:37
mvePete O'Hanlon17-May-13 0:37 
GeneralRe: How to Conect two computers in different networks PinPopular
AntonioJesus17-May-13 0:46
professionalAntonioJesus17-May-13 0:46 
GeneralRe: How to Conect two computers in different networks Pin
Keith Barrow17-May-13 3:03
professionalKeith Barrow17-May-13 3:03 
QuestionC# Excel- Paste HTML table in excel sheet Pin
raesark17-May-13 0:35
raesark17-May-13 0:35 
AnswerRe: C# Excel- Paste HTML table in excel sheet Pin
Richard MacCutchan17-May-13 1:04
mveRichard MacCutchan17-May-13 1:04 
GeneralRe: C# Excel- Paste HTML table in excel sheet Pin
raesark17-May-13 1:11
raesark17-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
GeneralRe: C# Excel- Paste HTML table in excel sheet Pin
Richard MacCutchan17-May-13 1:37
mveRichard MacCutchan17-May-13 1:37 
GeneralRe: C# Excel- Paste HTML table in excel sheet Pin
raesark17-May-13 1:46
raesark17-May-13 1:46 
GeneralRe: C# Excel- Paste HTML table in excel sheet Pin
Eduardo Antonio Cecilio Fernandes17-May-13 2:00
Eduardo Antonio Cecilio Fernandes17-May-13 2:00 
GeneralRe: C# Excel- Paste HTML table in excel sheet Pin
Richard MacCutchan17-May-13 2:20
mveRichard MacCutchan17-May-13 2:20 
GeneralRe: C# Excel- Paste HTML table in excel sheet Pin
raesark17-May-13 2:29
raesark17-May-13 2:29 
GeneralRe: C# Excel- Paste HTML table in excel sheet Pin
Richard MacCutchan17-May-13 3:00
mveRichard MacCutchan17-May-13 3:00 
GeneralRe: C# Excel- Paste HTML table in excel sheet Pin
raesark17-May-13 3:10
raesark17-May-13 3:10 
Questionreplace a Text in winword within a range Pin
Cyrus-IRA16-May-13 20:38
Cyrus-IRA16-May-13 20:38 
AnswerRe: replace a Text in winword within a range Pin
BillWoodruff16-May-13 21:38
professionalBillWoodruff16-May-13 21:38 
QuestionHow to verify the signature signed by Java? Pin
Jun Du16-May-13 11:16
Jun Du16-May-13 11:16 
AnswerRe: How to verify the signature signed by Java? Pin
Abhinav S16-May-13 16:50
Abhinav S16-May-13 16:50 
QuestionAtomicity in C# Pin
gggustafson16-May-13 9:14
mvagggustafson16-May-13 9:14 
AnswerRe: Atomicity in C# Pin
dusty_dex16-May-13 9:30
dusty_dex16-May-13 9:30 
SuggestionRe: Atomicity in C# Pin
Matt T Heffron16-May-13 9:44
professionalMatt T Heffron16-May-13 9:44 
GeneralRe: Atomicity in C# Pin
dusty_dex16-May-13 10:15
dusty_dex16-May-13 10:15 
GeneralRe: Atomicity in C# Pin
gggustafson16-May-13 11:43
mvagggustafson16-May-13 11:43 
QuestionRe: Atomicity in C# Pin
Matt T Heffron16-May-13 10:34
professionalMatt T Heffron16-May-13 10:34 

General General    News News    Suggestion Suggestion    Question Question    Bug Bug    Answer Answer    Joke Joke    Praise Praise    Rant Rant    Admin Admin   

Use Ctrl+Left/Right to switch messages, Ctrl+Up/Down to switch threads, Ctrl+Shift+Left/Right to switch pages.