Excel File

[jessi]

Hello,

I need to open an excel Workboot from an existing excel file, but I get the
following error:

Old format or invalid type library

Here is my code:

Dim oExcel As Excel.Application
oExcel = New Excel.Application
Dim oWorkbook As Excel.Workbook
oWorkbook =
oExcel.Workbooks.Open(Filename:=Request.ServerVariables("APPL_PHYSICAL_PATH")
& "otrapruebamas.xls") 'This line generates the exception
Dim x As String = oWorkbook.Worksheets(1).Range("A1").Value

I need help, thanks!!

 

[Guest]

Hello,

I need to open an excel Workboot from an existing excel file, but I get
the following error:

Old format or invalid type library

Here is my code:

Dim oExcel As Excel.Application
oExcel = New Excel.Application
Dim oWorkbook As Excel.Workbook
oWorkbook =
oExcel.Workbooks.Open(Filename:=Request.ServerVariables("APPL_PHYSICAL_PATH")
& "otrapruebamas.xls") 'This line generates the exception
Dim x As String = oWorkbook.Worksheets(1).Range("A1").Value

BUG: "Old format or invalid type library" error when automating Excel
http://support.microsoft.com/kb/320369

 

[Mark Rae]

Hello,

Dim oExcel As Excel.Application

Excel, as with the rest of Office, is not designed for server-side
automation. Microsoft strongly disadvises this, and won't actually support
any application which uses it:
http://support.microsoft.com/default.aspx?scid=kb;EN-US;q257757#kb2

Use this instead: http://www.aspose.com/Products/Aspose.Cells/Default.aspx

 

[jessi]

Solution:

System.Threading.Thread.CurrentThread.CurrentCulture =
System.Globalization.CultureInfo.CreateSpecificCulture("en-Us")

Dim oExcel As Excel.Application

oExcel = New Excel.Application

Dim oWorkbook As Excel.Workbook

oWorkbook =
oExcel.Workbooks.Open(Filename:=Request.ServerVariables("APPL_PHYSICAL_PATH")
& "otrapruebamas.xls")

 

[Mark Rae]

Solution:

System.Threading.Thread.CurrentThread.CurrentCulture =
System.Globalization.CultureInfo.CreateSpecificCulture("en-Us")

Dim oExcel As Excel.Application

oExcel = New Excel.Application

Dim oWorkbook As Excel.Workbook

oWorkbook =
oExcel.Workbooks.Open(Filename:=Request.ServerVariables("APPL_PHYSICAL_PATH")
& "otrapruebamas.xls")

You'll be *very* fortunate indeed if this works in a live production
environment...

It almost certainly won't...

 

[jessi]

Why?

You'll be *very* fortunate indeed if this works in a live production
environment...

It almost certainly won't...

 

[Mark Rae]

Why?

For precisely the reasons outlined by Microsoft in the link that I gave you
in my first reply...

Is there any particular reason why you didn't read it...???

 

[sloan]

Jessi.

Mark is trying to help you, by giving you a article about ~why not to do
this.

Instead of asking "why", try reading the article.... and then if you need to
ask specific questions about the the article, then do so.

But put a little legwork in...esp when someone is trying to ~help you avoid
a pitfall.