Solved

Create an XLSX from C#

Posted on 2012-04-07
13
526 Views
Last Modified: 2012-06-22
Hi all,

I have looked in several places but many show show to create an .xls file but I'm looking on creating a .xlsx file (Microsoft Office Excel 2007).

I cannot use the OpenXML open source. It has to be Microsoft Office.

I didn't think the COM Interop would need to be used for .xlsx.

If that is the case how would it be done?

Any information and an example would be greatly appreciated.

Thanks
0
Comment
Question by:davism
  • 8
  • 5
13 Comments
 
LVL 20

Expert Comment

by:BuggyCoder
ID: 37819667
0
 
LVL 1

Author Comment

by:davism
ID: 37820215
Hmmm...interesting. Is there another way using a COM or .NET reference for Excel that has these pieces and parts for the XML's or is it all XML based? Meaning there would be no COM or .NET object to use?
0
 
LVL 20

Accepted Solution

by:
BuggyCoder earned 150 total points
ID: 37820221
see this if you want to export data to excel file, here are 9 different ways to do it:-

http://www.codeproject.com/Articles/164582/8-Solutions-to-Export-Data-to-Excel-for-ASP-NET
0
Gigs: Get Your Project Delivered by an Expert

Select from freelancers specializing in everything from database administration to programming, who have proven themselves as experts in their field. Hire the best, collaborate easily, pay securely and get projects done right.

 
LVL 1

Author Comment

by:davism
ID: 37820227
No, I don't want to export data. I want to create a file and add rows and columns to the file.

That's all. Right now, I have it in a comma delimited file but I want to see about making it more integrated and creating new sheets in the spreadsheet xlsx.
0
 
LVL 20

Expert Comment

by:BuggyCoder
ID: 37820230
then com is the option i suppose....
0
 
LVL 1

Author Comment

by:davism
ID: 37820233
By the way, this is all using VS 2008 with .NET 3.5 (which that requires .NET 2.0)
0
 
LVL 1

Author Comment

by:davism
ID: 37820235
But isn't COM for XLS? And not for XLSX? (obviously 2 different flavors MS).
0
 
LVL 20

Expert Comment

by:BuggyCoder
ID: 37820238
i think the url that i gave in my first post should solve the problem....
0
 
LVL 1

Author Comment

by:davism
ID: 37820251
Except that requires open source and I can't do that. The "using ICSharpCode.SharpZipLib.Zip;"

If I pursued that I would have to see about using it with like Winzip or the Windows Compression instead. Probably Winzip though because the Windows Compression is somewhat problematic.
0
 
LVL 20

Expert Comment

by:BuggyCoder
ID: 37820255
0
 
LVL 1

Author Comment

by:davism
ID: 37820262
Yeah, I saw that one previously as well. I wasn't too sure though. Because the nature of the ExcelPackage.

I have to look at that in a little more detail.
0
 
LVL 1

Author Comment

by:davism
ID: 37820264
And the NPIO 1.2.1 for .NET 2.0
0
 
LVL 1

Author Closing Comment

by:davism
ID: 37972632
Thanks for the response and information. Turns out that using the XML's was really the only way. :-(

Thanks though and much appreciated.
0

Featured Post

Announcing the Most Valuable Experts of 2016

MVEs are more concerned with the satisfaction of those they help than with the considerable points they can earn. They are the types of people you feel privileged to call colleagues. Join us in honoring this amazing group of Experts.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Suggested Solutions

We all know that functional code is the leg that any good program stands on when it comes right down to it, however, if your program lacks a good user interface your product may not have the appeal needed to keep your customers happy. This issue can…
This article is for Object-Oriented Programming (OOP) beginners. An Interface contains declarations of events, indexers, methods and/or properties. Any class which implements the Interface should provide the concrete implementation for each Inter…
This tutorial gives a high-level tour of the interface of Marketo (a marketing automation tool to help businesses track and engage prospective customers and drive them to purchase). You will see the main areas including Marketing Activities, Design …
Two types of users will appreciate AOMEI Backupper Pro: 1 - Those with PCIe drives (and haven't found cloning software that works on them). 2 - Those who want a fast clone of their boot drive (no re-boots needed) and it can clone your drive wh…

816 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question

Need Help in Real-Time?

Connect with top rated Experts

8 Experts available now in Live!

Get 1:1 Help Now