I wrote a program to collect data during an experiment then save the chart data into an Excel Spreadsheet. However, it appears that many experiments ran long and as a result the data exceeded the 65K row Excel limit. Excel only reads the end of the data, and TMS grid .loadfromXLS keeps generating errors when I attempt to read back in.
Is there a function to read the saved data back in?
Any other suggestion on how to read the data back in - to TeeChart or other - to do data analysis?
Thanks!
Reading back-in chart data exported as XLS
Hi,
I've posted one example into the steema.public.attachments which shows how to import data (Excel file) into the Chart.
I've posted one example into the steema.public.attachments which shows how to import data (Excel file) into the Chart.
Pep Jorge
http://support.steema.com
http://support.steema.com
Since using Excel, same limitations
Pep
I haven't gotten the example to compile, but it appears that it would use Excel to open file and import data. If so that would still have 65K row limitation. What I was hoping for was native VCL code that would read in file saved by TeeStore .SaveChartToFile which appears to write a BIFF file.
Thanks
Neil
I haven't gotten the example to compile, but it appears that it would use Excel to open file and import data. If so that would still have 65K row limitation. What I was hoping for was native VCL code that would read in file saved by TeeStore .SaveChartToFile which appears to write a BIFF file.
Thanks
Neil