J'ai déjà un file Excel avec des données et je souhaite y append des données …! [Entrez la description de l'image ici] [1]
try { xlApp = new Excel.Application(); xlWorkBook = xlApp.Workbooks.Add(misValue); xlWorkSheet = (Excel.Worksheet)xlWorkBook.Worksheets.get_Item(1); xlWorkSheet.Cells[1, 1] = "http://csharp.net-informations.com"; xlWorkBook.Save(); Object newpath = path + "Chat_Competitors.xls"; xlWorkBook.SaveAs(newpath, Excel.XlFileFormat.xlWorkbookNormal, misValue, misValue, misValue, misValue, Excel.XlSaveAsAccessMode.xlExclusive, misValue, misValue, misValue, misValue, misValue); xlWorkBook.Close(true, misValue, misValue); xlApp.Quit(); } catch (Exception ex) { MessageBox.Show("Error" + ex.ToSsortingng()); }
C'est ce que j'ai fait. mais je veux append …
Pour append un file Excel existant, searchz la dernière ligne et incrémentez-la par 1
int _lastRow = xlWorkSheet.Cells.Find( "*", xlWorkSheet.Cells[1,1], Excel.XlFindLookIn.xlFormulas, Excel.XlLookAt.xlPart, Excel.XlSearchOrder.xlByRows, Excel.XlSearchDirection.xlPrevious, misValue, misValue, misValue ).Row + 1;
int _lastRow = xlWorkSheet.Cells.Find (int _lastRow = xlWorkSheet.Cells.Find( "*", xlWorkSheet.Cells[1,1], Excel.XlFindLookIn.xlFormulas, Excel.XlLookAt.xlPart, Excel.XlSearchOrder.xlByRows, Excel.XlSearchDirection.xlPrevious, misValue, misValue, misValue ).Row + 1;
"*",int _lastRow = xlWorkSheet.Cells.Find( "*", xlWorkSheet.Cells[1,1], Excel.XlFindLookIn.xlFormulas, Excel.XlLookAt.xlPart, Excel.XlSearchOrder.xlByRows, Excel.XlSearchDirection.xlPrevious, misValue, misValue, misValue ).Row + 1;
xlWorkSheet.Cells [1,1],int _lastRow = xlWorkSheet.Cells.Find( "*", xlWorkSheet.Cells[1,1], Excel.XlFindLookIn.xlFormulas, Excel.XlLookAt.xlPart, Excel.XlSearchOrder.xlByRows, Excel.XlSearchDirection.xlPrevious, misValue, misValue, misValue ).Row + 1;
Excel.XlFindLookIn.xlFormulas,int _lastRow = xlWorkSheet.Cells.Find( "*", xlWorkSheet.Cells[1,1], Excel.XlFindLookIn.xlFormulas, Excel.XlLookAt.xlPart, Excel.XlSearchOrder.xlByRows, Excel.XlSearchDirection.xlPrevious, misValue, misValue, misValue ).Row + 1;
Excel.XlLookAt.xlPart,int _lastRow = xlWorkSheet.Cells.Find( "*", xlWorkSheet.Cells[1,1], Excel.XlFindLookIn.xlFormulas, Excel.XlLookAt.xlPart, Excel.XlSearchOrder.xlByRows, Excel.XlSearchDirection.xlPrevious, misValue, misValue, misValue ).Row + 1;
Excel.XlSearchOrder.xlByRows,int _lastRow = xlWorkSheet.Cells.Find( "*", xlWorkSheet.Cells[1,1], Excel.XlFindLookIn.xlFormulas, Excel.XlLookAt.xlPart, Excel.XlSearchOrder.xlByRows, Excel.XlSearchDirection.xlPrevious, misValue, misValue, misValue ).Row + 1;
Excel.XlSearchDirection.xlPrevious,int _lastRow = xlWorkSheet.Cells.Find( "*", xlWorkSheet.Cells[1,1], Excel.XlFindLookIn.xlFormulas, Excel.XlLookAt.xlPart, Excel.XlSearchOrder.xlByRows, Excel.XlSearchDirection.xlPrevious, misValue, misValue, misValue ).Row + 1;
misValue,int _lastRow = xlWorkSheet.Cells.Find( "*", xlWorkSheet.Cells[1,1], Excel.XlFindLookIn.xlFormulas, Excel.XlLookAt.xlPart, Excel.XlSearchOrder.xlByRows, Excel.XlSearchDirection.xlPrevious, misValue, misValue, misValue ).Row + 1;
misValue,int _lastRow = xlWorkSheet.Cells.Find( "*", xlWorkSheet.Cells[1,1], Excel.XlFindLookIn.xlFormulas, Excel.XlLookAt.xlPart, Excel.XlSearchOrder.xlByRows, Excel.XlSearchDirection.xlPrevious, misValue, misValue, misValue ).Row + 1;
misValueint _lastRow = xlWorkSheet.Cells.Find( "*", xlWorkSheet.Cells[1,1], Excel.XlFindLookIn.xlFormulas, Excel.XlLookAt.xlPart, Excel.XlSearchOrder.xlByRows, Excel.XlSearchDirection.xlPrevious, misValue, misValue, misValue ).Row + 1;
et ensuite écrire sur cette ligne
Vous devez ouvrir le file existant au lieu de créer un nouveau.
var xlApp = new Excel.Application(); xlApp.Workbooks.Open(path + "Chat_Competitors.xls");
var xlApp = new Excel.Application ();var xlApp = new Excel.Application(); xlApp.Workbooks.Open(path + "Chat_Competitors.xls");