Solved

Create an XLSX from C#

Posted on 2012-04-07
13
539 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
[X]
Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people just like you are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
  • 8
  • 5
13 Comments
 
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
PeopleSoft Has Never Been Easier

PeopleSoft Adoption Made Smooth & Simple!

On-The-Job Training Is made Intuitive & Easy With WalkMe's On-Screen Guidance Tool.  Claim Your Free WalkMe Account Now

 
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 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

Online Training Solution

Drastically shorten your training time with WalkMe's advanced online training solution that Guides your trainees to action. Forget about retraining and skyrocket knowledge retention rates.

Question has a verified solution.

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

Entity Framework is a powerful tool to help you interact with the DataBase but still doesn't help much when we have a Stored Procedure that returns more than one resultset. The solution takes some of out-of-the-box thinking; read on!
Calculating holidays and working days is a function that is often needed yet it is not one found within the Framework. This article presents one approach to building a working-day calculator for use in .NET.
In this video, viewers will be given step by step instructions on adjusting mouse, pointer and cursor visibility in Microsoft Windows 10. The video seeks to educate those who are struggling with the new Windows 10 Graphical User Interface. Change Cu…
Do you want to know how to make a graph with Microsoft Access? First, create a query with the data for the chart. Then make a blank form and add a chart control. This video also shows how to change what data is displayed on the graph as well as form…

623 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