0 Replies Latest reply on Jul 10, 2008 1:32 PM by DiscoveryDave

    Excel Export: Mutiple Worksheets

    DiscoveryDave
      I'm using the MIME method to export data to excel from a query. My issue is that the export contains over 65K rows, which I believe is row limit for excel. Does anyone know a way to use the MIME method to export to one excel workbook but to split up the export into multiple worksheets within the workbook? Example of the method is below.

      <cfheader name="Content-Disposition" value="filename=missingThumbs.xls">

      <cfset TabChar = Chr(9)>
      <cfset NewLine = Chr(13) & Chr(10)>

      <cfcontent type="application/msexcel" reset="yes" >
      <cfquery name-"myquery">
      select data from source
      </cfquery>

      <cfoutput query="myquery">
      #titleText##TabChar##videoType##TabChar##assetId##TabChar##oldId##NewLine#
      </cfoutput>