https://community.blueprism.com/t5/Product-Forum/Working-with-Large-Excel-files/m-p/70810#M23415 Hi, this is nonsense, sorry for the word but you will never load this amount of data into Blue Prism collection. Blue Prism is 32 bit application and as such it can reference only around ~1.5 to 1.8Gb RAM. Datatable (collection) use a lot of memory overhead. I successfully loaded around 100.000 rows with 5 columns but Blue Prism got very slow and we discarded this approach. If you could use OLEDB/ODBC that is perfect as you can write a query to your excel file and get just the values you need. If you need help let me know. regards, Zdenek Tue, 02 Apr 2019 19:17:00 GMT zdenek.kabatek 2019-04-02T19:17:00Z https://community.blueprism.com/t5/Product-Forum/Working-with-Large-Excel-files/m-p/70807#M23412 Morning I`m new here excuse me if I post in an incorrect place or manner. I`m working with Large for excel as a result u`d find that production data would not fit in an excel sheet when opening. Total number of rows and columns on a worksheet1,048,576 rows by 16,384 columns. My data then is more than this. How do I work around this because I need it opened in excel then I make use of the MS excel VBO to work with the data.   Regards Olwethu Madikwa RPA Developer. Tue, 02 Apr 2019 14:13:00 GMT https://community.blueprism.com/t5/Product-Forum/Working-with-Large-Excel-files/m-p/70807#M23412 OlwethuMadikwa1 2019-04-02T14:13:00Z https://community.blueprism.com/t5/Product-Forum/Working-with-Large-Excel-files/m-p/70808#M23413 If any person might have a solution to this i`d very much appreciate.. Tue, 02 Apr 2019 14:14:00 GMT https://community.blueprism.com/t5/Product-Forum/Working-with-Large-Excel-files/m-p/70808#M23413 OlwethuMadikwa1 2019-04-02T14:14:00Z https://community.blueprism.com/t5/Product-Forum/Working-with-Large-Excel-files/m-p/70809#M23414 If your data is that large, you'll need to break it up into chunks. If possible, I'd also consider using a SQL database and managing your data through that. Lastly, you could try use an MS Access DB, but it does depend on not just the number of rows, but the amount of data overall. Tue, 02 Apr 2019 16:12:00 GMT https://community.blueprism.com/t5/Product-Forum/Working-with-Large-Excel-files/m-p/70809#M23414 PatrickOttery1 2019-04-02T16:12:00Z https://community.blueprism.com/t5/Product-Forum/Working-with-Large-Excel-files/m-p/70810#M23415 Hi, this is nonsense, sorry for the word but you will never load this amount of data into Blue Prism collection. Blue Prism is 32 bit application and as such it can reference only around ~1.5 to 1.8Gb RAM. Datatable (collection) use a lot of memory overhead. I successfully loaded around 100.000 rows with 5 columns but Blue Prism got very slow and we discarded this approach. If you could use OLEDB/ODBC that is perfect as you can write a query to your excel file and get just the values you need. If you need help let me know. regards, Zdenek Tue, 02 Apr 2019 19:17:00 GMT https://community.blueprism.com/t5/Product-Forum/Working-with-Large-Excel-files/m-p/70810#M23415 zdenek.kabatek 2019-04-02T19:17:00Z https://community.blueprism.com/t5/Product-Forum/Working-with-Large-Excel-files/m-p/70811#M23416 Hi.. I have the same issue that My Excel has 65 Columns and 503567 rows, by using MS Excel VBO-->Split Worksheet Action able to split the data, but the output is it is saving in to 4 different Workbook. I want it in the same Workbook with different Worksheet names. If any person might have a solution to this i`d very helpful to me   Thu, 11 Apr 2019 23:10:00 GMT https://community.blueprism.com/t5/Product-Forum/Working-with-Large-Excel-files/m-p/70811#M23416 NagaYaparla 2019-04-11T23:10:00Z