Spire.XLS is a professional Excel .NET library that can be used to any type of .NET( C#, VB.NET, ASP.NET, .NET Core) application and Java (J2SE and J2EE) application.

Fri May 04, 2012 2:07 pm

I downloaded and installed the trial version(spire.xls_standard_6.5). I'm using VB.net to write a basic app to open an excel add some data and save it.
I have added reference to spire.XLS.dll located at C:\Program Files (x86)\e-iceblue\Spire.XLS Standard Edition\Bin\NET4.0

below is the sample 3 lines of code

Imports Spire.Xls
Dim xlWorkBook As New Spire.Xls.Workbook()
Dim xlWorkSheet As Worksheet

When I compile, it throws error on all three lines. I also notice that when I add reference for the first time and right-click on it and select "view in object browser" it shows me that assembly but when I build the application and try to do the same thing I dont see it in the object browser. Not sure what is going on.

Thanks for help.

Posts: 3
Joined: Fri May 04, 2012 1:27 pm

Mon May 07, 2012 3:21 am

Hi edantas,

Please make sure that you are using .NET Framework 4, not using .NET Framework 4 Client Profile. You can double-click the "Properties" to check and change this setting. I attanched a picture for you. Please have a chek.

e-iceblue support
e-iceblue Co.,Ltd
setting pictures
pic.jpg (28.83 KiB) Viewed 2296 times

Posts: 17
Joined: Tue Apr 24, 2012 4:53 am

Return to Spire.XLS