Steema Central

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!

Hi,

I've posted one example into the steema.public.attachments which shows how to import data (Excel file) into the Chart.

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