locked
Excel Office 365 column selection getDataAsync returns "requested data set is too large" RRS feed

  • Question

  • In Office 365 Excel worksheet, the user selects columns by clicking the worksheet column header.  When my app for Office calls getDataAsync() with the binding name for that selection, the result is always

    "The requested data set is too large". 

    I have the filterType set to 'onlyVisible'.  Is there another option to have excel only return the 100 rows with content instead of attempting to return data for all rows (including all the thousands of empty/not used cells at the bottom of the 100 used rows) in the worksheet column?

    Monday, October 29, 2012 6:17 PM

All replies

  • Hi Marka42,

    Thank you for posting in the MSDN Forum.

    Could you please provide your code? It will be helpful for troubleshooting.

    Best regards,


    Quist Zhang [MSFT]
    MSDN Community Support | Feedback to us

    Wednesday, October 31, 2012 8:41 AM
  • 1. You should only select the cell or a range you want to process, don't select the whole column or whole line, if you select the whole column, the selection is too big for Office app to process, so it always give you "too large" error message. In your case, you should only select a range of cell to add binding

    2. You could use filter function (in Data Ribbon\Filter) to hide empty or not used cells, then use 'onlyVisible'  to return visible cells

    Another option is, use binding.getDataAsync method, it has optional parameters startRow, startColumn, rowCount, columnCount which can only return a subrange

    http://msdn.microsoft.com/en-us/library/office/fp161073(v=office.1501401).aspx

     

    Wednesday, March 12, 2014 6:19 AM