myExcelApp = new Excel.ApplicationClass(); myExcelApp.Visible = false; myExcelWorkbooks = myExcelApp.Workbooks; SaveFileDialog save = new SaveFileDialog(); save.Filter = "Excel Files .xlsx|*.xlsx"; save.ShowDialog(); string sss = save.FileName; String fileName = sss; myExcelWorkbook = myExcelWorkbooks.Open(fileName, misValue, misValue, misValue, misValue, misValue, misValue, misValue, misValue, misValue, misValue, misValue, misValue, misValue, misValue); Excel.Worksheet myExcelWorksheet = (Excel.Worksheet)myExcelWorkbook.ActiveSheet; String cellFormulaAsString = myExcelWorksheet.get_Range("A1", misValue).Formula.ToString(); string s; int i = 1; foreach (ListViewItem li in listView2.Items) { s = "A" + i.ToString(); myExcelWorksheet.get_Range(s, misValue).Formula = li.Text; i++; } myExcelWorkbooks.Close()
var
This content, along with any associated source code and files, is licensed under The Code Project Open License (CPOL)