How to append data into a excel sheet column?

Question

I have existing Excel file with some data and I want to append data to it... ![enter image description here][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.ToString());
}

this is what I done. but I want to append..

Siddharth Rout · Accepted Answer · 2013-11-22 10:31:56Z

4

To append to an existing excel file, find the last row and increment it by 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;

and then simply write to that row

answered Nov 22, 2013 at 10:31

Siddharth Rout

150k18 gold badges212 silver badges258 bronze badges

Sign up to request clarification or add additional context in comments.

2 Comments

Sameera R. Over a year ago

looks like there is no built in function there. anyway this will help. thanks.

Sameera R. Over a year ago

this is the best option I got.. :)

Rudis · Accepted Answer · 2013-11-22 10:36:07Z

1

You must open the existing file instead of create a new.

var xlApp = new Excel.Application();
xlApp.Workbooks.Open(path + "Chat_Competitors.xls");

answered Nov 22, 2013 at 10:36

Rudis

1,23716 silver badges31 bronze badges

Collectives™ on Stack Overflow

How to append data into a excel sheet column?

2 Answers 2

2 Comments

Comments

Your Answer

Linked

Hot Network Questions

Collectives™ on Stack Overflow

2 Answers 2

2 Comments

Comments

Your Answer

Sign up or log in

Post as a guest

Linked

Related