Login Page - Create Account

Support Board


Date/Time: Mon, 29 Apr 2024 04:06:39 +0000



Post From: How to copy large amounts of data out of spreadsheets

[2014-10-06 18:47:06]
Pawel_Szpak - Posts: 48
Hi,

I'm trying to copy around 500k lines of data from a spreadsheet study Sierra chart sheet into excel (I prefer to work in excel for analysis). However, using simple select all & copy only results in the first 65,536 lines copying. I'm guessing this might be some kind of clipboard limitation?
What would you suggest is the best way to copy large amounts of data out of the sierra chart spreadsheets?
I cannot actually open the sierra chart spreadsheet in Excel - it just looks like gibberish - guessing the formats are incompatible?