Export large set of variable data to new xlsx using OpenXML SAX approach RRS feed

  • Question

  • Hi, Everyone

    I hope someone can help me I'm at my wits end!


    Export large set of data from Datatable (i.e. List of clients with some related details) - the Datatable may be different on every export.  This may range from a couple of hundred to a couple of million rows of data.

    I need to be able to create a new blank .xlsx file, export the details if the details span more than one sheet append extra sheets until the whole datatable is exported.

    I cannot use the existing template approach with is used in 100% of example code in all SAX approaches with OpenXML and after days of trying I just cannot anymore!

    Does anyone know of references that may guide me in the right direction here?

    Thursday, May 16, 2019 1:04 PM