Click here to Skip to main content
15,905,877 members
Home / Discussions / C#
   

C#

 
AnswerRe: Timestamp Value in SQLServer Pin
PIEBALDconsult17-May-13 8:43
mvePIEBALDconsult17-May-13 8:43 
AnswerRe: Timestamp Value in SQLServer Pin
abhi_here29-May-13 4:34
abhi_here29-May-13 4:34 
AnswerRe: Timestamp Value in SQLServer Pin
jschell17-May-13 10:32
jschell17-May-13 10:32 
GeneralRe: Timestamp Value in SQLServer Pin
PIEBALDconsult17-May-13 11:04
mvePIEBALDconsult17-May-13 11:04 
QuestionDifferent behaviour from button in MDI parent and button in child form Pin
FRotondo17-May-13 4:09
FRotondo17-May-13 4:09 
AnswerRe: Different behaviour from button in MDI parent and button in child form Pin
Simon_Whale17-May-13 10:21
Simon_Whale17-May-13 10:21 
GeneralRe: Different behaviour from button in MDI parent and button in child form Pin
FRotondo17-May-13 22:12
FRotondo17-May-13 22:12 
QuestionExtract XML values using XpathNavigator Pin
baranils17-May-13 1:03
baranils17-May-13 1:03 
AnswerRe: Extract XML values using XpathNavigator Pin
PIEBALDconsult17-May-13 4:39
mvePIEBALDconsult17-May-13 4:39 
GeneralRe: Extract XML values using XpathNavigator Pin
baranils17-May-13 4:56
baranils17-May-13 4:56 
AnswerRe: Extract XML values using XpathNavigator Pin
Abhinav S17-May-13 19:08
Abhinav S17-May-13 19:08 
AnswerRe: Extract XML values using XpathNavigator Pin
Alan Balkany20-May-13 11:32
Alan Balkany20-May-13 11:32 
QuestionA question on WCF Pin
Dewald17-May-13 0:56
Dewald17-May-13 0:56 
AnswerRe: A question on WCF Pin
Richard MacCutchan17-May-13 1:06
mveRichard MacCutchan17-May-13 1:06 
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 

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.