Our ASP.net 2.0 application imports some data from Oracle to Excel.
<?xml:namespace prefix = o ns = "urn:schemas-microsoft-com:office:office" />
I have two questions.
- How to use the group feature in Pivot table using Aspose? It is equivalent to using Excel menu Data -> Group and Outline -> Group.
- The group field must be date or time. We want to convert the column data from text to date. It can be done using Excel Menu Data-> Text to columns. How do we use this feature in Aspose?