Hello Ventuzians!
THE FORUMS ARE CLOSED!

Please join our discord server HERE!! << click me :D

We are shutting our Ventuz Forum, but don't worry, it will all be archived for you to search in if you have a query. From now on, please add all your comments, questions or observations into our Discord Server

Thanks for the great time - see you on discord!!
Dee, Karol, Daniel and the whoooole Product and Support team!

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: 290
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