Creating an Excel file using .NET (C#) - Problems with columns headers!

I want to create & fill a .xls file using ADO.NET or LINQ, but I do not want to have the columns names in the first row. I just want to insert rows starting in row no. 1.

I know I have to insert colums first, but... is there a way to 'hide' those columns headers?

The problem is that, in first row of my spreadsheet, I must have only two values (one in A1 and the other in B1), but in the remaining rows I'll be inserting more than just two values (maximum 15 columns).

I'm open to suggestions开发者_如何学编程/hacks/tricks even if that's not the best way of doing this.

Thanks!

I think it is not the best way, but you can use Microsoft.Office.Interop.Excel

Propery you need is XlYesNoGuess

Hey you can use SpreadSheetGear or Aspose dll , which give you more functionality to create Excel work books using C# in .NET.