3 Replies Latest reply: Jun 7, 2011 10:52 PM by Johannes Sunden RSS

    Export to Excel - Multiple Sheets over Dimension

      Hello all,

       

      What I'm trying to do is to take a table file which would normally be exported as one sheet in excel and instead to export it to multiple sheets whenever a particular dimension changes.

       

      Here is a sample of what some data might look like:

      @1@2
      @3
      A121Sampletext1
      A122Sampletext2
      A123Sampletext3
      B121Sampletext4
      B122Sampletext5
      B123Sampletext6
      C121Sampletext7
      C122Sampletext8

       

       

      and here is how I'd like the Excel file to look, whereby each tab is labeled as the different change in dimension and only that relevant data shows up:

      Picture2.jpg

       

      Can anyone provide some advice or sample code that might guide me to this type of solution?

       

      Thanks,

      - Peter