A lot of data (using excel)

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

A lot of data (using excel)

Postby 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: 6
Joined: 25 Oct 2016, 13:28

Re: A lot of data (using excel)

Postby Roman » 20 Dec 2017, 17:26

Any suggestions?
Roman
 
Posts: 6
Joined: 25 Oct 2016, 13:28

Re: A lot of data (using excel)

Postby 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
Christian Krix Schmidt
 
Posts: 272
Joined: 18 Jan 2012, 11:36
Location: Dubai, United Arab Emirates

Re: A lot of data (using excel)

Postby Roman » 30 Dec 2017, 15:47

Thank you! We will try.
Roman
 
Posts: 6
Joined: 25 Oct 2016, 13:28


Return to How to