Creating reports and dashboards | Stimulsoft community forum

Reporting tool and data analytics tools for creating reports and dashboards in ASP.NET, ASP.NET MVC, .NET Core, Blazor, Angular, PHP, Python, WPF, JavaScript, and Java applications.
https://forum.stimulsoft.com/

Create a connection to Excel on a web server

https://forum.stimulsoft.com/viewtopic.php?t=39939

Page 2 of 2

Re: Create a connection to Excel on a web server

Posted: Sun Dec 03, 2017 5:34 pm
by Alex K.
Hello,

Please try to use the following connection string:
Provider=Microsoft.ACE.OLEDB.12.0;Data Source=\Density4.xlsx;
Extended Properties="Excel 12.0 Xml;HDR=YES";

Thank you.

Re: Create a connection to Excel on a web server

Posted: Tue Dec 05, 2017 12:35 pm
by cbrydon
That worked Alex - Thank you for the help!

Re: Create a connection to Excel on a web server

Posted: Tue Dec 05, 2017 4:30 pm
by Andrew
Hello,

Thank you for letting us know about this.
All times are UTC
Page 2 of 2

Powered by phpBB® Forum Software © phpBB Limited