Page 1 of 1

A lot of data (using excel)

Posted: 22 Nov 2017, 18:12
by Roman
Hi! We often work with large amounts of data in Excel. And we need to dynamically change the pointers to workbook cells. But changing causes content validation surge and program lags. Can you give us some advice of how to work with external data in general?
Thank you!

Re: A lot of data (using excel)

Posted: 20 Dec 2017, 17:26
by Roman
Any suggestions?

Re: A lot of data (using excel)

Posted: 23 Dec 2017, 08:16
by Christian Krix Schmidt
You could read from the Excel file yourself from within a C# node. I think if you use async file reading and parsing operations it should be possible to avoid the spikes you encounter. Maybe this helps: https://coderwall.com/p/app3ya/read-excel-file-in-c

Re: A lot of data (using excel)

Posted: 30 Dec 2017, 15:47
by Roman
Thank you! We will try.