import excel workbook

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]

End Try

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

Option 1:

I need someone to demonstrate working code on a windows 2008 r2 server

Or work by the hour to resolve my Interop issue(s).

Option 2:

I will pay you to:

Provide a solution using 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 equivalent of what I did using the Interop.
For i As Integer = 1 To wb.Sheets.Count
'get sheet
Dim sheet As Worksheet = wb.Sheets(i)
Dim strdepartment As String = sheet.Name
'get range
Dim r As Range = sheet.UsedRange
'load all cells into 2d array
Dim array(,) As Object = r.Value(XlRangeValueDataType.xlRangeValueDefault)

Skills: PHP, Software Architecture

See more: writing modes, vb net array example, vb net array, c# programming, excel, .net,,, iis, microsoft excel, using array in vb net, small office solution, excel to application, excel spreadsheet web service, excel spreadsheet services, Excel pro, business excel services, advanced ms excel

About the Employer:
( 4 reviews ) Hermitage, United States

Project ID: #9986216

Awarded to:


Hello, Im interested to work on this. Im preferred to work on the second Option To read excel file using OpenXML since more experienced in OpenXml. it kind of copy paste code from my existing project and convert More

$50 USD / hour
(2 Reviews)

10 freelancers are bidding on average $52/hour for this job


A proposal has not yet been provided

$52 USD / hour
(28 Reviews)

Hello, I am very much interested to do this work as i have strong knowledge in as well as excel related works. I would prefer to work for option 2. Please let me know if you are interested. Thanks

$50 USD / hour
(63 Reviews)

Hello Sir, I have gone through your requirements is import excel workbook. we brief and understand your idea and preference for job as you are looking for. I have more than 5+ years of experience in .NET,, More

$52 USD / hour
(40 Reviews)

Hi, Nice to meet you. My name is Manh from Vietnam. After check your project details, i feel that your project is quite suitable with my skills. I am very confident that I can complete your project with best quality More

$55 USD / hour
(20 Reviews)

Dear Sir, Done numerous similar projects in the past and always impressed the clients with my excellent VBA solutions. Out of my 70 projects, almost 65+ are complex VB/VBA projects, hence i can definitely deliv More

$50 USD / hour
(10 Reviews)

You cannot open excel by using interoperate when from webserver because the OS block you to do that task. For the solution, I can bring you both solution can using interoperate indirectly or using Open XML which faster More

$52 USD / hour
(7 Reviews)
$55 USD / hour
(1 Review)

Hello, How are you? I found your job post and I’m very interested in your project. As a skilled Web / Software Programmer professional with experience developing web and software, I think you’ll find I More

$50 USD / hour
(0 Reviews)

Hello Sir/Madam, We have gone through the details you have provided and we have already worked on a similar project before and can deliver as u have mentioned and would be pleased to work on this with you to deliver th More

$55 USD / hour
(0 Reviews)

i have worked with Windows server 2008 /2012 , i have developped applications using .net , and i will show you how to resolve your problem thanks

$55 USD / hour
(0 Reviews)