Pivot Tables

75 views
Skip to first unread message

Jeff Stagg

unread,
Jul 12, 2013, 6:03:54 PM7/12/13
to ax...@googlegroups.com
I can't seem to get a pivot table to work on a sheet which doesn't have the related data in it, something like what follows is what I'm using code wise:

            pt = Axlsx::PivotTable.new(
                'A1:D10',
                "A1:C"+...@dataMatrixSheet.rows.length.to_s,
                @dataMatrixSheet)
            pt.rows = ['Title']
            pt.columns = ['Status']
            pt.data = ['ID']
            sheet.pivot_tables << pt
            sheet.pivot_tables.last

Is there not a method by which to get a pivot table in the current sheet which references another for data?

TIA!  ;-)
Reply all
Reply to author
Forward
0 new messages