2

All,

In the past I created a lot of dynamic Excel (2003) spreadsheets in the following ways:

1.Using Excel COM object, 2.XML representation of spreadsheets, 3.SyncFusion controls for creating Excel Spreadsheets

All the above generated from C#.NET Code

Now my question is what are the best tehcnologies for creating Excel 2007 spreadsheets? Has anything changed ? I know Excel 2007 is much more advanced than 2003. Please note my needs have changed now and I need to create even more complex spreadsheets that include pivots etc.

Again I want to create these new spreadsheets using .NET Framework.

Thanks, Marios

Joel Coehoorn
  • 399,467
  • 113
  • 570
  • 794
koumides
  • 2,464
  • 5
  • 34
  • 54

3 Answers3

0

Because 2007 Office files are XML packages, they are created as Packages with FW 3.0.

See http://support.microsoft.com/kb/931866.

GSerg
  • 76,472
  • 17
  • 159
  • 346
0

Take a look at this question on StackOverflow:

Create Excel (.XLS and .XLSX) file from C#

I think ExcelPackage can be a fit when it comes to Excel 2007.

Community
  • 1
  • 1
Leniel Maccaferri
  • 100,159
  • 46
  • 371
  • 480
0

I can recommend the SpreadsheetGear library - it is commercial but a lot faster than the COM approach.

Another benefit: no dependencies on the client machine, you could use e.g. OpenOffice as viewer

http://www.spreadsheetgear.com/

Tobias Schittkowski
  • 2,221
  • 2
  • 16
  • 25