Deleting a row in excel without opening it

[Sreedevi]

Hi ,

I have a csv file which has rows more than max length(~65k) of Excel.
I need to delete the first row in this csv.
So now when I open this csv in excel the rows greater than than the maxcount gets deleted.

Is there a way of doing it without getting loosing the data.?
Can I delete the first row in Excel without opening it?

Any suggestions in this regard are welcome.


Thanks
~Rajesh

 

[Rabbie]

If it is a .csv file you can open it with most text editors. This should let you delete the first row.

 

[unmarkedhelicopter]

You can also specify which rows to import, say rows 320 - 41,000 or more typically you can serialy import large files 65k rows at a time.