How far away is the pivot table feature?

[John Arrowwood]

I'm creating a spreadsheet to serve as a reporting mechanism, and it would be FANTASTIC if I could embed the pivot table to do the summarization was already there.  Is the ability to create a pivot table on the road map at this point?  If so, how far out is it?

[jmcnamara]

On Tuesday, 6 January 2015 04:48:13 UTC, John Arrowwood wrote:

I'm creating a spreadsheet to serve as a reporting mechanism, and it would be FANTASTIC if I could embed the pivot table to do the summarization was already there.  Is the ability to create a pivot table on the road map at this point?  If so, how far out is it?

Hi,

Pivot tables are a frequently requested feature. However, it unlikely to be implemented for the following reasons:

• It would be a difficult task to do correctly, not least of all because pivot tables in Excel have a data cache file that is hard to replicate.
• It would require a very large number of test cases.
  
• There would be several months work involved.
• The API would be difficult to define since Pivot Table have such a large number of features. (There is a reason that Excel has built-in helpers for Pivot Tables).

Regards,

John 

[John Arrowwood]

Darn.  :)

--
You received this message because you are subscribed to a topic in the Google Groups "Spreadsheet::WriteExcel" group.
To unsubscribe from this topic, visit https://groups.google.com/d/topic/spreadsheet-writeexcel/tv5tZ3QT7pI/unsubscribe.
To unsubscribe from this group and all its topics, send an email to spreadsheet-write...@googlegroups.com.
To post to this group, send email to spreadsheet...@googlegroups.com.
Visit this group at http://groups.google.com/group/spreadsheet-writeexcel.
For more options, visit https://groups.google.com/d/optout.

--

John Arrowwood,

Consulting Hypnotist / Hypnotherapist
http://www.JohnArrowwood.com
503.863.4823

[mchappell67]

We've solved this in two ways:

 

1.  Using Excel, create a workbook that contains the data.  Then, create an AUTO_OPEN macro that creates the pivot table in VBA (ugly, but possible).  Save the file, then use 'extract_vba' to pull out the VBA code.  Using ExcelWriter, create a workbook that has the data, and attach the VBA that was extracted.  When you open the file, the AUTO_OPEN macro will run and create the pivot table.

 

2.  If the end product is very complex, we have created the workbook in Excel, including any pivot tables.  Let's call this the 'master' workbook.  Then, we have created a data file using ExcelWriter.  Let's call this the 'data' workbook.  The 'master' workbook contains a macro, either AUTO_OPEN, or not, that loops through all of the open workbooks that the user has open.  If the 'master' finds the 'data' workbook open, it copies the data to the 'master', and refreshes the pivot table.

 

Mark

 

 

On Thursday, January 8, 2015 at 2:36:11 PM UTC-6, John Arrowwood wrote:

Darn.  :)

On Tue, Jan 6, 2015 at 11:46 AM, jmcnamara <jmcn...@cpan.org> wrote:

On Tuesday, 6 January 2015 04:48:13 UTC, John Arrowwood wrote:

I'm creating a spreadsheet to serve as a reporting mechanism, and it would be FANTASTIC if I could embed the pivot table to do the summarization was already there.  Is the ability to create a pivot table on the road map at this point?  If so, how far out is it?

Hi,

Pivot tables are a frequently requested feature. However, it unlikely to be implemented for the following reasons:

• It would be a difficult task to do correctly, not least of all because pivot tables in Excel have a data cache file that is hard to replicate.
• It would require a very large number of test cases.
  
• There would be several months work involved.
• The API would be difficult to define since Pivot Table have such a large number of features. (There is a reason that Excel has built-in helpers for Pivot Tables).

Regards,

John 

--
You received this message because you are subscribed to a topic in the Google Groups "Spreadsheet::WriteExcel" group.
To unsubscribe from this topic, visit https://groups.google.com/d/topic/spreadsheet-writeexcel/tv5tZ3QT7pI/unsubscribe.

To unsubscribe from this group and all its topics, send an email to spreadsheet-writeexcel+unsub...@googlegroups.com.

To post to this group, send email to spreadsheet...@googlegroups.com.
Visit this group at http://groups.google.com/group/spreadsheet-writeexcel.
For more options, visit https://groups.google.com/d/optout.

--

John Arrowwood,

Consulting Hypnotist / Hypnotherapist
http://www.JohnArrowwood.com
503.863.4823