В роботі

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:

Try

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 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
'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)

Навички: PHP, Архітектура ПЗ

Показати більше: writing modes, vb net array example, vb net array, 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

Про роботодавця:
( 4 відгуки(-ів) ) Hermitage, United States

ID проекту: #9986216

Доручено:

sheikDev

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 Більше

$50 USD / год.
(2 відгуків(-и))
1.2

10 фрілансерів(-а) подали заявки на цю роботу; середня заявка - $52/год.

londonlance

A proposal has not yet been provided

$52 USD / год.
(28 відгуків(-и))
6.5
sumon355

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

$50 USD / год.
(63 відгуків(-и))
5.2
arityinfoway

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, c#.net, Більше

$52 USD / год.
(40 відгуків(-и))
5.2
manhpham

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 Більше

$55 USD / год.
(20 відгуків(-и))
4.3
kevivu

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 Більше

$50 USD / год.
(10 відгуків(-и))
4.0
huypq5

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 Більше

$52 USD / год.
(7 відгуків(-и))
3.7
$55 USD / год.
(1 відгук)
3.1
samsonnite39

Hello, How are you? I found your [url removed, login to view] 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 Більше

$50 USD / год.
(0 відгуків(-и))
0.0
techfinity2

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 Більше

$55 USD / год.
(0 відгуків(-и))
0.0
yoshimitsu7

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 / год.
(0 відгуків(-и))
0.0