open spreadsheet from dll
open spreadsheet from dll
open spreadsheet from dll
open spreadsheet from dll
open spreadsheet from dll
open spreadsheet from dll open spreadsheet from dll open spreadsheet from dll open spreadsheet from dll open spreadsheet from dll open spreadsheet from dll open spreadsheet from dll open spreadsheet from dll
open spreadsheet from dll open spreadsheet from dll
open spreadsheet from dll
Go Back  Xtreme Visual Basic Talk > > > open spreadsheet from dll


Reply
 
Thread Tools Display Modes
  #1  
Old 11-15-2012, 09:07 AM
icampbell icampbell is offline
Junior Contributor
 
Join Date: Feb 2003
Location: Northumberland, England
Posts: 253
Default open spreadsheet from dll


Hello all,

i am new to .net having only used vb6.
but what i need to do is create a .dll that i can pass in 6 integer fields into.
the dll then needs to open up a spreadsheet, put the values into specific cells in the spreadsheet, then read another cell (based on some calculations) and pass that back out of the dll.
i need to run this from a sql stored procedure as an extended sp but also the server will not have excel installed to it.

i have seen people using the microsoft.office.interop.excel.dll ?
would this allow me to do excel type references without installing office?
if so, could this be wrapped into the dll so i would not need to install anything other than putting the dll into sqls bin folder.

thanks in advance
Ian.
__________________
Were all going to heaven lads, wey heyy.....
Reply With Quote
  #2  
Old 11-15-2012, 09:10 AM
icampbell icampbell is offline
Junior Contributor
 
Join Date: Feb 2003
Location: Northumberland, England
Posts: 253
Default

sorry, forgot to say i am using visual studio 2010 with sql server 2008.
__________________
Were all going to heaven lads, wey heyy.....
Reply With Quote
  #3  
Old 11-15-2012, 10:40 AM
Gruff's Avatar
Gruffopen spreadsheet from dll Gruff is offline
Bald Mountain Survivor

Retired Moderator
* Expert *
 
Join Date: Aug 2003
Location: Oregon, USA - deceased
Posts: 6,440
Default

Interops are wrappers for ActiveX components. Therefore I would think that microsoft.office.exel.dll would have to be present. That is only there if Excel is installed.

On the other hand you might try this question in the database forum area as there might be some built in automatiion for MS tools if you are using a Microsoft Database Server.

Sorry. I am out of my depth when it comes to high end database questions.
__________________
Burn the land and boil the sea
You can't take the sky from me


~T
Reply With Quote
Reply


Currently Active Users Viewing This Thread: 1 (0 members and 1 guests)
 
Thread Tools
Display Modes

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

BB code is On
Smilies are On
[IMG] code is Off
HTML code is Off

Forum Jump

Advertisement:





Free Publications
The ASP.NET 2.0 Anthology
101 Essential Tips, Tricks & Hacks - Free 156 Page Preview. Learn the most practical features and best approaches for ASP.NET.
subscribe
Programmers Heaven C# School Book -Free 338 Page eBook
The Programmers Heaven C# School book covers the .NET framework and the C# language.
subscribe
Build Your Own ASP.NET 3.5 Web Site Using C# & VB, 3rd Edition - Free 219 Page Preview!
This comprehensive step-by-step guide will help get your database-driven ASP.NET web site up and running in no time..
subscribe
open spreadsheet from dll
open spreadsheet from dll
open spreadsheet from dll open spreadsheet from dll
open spreadsheet from dll
open spreadsheet from dll
open spreadsheet from dll open spreadsheet from dll open spreadsheet from dll open spreadsheet from dll open spreadsheet from dll open spreadsheet from dll open spreadsheet from dll
open spreadsheet from dll
open spreadsheet from dll
 
open spreadsheet from dll
open spreadsheet from dll
 
-->