WinForms, ASP.NET and WPF Grid Controls: New Excel Data Export Engine (Now available in v14.2)

This is exciting.

When is 14.2 due ?

Well, there's really no such thing as "too much support for integration with Excel", is there?

This is Great. When is the next release

I think this is amazing, especially combined with the performance improvements in time and memory!

Great feature, we have been waiting for it since a long time,

what about columns grouping?

Fantastic work, I hoped this was coming when work started on your spreadsheet product.

Brilliant news, will this also be supported by the PivotGrid as one of the biggest annoyances of my users is the amount of memory required when exporting data directly from the pivotgrid.

This is Great.

Very much appreciated new features and performance improvements.  Well done DX.

These looks pretty awesome, indeed! :)

Quick question though: how much control are we given over the process? For example, what if I do NOT want lookup values to appear in the Excel sheet? Do I get to decide? If so, at which level? Editor? Column? Grid?

Awesome! I look forward to seeing this!

Any chance to see the same functionality in VCL :-)

Wow!

This is great, but what about Excel Pivot tables support?

Ray - Appreciate you taking the time to respond directly to me on here.  One of the key assets you possess as a company is deliver fantastic .Net controls, but I do seem to feel that sometimes you do leave a certain part of your libraries by the way side to concentrate on new stuff.  I remember a while back there was a single release completely dedicated to clearing bugs and just introducing the small features users have asked for over a long period of time.  Do you have any plans to do this again as I know among the DevExpress user base this went down extremely well.

still expecting for pivotgrid with pivottable in excel.

Great!

I agree with Scott. I would be happy if I will not find anything new, rather old bugs/flaws will be fixed, old request solved etc.  It is not easy to follow the speed od introductions of new controls, features etc. The F1 car might go to pitstop to take a rest, make a maintenance and later go to race again :-)

Cool Feature.... When is this expected?

To expand on what Scott and Robert said, I would like to see more customer involvement through voting up existing requests/fixes. I imagine that was always the intent since we can vote now. I just think there needs to be a place where we can see items grouped by product and ordered by vote count. I'm sure there are plenty of features I would like to use that I have not reported on.

Will the new export engine provide faster/optimized export from ASPxGridView/ ASPxPivotGrid too?

Currently grids throw an out of memory exceptions (I understand they depend on the server memory available etc.).

Awesome! Can't wait to try this out in our production systems. Thanks

Will the Excel data engine (import and export) be available via a programming API without requiring any UI or reporting components?

Great, my customer complained about missing these features for years.

I have some clients with lots of data, and for this we use a Large Data Grid (MVC).  Sure, we encourage filtering and reducing before exporting, but it's a shame that the mvc grid export doesn't use memory more intelligently, and throws an out of memory error for large amounts to data, requiring us to consider other options.

Will this new export still throw those same out of memory exceptions, insisting on containing everything in memory just like the current MVC grid export code?

Sounds like exactly what I wanted to hear.

Great work as always DevExpress, although Programming is not my bread and butter any more, I still enjoy keeping up with what is happening out in the industry. As always the improvements I see in the suite across all the technologies is nothing short of amazing. Keep it up team.

@Andrew, thanks. I'm not sure if the non-UI Excel handling is available for me. I'm still building with 9.3.4 even though I have 10.2.3.

Excellent - but we want this for the pivot grid too. Any idea on when this might be done? 2015?

These are great features, I will be using them from day one!

Are there plans to implement this style of engine on the TreelList, Pivot, and VGrid in the future?

I've had to implement custom exports for all of those because the delivered ones hang on large datasets.

See also the BestFit algorithms.

That looks super exciting! I would also add my voice to having at least the performance improvements integrated into the PivotGrid exporting engine.

Great work DevExpress!

> As much as I'd like to think we are superhuman, the reality is that it does take time to add these features to our products.

This is of course understood- and there look like there is quite a lot of very good stuff in this release.  

But look at this from our perspective- the customers have next to no visibility as to what is showing up in a given release.   Tickets that get marked as "Accepted" sometimes sit for 5-10 years with no additional status or comments.

The Excel exports have been a longstanding pain point with the DevEx controls.  Both with the performance, the WYSIWYG quirks, and with the very cumbersome linkage to the printing module.  

Seeing a "Direct to Excel" module in the Grid control is an enormously welcome step forward- we're just very much hoping to see this trend continue with the Pivot/TreeList in future feature releases.  And while I'm aware of the legal issues surrounding committing to future capabilities- it would be very welcome if customers were given some clearer indication as to what was upcoming.

Which property controls old or new export? And how do I get rid of those ugly solid lines in the new export?

Great, Is the new Excel Data Export Engine available in VCL.

This is very exciting news, thanks DevX.

Will this also mean the RenderBrick method (which is used now to duplicate either row to cell formating/background colours within the grid), will be come redundant, i.e. by default the grid will export with the same formatting as within the grid automatically?

Can you post the performance numbers memory and time wise by number of cell items instead of number of rows?  600K rows with 5 cols is 3M cells, which is equivalent to 100K rows with 30 cols, which is not extreme case these days.  Can we see performance numbers in 1M cell increments up to say a 600K by 30 cols which is 18M cells?