I have been trying to load both alliance and horde's (same realm) CSV in 1 Worksheet. It will load all of the Alliance items, but when it goes to load the horde, it will only load the first 100. I have even made separate worksheets for Alliance and Horde...resulting in them both loading fine...but when i go to reference (importrange) it does the same thing...will load alliance but only the first 100 horde.
I know google has a 400K cell limit...but i am no where near that. When i import the data...i only import the Name/market price/quantity which is only 84K cells (for my realm)
Im fairly new when it comes to Google docs...so im wondering if i am doing something wrong? is there a cap on how much data can be imported in google docs?
On a side note..i tried doing the Blizzard API into google docs but i cant seem to get it to work. "TypeError: Cannot call method "getSheetByName" of null. (line 8)"
Any help would be amazing. Thanks