We currently have a web application that allows the user to upload (utilizing the RadAsyncUpload control) files of different formats (csv,html,txt,xlsx) where the file stream (using the IWorkBookFormatProvider) is ultimately converted to a PDF and stored in a MSSQL database record. The purpose of this process is so that we can have varying formats of input data and a common datatype that can be displayed in the web application. The problem is that some of the csv, txt and xlsx files can have as many as 750,000 rows of data and for the purpose being discussed, we are only interested in the first 50 rows of the file. I can use RowSelection and Remove the unwanted rows on smaller files. However, this takes a long time to accomplished on large files. How can I:
- Filter the worksheet rows so that I only get the first 50, or
- Insert the first 50 rows from worksheet A to worksheet B.