1.6k
views4
comments

Hello, all. I'm trying to read and write data to/from an Excel file. I can't even get to first base. I downloaded and installed the Office PrimaryInteropAssembly.exe, but only a few dll's were installed, and none of them included the Office dll's. I have the Home/Student Office and the free version of Visual Studio.

Can anyone help?

Thanks.

Bob

Hi,

using Interop is not best way to work with Excel in .NET. You can try using GemBox .NET Excel component which is free for commercial use (limit is 150 rows).

Here is a list of reasons why GemBox.Spreadsheet is better then Excel Interop and Excel Automation

By filip on 7/14/2009 7:07 AM (permalink)

Are you trying to do this in F# (since this is an F# forum)?

Try using this library:

[link:www.codeproject.com]

I have not tried it but it may work for you if you are writing this in F# or C#. Note that you will have to create a datatable first.

By attrition on 12/8/2008 4:41 PM (permalink)

Yes, I'm trying to do this in F#. I was using the approach in F# for Scientists, and getting nowhere. I think maybe I need the Visual Studio Professional that includes the Visual Studio Tools for Office. Can anyone at Microsoft tell me if I'm right or wrong? At present I'm using the Visual Studio free version.

I'd like a lightweight approach rather than a whole class library.

Thanks.

Bob

By bobmccrory on 12/8/2008 6:29 PM (permalink)

you can't use F# with express edition

you can try Sharpdevelopp 3.0 with F# project

add reference to Microsoft.Office.Interop.Excel (you find it COM tab) see below for an example (in excel 2003) #light module InteropExcel2003 open Microsoft.Office.Interop.Excel let u=System.Reflection.Missing.Value // for missing values let app=new Microsoft.Office.Interop.Excel.ApplicationClass(Visible=true) app.ScreenUpdating <- false // add a new workbook let wb=app.Workbooks.Add(XlWBATemplate.xlWBATWorksheet) // note the cast let ws=wb.Worksheets.[1] :?> Worksheet // write in a cell, box is optionnal ws.Cells.Item(1,1) <- box "hello world" // write in a range let m,n = 100,200 let hello_worlds=Array2.init m n (fun i j -> sprintf "hello world (%i, %i)" i j) let r=ws.get_Range(ws.Cells.Item(2,2),ws.Cells.Item(2+m-1,2+n-1)) // use Value2 not Value r.Value2 <- box hello_worlds app.ScreenUpdating <- true

By sharpdev on 12/12/2008 4:58 AM (permalink)

Topic tags

Built with WebSharper

Home

Answers

Events

Courses

Groups and Conferences

Blogs

Jobs

Developers

Topic tags