i'm attempting to give the option to users to export all or page only, but I can't get the syntax of the statement correct.. I would have thought it to be..
spreadExporter.PagingExportOption.CurrentPageOnly = 0
spreadExporter.PagingExportOption.AllPages = 1
finally figured it out
spreadExporter.PagingExportOption = PagingExportOption.CurrentPageOnly
spreadExporter.PagingExportOption = PagingExportOption.AllPages