WCF/WF - how to use web sevices in c# ( VSTO)
Asked By kris kumar
06-May-09 02:15 PM
Hello All,
I am working on a Excel Add-in (c#) that will be talking to a web server via webserice. I am new to web services and could someone point me some sample code or article? Thanks for the help.
some reference links
http://www.codeattest.com/blogs/martin/2005/04/demo-vsto-excel-solution.html
http://geeks.netindonesia.net/blogs/andriyadi/archive/2008/04/16/save-excel-workbook-to-server-using-vsto-v3.aspx?CommentPosted=true
http://www.packtpub.com/article/microsoft-office-outlook-programming-vsto-c-sharp-part1
http://www.packtpub.com/article/microsoft-office-outlook-programming-vsto-c-sharp-part2
Ravenet Rasaiyah replied to kris kumar
Export Excel workbook as a pdf in .NET This FAQ provides code to save Excel workbook as a pdf programmatically. This code is useful for any VSTO or Excel automation implementation. Here is the source code in C# public void ExportWorkbook(Excel. Application app, string pathToExport Excel.Workbook lActiveBook = app.ActiveWorkbook; lActiveBook.ExportAsFixedFormat(Excel.XlFixedFormatType.xlTypePDF, pathToExport, Excel.XlFixedFormatQuality.xlQualityStandard, Type . Missing
Referring to Excel objects in VSTO Excel Hi, I am using Visual Studio 2008 Professional Edition and Microsoft Office 2003 and working with an Excel 2003 Workbook template. The language I am using is Visual Basic. When I am in one of Excel's objects (like a worksheet), I can refer to objects like in Me.Application.Workbooks of great help if someone could give me an example of how refer to a workbook, like in: Dim wbk As Excel.Workbook wbk = CType(x, Excel.Workbook) Thanks in advance, - - Carlos Mallen Excel Programming Discussions Visual
Which one is most powerful for developing a Excel Application Excel 1. XLL SDK; 2. Shared Add-in (COM add-in) 3. Excel Add-in (C# VSTO) 4. Excel Workbook (C#) 5. Excel Template 6. VBA and advatages and disadvatages? I personal think C# is depend on .NET for me , but I also want to know it's advatages compare with other type Excel application. Excel Programming Discussions Excel (1) VSTO (1) VBA (1) LeighSword (1) Disadvatages (1) Advatages
VSTO 2005 With Excel 2003 And 2007 Installed .NET Framework Hi Friends and Gurus, I have both Excel 2003 and 2007 installed. I want to develop a solution only for Excel 2003 workbook in VSTO. When I do File / New Project / Office and select Excel Workbook (For a code behind solution) and select Create a New Workbook, VSTO shows me an
Accessing VSTO Workbook Methods Excel I'm using VSTO with VB in VS 2008 and Excel 2007, and trying to understand something basic. I've written some public methods in ThisWorkbook.vb, which is the class created by VSTO with "Public Class ThisWorkbook". Suppose one method I've writtine in the workbook is Public TestMethod. If I am writing code in a worksheet, e.g. Sheet1.vb reference. Do I create an new instance of ThisWorkbook in Sheet1, or will this confuse VSTO / Excel? - - Ed Excel Programming Discussions Globals.ThisWorkbook.TestMethod (1) Globals.Sheet4.TestMethod (1) Excel 2007