i was wondering if it is possible to have the worksheets and the data they contain, be streamed to a file as opposed to staying in memory?
thank you for your help,
michael
Hi,
Well, I am not very clear about your need. You can load excel file format from some path / url or from streams using Workbook.Open() the overloaded method. Similarly, you may save to have an excel file or save the workbook with data to streams using the overloaded method i.e.., Workbook.Save() method. If you are to extract pure worksheets data without any formattings or formulas calculated, you can utilize Workbook.LoadData() method which is a bit faster than Open method.
Thank you.