Hi
I am looking for a library which allow me to create and process excel 2007 documents, I found this http://ko.infragistics.com/dotnet/netadvantage/winforms/infragisticsexcel.aspx#Overview, but I can not find more information or examples. I have few questions.
1. Does it is possible to create and proces excel 2007 docs, using Open XML format ?
2. If 1. is true is it posiible to format cell, add formulas, look for cells having specifing values, inserting new rows, etc.
szepiet said: 1. Does it is possible to create and proces excel 2007 docs, using Open XML format ?
This is not currently supported but we have had many feature requests for it. We do not release featuresets until we're getting close to release as it's Infragistics policy to not promote vaporware. That being said, there is a very high probability that it might make the next release (8.3).
szepiet said: 2. If 1. is true is it posiible to format cell, add formulas, look for cells having specifing values, inserting new rows, etc.
There is built in support for formating cells and adding formulas. To look for specific values you would have to do a manual search through the cells. Inserting rows and columns is not yet supported. You can submit a feature request for the last feature here: http://devcenter.infragistics.com/Protected/RequestFeature.aspx.
Mike Dour"]This is not currently supported but we have had many feature requests for it. We do not release featuresets until we're getting close to release as it's Infragistics policy to not promote vaporware. That being said, there is a very high probability that it might make the next release (8.3).
I'm looking through the press release for 8.3, and it sounds like support for Excel 2007 is available in WinForms, but not ASP.NET? Is that accurate?
Best,Scott
The enhancements made to the Excel assembly shipped with WinForms will also be there for the Excel assembly shipped with ASP.NET, so technically yes. However, I'm not sure if built-in support was added to export the web grid to Excel 2007 format like it was added to the win grid exporter. You might want to ask that question on the ASP.NET Excel forum. That being said, even if support wasn't added, it can still be manually implemented by creating a Workbook instance for the 2007 format, passing it to the Save method on the web grid exporter and then manually saving out the Workbook instance with its Save method.