Jack Green

hi everybody, I was trying to read a certain range from column in excel into an array in c# then to write it back in another column(as a matter of a simple trial), where the column is written into textbox3, the start of the range is written in texbox1 & …

public bool Kayit_Ekle() { sorgu = string.Format("Insert Into [{0}] ([SERVİS FORM NO],[ÇAĞRI NO]) Values ({1},{2})", sheet, formno,cagrino); cmd = new OleDbCommand(sorgu, Baglan()); cmd.Parameters.AddWithValue("@{2}",cagrino); int etkilenen = cmd.ExecuteNonQuery(); if (etkilenen == 0) { return false; } else { return true; } } Hello there, I am writing recording program with c …

Hi all, Want to write some data from C# to Excel. Code enough I thought, here at DANI's and on the web. So I managed to come up with this : [CODE=csharp]private void DoExcel(string Fname) { Microsoft.Office.Interop.Excel.ApplicationClass excel = null; Microsoft.Office.Interop.Excel.Workbook wb = null; Microsoft.Office.Interop.Excel.Worksheet ws = null; Microsoft.Office.Interop.Excel.Range rng …

Recently, I meet a problem that I need to insert header and footer in excel with C#, I use the following code: Worksheet sheet = workbook.Worksheets[0]; sheet.PageSetup.FullHeaderString = "E-iceblue"; sheet.PageSetup.IsPrintHeadings = true; sheet.Visibility = WorksheetVisibility.Visible; sheet.PageSetup.LeftFooter = "everlasting"; But when I launch it, the header and footer do not appear …