Solved

Create an XLSX from C#

Posted on 2012-04-07
13
527 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
Free Tool: Subnet Calculator

The subnet calculator helps you design networks by taking an IP address and network mask and returning information such as network, broadcast address, and host range.

One of a set of tools we're offering as a way of saying thank you for being a part of the community.

 
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

Free Tool: IP Lookup

Get more info about an IP address or domain name, such as organization, abuse contacts and geolocation.

One of a set of tools we are providing to everyone as a way of saying thank you for being a part of the community.

Question has a verified solution.

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

Suggested Solutions

In order to hide the "ugly" records selectors (triangles) in the rowheaders, here are some suggestions. Microsoft doesn't have a direct method/property to do it. You can only hide the rowheader column. First solution, the easy way The first sol…
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…

856 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