Partial Export2Excel Possible?

4 posts, 0 answers
  1. Mark Galbreath
    Mark Galbreath avatar
    171 posts
    Member since:
    Jul 2009

    Posted 17 Mar 2010 Link to this post

    I have a dataset consisting of over 127,000 records and need to split them up so as not to exceed Excel's 65k row limitation.  Is there a way to export a subset of all the records in a radgrid?

    The only way I can see to do it now is splitting the data at the database and populating 2 invisible radgrids, and having a 2-part process of exporting their contents.  This seems pretty kludgey to me.

    tia,
    Mark
  2. Thomas Salt
    Thomas Salt avatar
    136 posts
    Member since:
    Apr 2005

    Posted 17 Mar 2010 Link to this post

    Perhaps rebinding the datasource while grabbing only the top 65k records?

    In SQL the syntax is:
    SET ROWCOUNT 65000 
    SELECT * FROM MYTABLE 

  3. UI for ASP.NET Ajax is Ready for VS 2017
  4. Mark Galbreath
    Mark Galbreath avatar
    171 posts
    Member since:
    Jul 2009

    Posted 17 Mar 2010 Link to this post

    Yeah, you are think along the same lines I am where I would

    select * from myTable where rowcount <= 65000;

    I am hoping there is some undocumented method in the radgrid.export API I could use to save trips to the database.

    I wonder if LINQ to DataSet supports rowcount?

    Cheers!
    Mark
  5. Mike
    Mike avatar
    338 posts
    Member since:
    Jun 2008

    Posted 13 Jun 2013 Link to this post

    Why not just export to csv?  I had the same issue and the export to excel was x Times the size of a csv and they both opened MS Excel.
Back to Top