tags:

views:

303

answers:

2
Q: 

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

Hello,

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!

+1  A: 

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

Propery you need is XlYesNoGuess

Stremlenye  2010-03-26 12:03:34
That should work, but I'm trying to find a way of doing this without opening 'Excel.exe' process.If I use Interop.Excel, users who execute my application are forced to have Microsoft Excel installed.Anyway, thanks for your answer ;)
tsocks  2010-03-26 23:53:17
I heard about Excel XML object model. Maybe its a decision...
Stremlenye  2010-03-29 07:26:55
A: 

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

Avinash  2010-04-16 07:06:36

related questions

Displaying Flash content in a C# WinForms application
How to get the value of built, encoded ViewState?
Unhandled Exception Handler in .NET 1.1
How do I connect to a database and loop over a recordset in C#?
How do I most elegantly express left join with aggregate SQL as LINQ query
Get a new object instance from a Type in C#
.NET Testing Framework Advice
Automatically update version number
What is the difference between an int and an Integer in Java/C#?
How to write to Web.Config in Medium Trust ?
WinForms ComboBox data binding gotcha
How do you sort a C# dictionary by value?
Adding Scripting functionality to .NET applications
Floating Point Number parsing: Is there a Catch All algorithm?
How do I print an HTML document from a web service?
Decoding T-SQL CAST in C#/VB.net
Anatomy of a "Memory Leak"
How do I get a distinct, ordered list of names from a DataTable using Linq
Reliable Timer in a Console Application
How do I fill a DataSet or a DataTable from a LINQ query resultset ?
What's the difference between Math.Floor() and Math.Truncate() in .NET?
How do I calculate relative time?
How do I calculate someone's age in C#?
Are there any conversion tools for porting Visual J# code to C#?
When setting a form's opacity should I use a decimal or double?