Retrieve the data in to Excel from Grid table
I want retrieveing the data from grid table to Excel.Iam using Vesion 2.0.
Can we get the full xml data that includes the changes the client has made on the grid ?
Please help me.
I display a GRID based on XML data. There are icons just above the GRID that might be of interest - PRINT icon and an EXCEL icon.
Both EXPORT the current data shown in the GRID. The PRINT opens a new browser window that lays out the grid data so it can be printed. The EXCEL functions reads the grid, opens EXCEL and populates the spreadsheet - based also on the current data in the grid.
Here is the catch. The PRINT works great for our needs. You'd have to modify it for your own needs. The EXCEL actually uses the ActiveXControl. Right now, I'm still working on it. But it is functional.
For the sake of example, I included EVERYTHING in the page source. So, you can find the functions, copy the code, and modify it to fit your needs.
I'm also using the AW TAB control - it loads in different XML datasets into the grid. We use to have about 42 individual pages - with AW, I've been able to reduce that to 2 pages. NICE.
The link is:
Keep in mind, it does need work. It doesn't work well with Firefox yet - and forget about IE 7.0 beta. But, it is a start. Take any pieces of it you might find useful.
It would basically work like this:
The user initiates the Excel export.
You pull the XML from the grid and post it to a servlet.
The servlet loads an XSL and transforms the XML into SpreadsheetML.
The servlet then sets the content type to Excel and returns the SpreadsheetML.
Piece of cake.
Here's a sample of SpreadsheetML:
This topic is archived.
Back to support forum
Version 2Looking for AW 2.6 ?
The old site is here.