Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Posted to microsoft.public.excel.programming
external usenet poster
 
Posts: 2
Default Excel 2007 on server

Hi,

I am planning to write a service application (in the MOSS server) to get a
Excel 2007 template from MOSS, make a copy, insert data into cells,
recalculate the whole worksheet, save two copies (Excel 2007 and Excel 2002),
and save them back to MOSS. I use MOSS OM and Excel 12.0 Object Library.

Does the server need to install Office 2007? I know MOSS has its own Excel
Service runtime. I assumes the Office 2007 runtime does the cell insertion,
calculationg and saving. If so, how does the runtime get into server? Is
there anything to watch out when programmatically invoking Excel such as
multi-threading?

What is the licensing issue with respect to running applications with Office
features in a background/server scenario?

Thanks in advance.

...Louis
  #2   Report Post  
Posted to microsoft.public.excel.programming
external usenet poster
 
Posts: 2
Default Excel 2007 on server

After reading more, I believe I can use the System.IO.Packaging API to change
cells values as my template Excel is stored in xlsx. This seems to be the way
to play with Excel files without the Excel 12 runtime which is actually a COM
EXE. Well, do I still need to use Excel 12 COM EXE runtime for recalculation,
change named range, and saving to Excel 2002 format.

Is it fun :-<

...Louis Yeung
Reply
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
Editing sql server data in Excel 2007 joker197cinque Excel Discussion (Misc queries) 0 October 7th 09 04:24 PM
Excel 2007 lock files don't go away on the server Andrew Meinolf Excel Discussion (Misc queries) 0 July 17th 09 05:34 PM
Creating DDE link to DDE server in Excel 2007 Gum Excel Worksheet Functions 0 September 15th 08 06:35 AM
How to connect the Excel 2007 in SQL Server 2005? davidshen Excel Worksheet Functions 0 March 24th 08 02:11 AM
Office Excel 2007 for SQL Server Analysis Services eysiperez Excel Discussion (Misc queries) 1 November 27th 06 04:50 PM


All times are GMT +1. The time now is 01:50 AM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
Copyright ©2004-2025 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"