I have created a web application to open and read an excel spreadsheet.
I found an example where I can Import [url removed, login to view]
I'm writing on a Windows 7 Pro machine using Visual Studio 2012
The machine also has IIS 7.5 and MS Office 365 installed.
My code works great in the debugger and when I publish to local File System and run in IIS (localhost)
However, when I publish to our testing server (Windows Server 2008 r2) or our production server (Small Business Server 2011) it stops throws an exception right here:
Dim excel As Application = CType(CreateObject("[url removed, login to view]"), [url removed, login to view])
Catch ex As Exception
dim errString as string = [url removed, login to view]
errString is always: Cannot create ActiveX component
I need this to work on both our testing machine and production machine.
Things I've tried:
I have opened Component Services>DCOM Config to set 'Launch and Activation Permissions' and 'Access Permissions'.
I searched for 'Microsoft Excel'
on the SBS server I found 'Microsoft Excel Application' and set local permissions for application pool identity
the Windows Server 2008 has no such entry.
Appication Pool Advanced Settings:
on production server
When I Enable 32-Bit Applications I get: HTTP Error 503. The service is unavailable.
on testing server
Enable 32-Bit Applications is set to true, I've tried both integrated and classic Managed Pipeline Modes
I need someone to demonstrate working code on a windows 2008 r2 server
Or work by the hour to resolve my Interop issue(s).
I will pay you to:
Provide a solution using VB.net and OpenXML to
1: Open a workbook
2: store the each sheet in a 2d array
I have decided it best in the long run if I limit my project to Option 2, so, 'specifically' I need the vb.net/OpenXML equivalent of what I did using the Interop.
For i As Integer = 1 To wb.Sheets.Count
Dim sheet As Worksheet = wb.Sheets(i)
Dim strdepartment As String = sheet.Name
Dim r As Range = sheet.UsedRange
'load all cells into 2d array
Dim array(,) As Object = r.Value(XlRangeValueDataType.xlRangeValueDefault)
10 freelancers are bidding on average $52/hour for this job
Hello, I am very much interested to do this work as i have strong knowledge in vb.net as well as excel related works. I would prefer to work for option 2. Please let me know if you are interested. Thanks