Q and A about functionality and how to solve a special task for your application.
4 posts • Page 1 of 1
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?
- Posts: 279
- Joined: 18 Jan 2012, 11:36
- Location: Dubai, United Arab Emirates
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