We are moving a web application from an on-premise Windows server to an Azure PaaS web service. Our existing web app's interaction with Excel 97-2003 version templates depends upon a OleDbConnection and OleDbDataAdapter, things that are not available in the Azure environment.
I anticipate having an Excel 97-2003 file as a stream from Azure file storage and need to get it into a DataTable object. The following works in my Windows development environment and I want to know if it will work the same when run under an Azure web service. Another way of asking the question is this: Does Spire.XLS depend upon OleDbConnection and OleDbDataAdapter behind the scenes?
Workbook workbook = new Workbook();
workbook.LoadFromStream(stream);
Worksheet sheet = workbook.Worksheets[0];
DataTable dt = sheet.ExportDataTable();
Thanks.
-jb