I have
Date C1 C2 C3 C4
10/3 256 212 456 18
10/2 12 98 77 45
I want
Date C1 C2 C3 C4
blank row here - I'll put my new data on this row
10/3 256 212 456 18
10/2 12 98 77 45
p.s. I'm a VS 2003 C# guy not
VB, for example
using Excel;
Excel.Worksheet sheet = (Excel.Worksheet)book.Worksheets["Passenger"];
sheet.get_Range("A13", "L99").Clear();
sheet.get_Range("L2", "L4").ClearContents();
Excel.Range rngNow = sheet.get_Range("J9", Missing.Value);