Tim Larson
Top achievements
Rank 1
Rank 1
Tim Larson
asked on 28 Feb 2013, 07:42 PM
How do you export the data to Excel?
Thanks,
Tim
Thanks,
Tim
5 Answers, 1 is accepted
0
Hello Tim,
Thank you for writing.
RadPivotGrid currently does not support exporting functionality. I have added this feature request in our Public Issue Tracking System, so the users can vote for it. Feel free to add your vote here: http://www.telerik.com/support/pits.aspx#/public/winforms/14420.
I have updated you Telerik Points for this request.
Kind regards,
Stefan
the Telerik team
Thank you for writing.
RadPivotGrid currently does not support exporting functionality. I have added this feature request in our Public Issue Tracking System, so the users can vote for it. Feel free to add your vote here: http://www.telerik.com/support/pits.aspx#/public/winforms/14420.
I have updated you Telerik Points for this request.
Kind regards,
Stefan
the Telerik team
WinForms Q1 2013 boasts PivotGrid, PDF Viewer, Chart enhancements and more.
Join us for a FREE webinar to see all the new stuff in action.
Interested, but can’t attend? Register anyway and we’ll send you the recording.
Interested, but can’t attend? Register anyway and we’ll send you the recording.
0
Cesar
Top achievements
Rank 1
Rank 1
answered on 07 Mar 2013, 01:25 AM
Hello Stefan
I was trying to find a work a round, to export, my idea was make a loop for the columns count and row count and write in a file, but I didn't find the property cell in the radpivot control.
Would you brind me any idea about read the cells in the pivot table
Regards
CM
I was trying to find a work a round, to export, my idea was make a loop for the columns count and row count and write in a file, but I didn't find the property cell in the radpivot control.
Would you brind me any idea about read the cells in the pivot table
Regards
CM
0
Hi Tim,
Currently, it is only possible to get a value for a cell via the PivotCellElement. However, the PivotCellElement exists for a cell only when this cell is currently visible and it is not reliable to try to get such elements (except the one provided by the event arguments) during the formatting event. The fact that the value can be taken only from the visual cell element is a limitation of the API of RadPivotGrid. We will try to improve this with the next release by exposing a method which will allow you to get the value of a cell without the need of PivotCellElement. Here is a link to this request: http://www.telerik.com/support/pits.aspx#/public/winforms/14490, so you can track its status.
Kind regards,
Stefan
the Telerik team
Currently, it is only possible to get a value for a cell via the PivotCellElement. However, the PivotCellElement exists for a cell only when this cell is currently visible and it is not reliable to try to get such elements (except the one provided by the event arguments) during the formatting event. The fact that the value can be taken only from the visual cell element is a limitation of the API of RadPivotGrid. We will try to improve this with the next release by exposing a method which will allow you to get the value of a cell without the need of PivotCellElement. Here is a link to this request: http://www.telerik.com/support/pits.aspx#/public/winforms/14490, so you can track its status.
Kind regards,
Stefan
the Telerik team
WinForms Q1 2013 boasts PivotGrid, PDF Viewer, Chart enhancements and more.
Check out all of the latest highlights.
0
Enrico
Top achievements
Rank 1
Rank 1
answered on 03 Mar 2015, 03:03 PM
Please,
I cannot find a way to format Data Cell. When I export Winforms
RadPivotGrid1 to Microsoft Excel, data is always formatted as text, but
when I want numeric values I don't know how to change format.
I mean: format equal to integer or decimal value.
Regards,
Enrico
I cannot find a way to format Data Cell. When I export Winforms
RadPivotGrid1 to Microsoft Excel, data is always formatted as text, but
when I want numeric values I don't know how to change format.
I mean: format equal to integer or decimal value.
Regards,
Enrico
0
Hello Enrico,
I have answered your question in the other forum thread you have posted: http://www.telerik.com/forums/how-to-format-cells-with-1-decimal-point#BFxVIYXefEOcWhiNB5yeEw.
Regards,
Stefan
Telerik
I have answered your question in the other forum thread you have posted: http://www.telerik.com/forums/how-to-format-cells-with-1-decimal-point#BFxVIYXefEOcWhiNB5yeEw.
Regards,
Stefan
Telerik
Check out the Telerik Platform - the only platform that combines a rich set of UI tools with powerful cloud services to develop web, hybrid and native mobile apps.