Related Posts
Hello Verizon fellows, In Deloitte, there's a facility to claim a certain reimbursement for purchasing mobile devices through their portal or something. Similarly, do VDSI employees have any discounts or reimbursement for purchasing devices through Verizon? If so, kindly let me know how to check it out. Thanks in advance.
Any one like. to wear nosepin?
How’s everyone holding up?
Hi Fishies, I was hired for wealth and asset management project EY . It is capital market domain. Any body have any idea about this project going on in EY and the tools used for it.
Please advise if anyone have idea about it.
Just want to know any global tool they use for wealth and asset management, so it's a plus for me to join.
Thanks in advance
Additional Posts in Excel Genius
Would anyone be willing to teach me vlookup?
New to Fishbowl?
unlock all discussions on Fishbowl.







Modwize 1
Coach
Alteryx
Subject Expert
Huh, but why would you use excel as the original file? Change it to .csv; excel doesn't support* more than 2^20 rows, if you save your file as one, you will lose the data.
I'm not sure if the file itself already exclude the data, or if it's done after - you may want to test it, but I think the file doesn't save the data itself, so your "excel file" would only have the first 2^20 rows
*It's not that excel doesn't support it, but the UI doesn't. You can still operate with more than +1MM rows if you use a virtual pivot table, although I don't recommend - above ~400k rows, you'd be better using an alternative; and I'm against the use of pivot tables, even the virtual one
Why do you need all your rows in one workbook? Why not loop through an array and do an incremental load
In one workbook so I can export all the rows to a sql table or import it into a sql table from one workbook instead of 7-8 of them
Read the Excel file with Python (pandas has performant support for xlsx) and ship the rows off to your SQL DB in chunks. Then ditch the Excel file in an archive somewhere and use your database moving forward
if your goal put data to SQL table, you can do without excel. you dont need it. Just use python or C# get from your source Sound like API put directly in SQL. If you really wanna use excel then use VBA script (sql connection) and get from source until some limit(ex 500k row) then insert into table.