Click here to Skip to main content
15,881,882 members
Home / Discussions / C#
   

C#

 
AnswerRe: Adding Elements of a List to Another List Pin
Richard MacCutchan20-Oct-12 3:01
mveRichard MacCutchan20-Oct-12 3:01 
GeneralRe: Adding Elements of a List to Another List Pin
ASPnoob20-Oct-12 3:58
ASPnoob20-Oct-12 3:58 
GeneralRe: Adding Elements of a List to Another List Pin
Richard MacCutchan20-Oct-12 4:05
mveRichard MacCutchan20-Oct-12 4:05 
QuestionDisable Print in webbrowser Pin
zaherAmad20-Oct-12 2:37
zaherAmad20-Oct-12 2:37 
AnswerRe: Disable Print in webbrowser Pin
Dave Kreskowiak20-Oct-12 3:55
mveDave Kreskowiak20-Oct-12 3:55 
QuestionWrite data into excel sheets using c# Pin
Arun kumar Gautam19-Oct-12 23:39
Arun kumar Gautam19-Oct-12 23:39 
AnswerRe: Write data into excel sheets using c# Pin
Richard MacCutchan20-Oct-12 1:27
mveRichard MacCutchan20-Oct-12 1:27 
AnswerRe: Write data into excel sheets using c# Pin
zaherAmad20-Oct-12 3:06
zaherAmad20-Oct-12 3:06 
C#
private void button1_Click(object sender, EventArgs e)
{
Excel.Application exapp=null;
Excel.Workbook exbook=null;
Excel.Worksheet exsheet = null;
object misvalue =System.Reflection.Missing.Value;
      
string fname = Application.StartupPath + "rep.xls"; 
exapp = new Excel.Application();

if (!File.Exists(fileToOpen))
{
exbook  = (Excel._Workbook)(exapp.Workbooks.Open
         (fileToOpen,0, true, 5, _value,_value, false,Excel.XlPlatform.xlWindows, _value,false, true,_value, _value,_value, _value));
}    
else
{
 exapp.SheetsInNewWorkbook = 1;
}
            exbook = exapp.Workbooks.Add(misvalue);
            //active last sheet non-zero indx 
exsheet = (Excel.Worksheet) 
 exbook.Worksheets.get_Item(exbook.Sheets.Count);

            exsheet.Cells[1, 1] = "First Name";
            exsheet.Cells[1, 2] = "Last Name";
            exsheet.Cells[1, 3] = "Address1";
            exsheet.Cells[1, 4] = "Address2";
            exsheet.Cells[1, 5] = "City";
            exsheet.Cells[1, 6] = "PinCode";
            exsheet.Cells[1, 7] = "Phone Number";
            exsheet.Cells[2, 1] = textBox1.Text.ToString();
            exsheet.Cells[2, 2] = textBox2.Text.ToString();
            exsheet.Cells[2, 3] = textBox3.Text.ToString();
            exsheet.Cells[2, 4] = textBox4.Text.ToString();
            exsheet.Cells[2, 5] = textBox5.Text.ToString();
            exsheet.Cells[2, 6] = textBox6.Text.ToString();
            exsheet.Cells[2, 7] = textBox7.Text.ToString();

if (!File.Exists(fileToOpen))
{       
exbook.SaveAs(fileToOpen,Excel.XlFileFormat.xlWorkbookNormal, misvalue, misvalue, misvalue, misvalue, Excel.XlSaveAsAccessMode.xlExclusive, misvalue, misvalue, misvalue, misvalue, misvalue);
}
else
{
exbook.Save();
}
            exapp.Quit();
            releaseObject(exapp);
            releaseObject(exbook);
            releaseObject(exsheet);
            }

GeneralRe: Write data into excel sheets using c# Pin
Arun kumar Gautam22-Oct-12 19:23
Arun kumar Gautam22-Oct-12 19:23 
QuestionI Want to do not open same view of My computer window ? Pin
rahul ameta19-Oct-12 23:33
rahul ameta19-Oct-12 23:33 
AnswerRe: I Want to do not open same view of My computer window ? Pin
OriginalGriff20-Oct-12 1:13
mveOriginalGriff20-Oct-12 1:13 
AnswerRe: I Want to do not open same view of My computer window ? Pin
Richard MacCutchan20-Oct-12 1:24
mveRichard MacCutchan20-Oct-12 1:24 
AnswerRe: I Want to do not open same view of My computer window ? Pin
Dave Kreskowiak20-Oct-12 3:52
mveDave Kreskowiak20-Oct-12 3:52 
QuestionC# hidden files Pin
rachel_m19-Oct-12 22:16
rachel_m19-Oct-12 22:16 
AnswerRe: C# hidden files Pin
Richard MacCutchan19-Oct-12 22:36
mveRichard MacCutchan19-Oct-12 22:36 
GeneralRe: C# hidden files Pin
rachel_m20-Oct-12 13:32
rachel_m20-Oct-12 13:32 
GeneralRe: C# hidden files Pin
Richard MacCutchan20-Oct-12 21:02
mveRichard MacCutchan20-Oct-12 21:02 
AnswerRe: C# hidden files Pin
Dave Kreskowiak20-Oct-12 3:50
mveDave Kreskowiak20-Oct-12 3:50 
GeneralRe: C# hidden files Pin
rachel_m20-Oct-12 13:33
rachel_m20-Oct-12 13:33 
GeneralRe: C# hidden files Pin
Dave Kreskowiak20-Oct-12 20:43
mveDave Kreskowiak20-Oct-12 20:43 
AnswerRe: C# hidden files Pin
Pete O'Hanlon20-Oct-12 4:16
mvePete O'Hanlon20-Oct-12 4:16 
AnswerRe: C# hidden files Pin
jschell20-Oct-12 4:46
jschell20-Oct-12 4:46 
GeneralRe: C# hidden files Pin
rachel_m20-Oct-12 13:38
rachel_m20-Oct-12 13:38 
AnswerRe: C# hidden files Pin
Richard Andrew x6421-Oct-12 12:07
professionalRichard Andrew x6421-Oct-12 12:07 
GeneralRe: C# hidden files Pin
rachel_m21-Oct-12 13:28
rachel_m21-Oct-12 13:28 

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.