Using Spire.XLS in an Azure PaaS web service

Technical support for Spire.XLS

Moderators: iceblue support, Flash, Manager

Using Spire.XLS in an Azure PaaS web service

Postby jbarrow » Wed Jul 19, 2017 1:02 pm

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
jbarrow
 
Posts: 1
Joined: Wed Jul 19, 2017 12:35 pm

Re: Using Spire.XLS in an Azure PaaS web service

Postby Jane.Bai » Thu Jul 20, 2017 6:53 am

Hello,

Thanks for your inquiry.
Our Spire.XLS does not depend upon OleDbConnection or OleDbDataAdapter behind the scenes, and I have also made a test with your code, the result was correct. You could have a test on your side. If there's any doubt or problem, welcome to write back.

Sincerely,
Jane
E-iceblue support team
User avatar
Jane.Bai
 
Posts: 345
Joined: Tue Nov 29, 2016 1:47 am


Return to Spire.XLS

Who is online

Users browsing this forum: No registered users and 0 guests