This project has moved. For the latest updates, please go here.

Clear data in column

Feb 20, 2014 at 5:13 PM
How do I go about clearing all the data in a specific column, or is this possible?

I attempted to simply clear the data out of a cell like so but didn't have any luck.
if (File.Exists(path))
{
    //Connect to spreadsheet
    FileStream stream = File.Open(path, FileMode.Open, FileAccess.Read);
    FileInfo file = new FileInfo(path);
    _package = new ExcelPackage();

    //Pull data into EPPlus object
    _package.Load(stream);
    _sheet = _package.Workbook.Worksheets.First(); 

    //Clear out previous errors
    _sheet.Cells["L1"].Clear();
}