Pivot table on the web

[Administrator]

Hi,

Is it possible to display data on a web page in pivot format as Excel. This pivot table should allow user to choose some rows of data. Also, allow user to export the data to Excel in a pivot table format. Any examples would be great!!

I found an example for pivot on your web page, but the zip file link doesn't work on this page..(http://www.syncfusion.com/support/kb/xlsio/Default.aspx?ToDo=view&questId=70). Could you please attach a link?

Any Example would be great!

Thanks!

[Melba Winshia]

Hi Rekha,

Thanks for your interest in Essential XlsIO.

Essential XlsIO does not have the capability to Create/Manipulate Pivot Tables. The only way that XlsIO can be used with Pivot tables is by creating the Pivot table using MS Excel and then dynamically fills in data using XlsIO. However, You can create named range and you can add new records to the range with the built in Data Form and the named range will be extended to include the new records. Here is the sample for your reference

Pivot_table.zip

Please take a look at the sample above and let me know if you have any other questions.

Thanks,
Melba

[Administrator]

Melba,

Thank you so much!!
Syncfusion has a great Support team!!

[Melba Winshia]

Hi Rekha,

Thanks for the update!

Kindly let me know if you have any other questions.

Thanks,
Melba