A lot of data (using excel)

Q and A about functionality and how to solve a special task for your application.

Moderator: Support

Post Reply
Roman
Posts: 9
Joined: 25 Oct 2016, 13:28

A lot of data (using excel)

Post by Roman » 22 Nov 2017, 18:12

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!

Roman
Posts: 9
Joined: 25 Oct 2016, 13:28

Re: A lot of data (using excel)

Post by Roman » 20 Dec 2017, 17:26

Any suggestions?

Christian Krix Schmidt
Posts: 284
Joined: 18 Jan 2012, 11:36
Location: Dubai, United Arab Emirates
Contact:

Re: A lot of data (using excel)

Post by Christian Krix Schmidt » 23 Dec 2017, 08:16

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

Roman
Posts: 9
Joined: 25 Oct 2016, 13:28

Re: A lot of data (using excel)

Post by Roman » 30 Dec 2017, 15:47

Thank you! We will try.

Post Reply