connecting excel file to C++ program

Visual Studio Tools for Office

Windows Tech ‹ Office
- Archive
  - VS 2008
  - Smart Device
  - Visual C#
  - Game
  - ISV
  - VB
  - Visual Studio
  - Windows Live
  - Office
  - Architecture
  - VS Express
  - Windows Forms
  - IE
  - VFP
  - SharePoint
  - Dotnet
  - SQL Server
  - Windows Vista
  - VC++

- Previous
  - 1
    - Convert word doc to pdf hello everybody I myself find out answer for this Add reference to MS.Word private Microsoft.Office.Interop.Word.ApplicationClass MSdoc; //Use for the parameter whose type are not known or say Missing object Unknown = Type.Missing; private void word2PDF(object Source, object Target) { //Creating the instance of Word Application if (MSdoc == null)MSdoc = new Microsoft.Office.Interop.Word.ApplicationClass(); try { MSdoc.Visible = false; MSdoc.Documents.Open(ref Source, ref Unknown, ref Unknown, ref Unknown, ref Unknown, ref Unknown, ref Unknown, ref Unknown, ref Unknown, ref Unknown, ref Unknown, ref Unknown, ref Unknown, ref Unknown, ref Unknown, ref Unknown); MSdoc.Application.Visible = false; MSdoc.WindowState = Microsoft.Office.Interop.Word.WdWindowState.wdWindowStateMinimize; object format = Microsoft.Office.Interop.Word.WdSaveFormat.wdFormatPDF; MSdoc.ActiveDocument.SaveAs(ref Target, ref format, ref Unknown, ref Unknown, ref Unknown, ref Unknown, ref Unknown, ref Unknown, ref Unknown, ref Unknown, ref Unknown, ref Unknown, ref Unknown, ref Unknown, ref Unknown, ref Unknown); } catch (Exception e) { MessageBox.Show(e.Message); } finally { if (MSdoc != null) { MSdoc.Documents.Close(ref Unknown, ref Unknown, ref Unknown); //WordDoc.Application.Quit(ref Unknown, ref Unknown, ref Unknown); } // for closing the application WordDoc.Quit(ref Unknown, ref Unknown, ref Unknown); } } Prerequisite: MS word2007 with ( Primary Interoperability assembly will be installed by default). plugin SaveAsPDFandXPS (free from MS Site) Karthik Tag: Visual Studio Tools for Office connecting excel file to C++ program Office
  - 2
    - AppCheck and Office 2007 Thank you for this information. Tag: Visual Studio Tools for Office connecting excel file to C++ program Office
  - 3
    - EntryID on Exchange... Other possibility? Hi, I need to send some email that I receive with a tracking number in the subject to a SQL database. But for now the webservice are only avalaible from the internal network. My client use RPC ovet HTTP and this mode let you receive email without any needs to be connected with a VPN or some other tunel link. If a Tracked email are received in outlook when the user are outside the internal network, I will not be able to send it to the SQL. I try to save in the Outlook user property the entry ID of the received email to send it later but if the user move the email in another folder the entryID change. I explore 2 possibility, can someone help me to choose the right direction. I know that I eventually have to program a plugin in exchange serveur to avoid this, but for now I can't, I must found a way to acheive this in en VSTO plugin for outlook 1- Save a flag in the email user property, and save a flag in the outlook user property. When Outlook start, he will check if the flag is set to true and if so, he will scan ALL email folder and subfolder to found item with flagged user property. 2- Save a copy of this email in a temp folder to be processed later. This solution are not very good, because I need to save the ID of the database in the original email. I will have to search in the folder to find the original email Tag: Visual Studio Tools for Office connecting excel file to C++ program Office
  - 4
    - Load multiple image in VSTO 2005 SE addin Hi Dennis, Thanks for the reply. Yeah, your article give me an idea to tackle the problem. Before that I've managed to find a solution by using if..else condition. See a partial codes from my addin below. For the picture converter class, I use exactly the same code like yours. Public Function GetImage( _ ByVal imageName As String ) As stdole.IPictureDisp If imageName = "edited32_bm_all.png" Then Return PictureConverter.ImageToPictureDisp( My .Resources.edited32_bm_all) ElseIf imageName = "edited32_eng_all.png" Then Return PictureConverter.ImageToPictureDisp( My .Resources.edited32_eng_all) ElseIf imageName = "edited32_tesaurus.png" Then Return PictureConverter.ImageToPictureDisp( My .Resources.edited32_tesaurus) ElseIf imageName = "edited16_bm_text.png" Then Return PictureConverter.ImageToPictureDisp( My .Resources.edited16_bm_text) ElseIf imageName = "edited16_eng_text.png" Then Return PictureConverter.ImageToPictureDisp( My .Resources.edited16_eng_text) ElseIf imageName = "edited16_cpanel.png" Then Return PictureConverter.ImageToPictureDisp( My .Resources.edited16_cpanel) End If Return PictureConverter.ImageToPictureDisp( My .Resources.edited16_cpanel) End Function My question: Is this a correct/good method to call the image Will it cause a problem to my addin BTW, should I change the last return line to other image FYI, til now my addin working correctly(still no problem or strange thing happens). In your article, you use a case scenario, so I think my addin will produce the same result if I use your code, right Regards, Westman Tag: Visual Studio Tools for Office connecting excel file to C++ program Office
  - 5
    - Trust an assembly under Windows Vista Not sure what I did, but know we got it to work Tag: Visual Studio Tools for Office connecting excel file to C++ program Office
  - 6
    - Upgrade from Office 2003 Standard to 2003 Professional Hello, Could someone please give me the link where people could upgrade from Office 2003 Standard Edition to Office 2003 Professional Edition I've tried to find that link myself on the Microsoft website, but they seem to have replaced all links with Office 2007 links. My users are yet not ready to upgrade to 2007 but still would like to use my VSTO customizations, so I'd like to suggest them upgrading to 2003 Professional. Thanks, Oleg. Tag: Visual Studio Tools for Office connecting excel file to C++ program Office
  - 7
    - Problem with ThisAddIn_Shutdown and CommandBar in Outlook 2007 Hi Helmut, Here is a snippet Code Snippet using System; using System.Windows.Forms; using Microsoft.VisualStudio.Tools.Applications.Runtime; using Outlook = Microsoft.Office.Interop.Outlook; using Office = Microsoft.Office.Core; namespace fooAddIn { public partial class ThisAddIn { Office. CommandBar fooAddInToolBar; Office. CommandBarButton btn1; Office. CommandBarButton btn2; Outlook. Explorers selectExplorers; private void ThisAddIn_Shutdown( object sender, System. EventArgs e) { try { Properties.Settings.Default[ "fooAddInToolBarTop" ] = fooAddInToolBar.Top; Properties.Settings.Default[ "fooAddInToolBarLeft" ] = fooAddInToolBar.Left; Properties.Settings.Default[ "fooAddInToolBarVisible" ] = fooAddInToolBar.Visible; Properties.Settings.Default[ "fooAddInToolBarPosition" ] = ( int )fooAddInToolBar.Position; Properties.Settings.Default[ "fooAddInToolBarRowIndex" ] = fooAddInToolBar.RowIndex; Properties.Settings.Default.fooAddInIsLoaded = false ; Properties.Settings.Default.Save(); } catch ( Exception ex) { MessageBox .Show(ex.Message); } } } } Tag: Visual Studio Tools for Office connecting excel file to C++ program Office
  - 8
    - Form opening up a word.dot VSTO It opens one .dot file and displays "Hello from #1" and stops. Now, I tried what you suggested by adding the full path and it works. I am very happy that it works but the logic doesn't add up for me. Word should open 3 .dot files each time the .dot file in D:\My Documents\Visual Studio 2005\Projects\VSTO-POC01\bin\Debug\VSTO-POC01.dot is open. Accordint to the code, it should go from 2 to 3, which is two times. And each time it should give me 3 .dot files. However, it provides me with only 3 .dot files. This is the result that I want but my logic tells me there should be six. Why is my logic incorrect so my new code looks like this ... For i = 2 To 3 Call MsgBox( "Hello from #" & i.ToString) ldocWord = Me .Application.Documents.Add( "D:\My Documents\Visual Studio 2005\Projects\VSTO-POC01\bin\Debug\VSTO-POC01.dot" ) Next i ... Tag: Visual Studio Tools for Office connecting excel file to C++ program Office
  - 9
    - Save a word document I am opening a word document as follows Case "doc" objWord = CreateObject( "Word.Application" ) objDoc = objWord.Documents.Open(OFD1.FileName ) objDoc.Select() rtbText.Text = objWord.Selection.Text objDoc.Close() objWord.Quit() My question is, how after the document has been changed, can I save it as a word document keeping all its formating Tag: Visual Studio Tools for Office connecting excel file to C++ program Office
  - 10
    - Form Region display issue Thanks Ji! Two things: 1. Does the form region look the same when you edit it In my case, all objects change font size and get all out of wack, position changes, etc. 2. Do you know if I send the form region and the manifest file to another user if I would be able to see information they enter on custom properties/fields using the same form region on my PC Thanks, Rafael Tag: Visual Studio Tools for Office connecting excel file to C++ program Office
  - 11
    - OutlookSpy and Control ID's Morning all, I want to use Outlookspy to produce a complete list of control id'd for Outlook 2003 and Outlook 2007. I have not got a clue how to do this, could any of you good natured techies please tell me how to go about doing this. Please send me intructions by email as well as posting to pat.kitchener@conwy.gov.uk Many thanks in anticipation opf your help Pat Tag: Visual Studio Tools for Office connecting excel file to C++ program Office
  - 12
    - Visual Studio Tools for Office VSTO Word Is anyone out there have come across adding more than one word document to a visual studio solution. It is possible to add a new item or an existing item and add a word document. However Visual Studio does not create the code behind the document like ThisDocument.cs and the designer.xml and designer.cs files. Any idea Tag: Visual Studio Tools for Office connecting excel file to C++ program Office
  - 13
    - Registry entries for all users (Outlook add-in) Good day! Is it possible to disable the 'Remove' button from the Add-Ins dialog box for a specific add-in Probably an additional registry entry So that the user would have to explicitly re-run the installer to remove the add-in from the machine. Thanks. Tag: Visual Studio Tools for Office connecting excel file to C++ program Office
  - 14
    - Method to refresh/update Word toolbar state I did try that but it didn't work! Tag: Visual Studio Tools for Office connecting excel file to C++ program Office
  - 15
    - How to Add custom information in an appointment item using VSTO SE Outlook 2003 Addin ? Hi, I am creating a VSTO SE Addin for Outlook 2003 and i want to store some custom information in the form of Key-Value pair in every appointment item i have. Can anybody tell me is this possible to achieve this Thanks in advance. Tag: Visual Studio Tools for Office connecting excel file to C++ program Office
  - 16
    - Copying RTF into word and from word to a richtext box using c# Does anyone know of a way to transform RTF to WordML and transform WordML to RTF Is there a streamlined way to accomplish this Tag: Visual Studio Tools for Office connecting excel file to C++ program Office
- Next
  - 1
    - Which "Event Handler-adding" code is more appropriate for my application add-in? Hi Cindy, thanks for catching my oversight - somehow that use of uiConvert didn't make my first cut-and-paste attempt. [I've added it back, and tabbed the code appropriately to make it slightly more readable.] It was a little too obvious, though, that I hadn't used the variable in my actual code - I just double-checked that it was still in the compiled project, and yet I'm still not seeing the Click event causing my click-enclosed code to fire. I'll try the AddHandler approach - perhaps that'll work better than what I've got right now. Thanks again! Tag: Visual Studio Tools for Office connecting excel file to C++ program Office
  - 2
    - COM Exception Error Hello Cindy, thank you for your reply, The end user has Microsoft Office 2003 Professional edition. At start up of the VSTO add-in, I am populating XML nodes that are part of a document template with data from a Sql Server 2005 database. The Word template file is a Word template that has an XML schema attached to it and uses my dll code behind file to populate the Word template. I would also like to comment that on the end user's machine, the Microsoft.Office.Interop.Word.dll did not exist in the GAC so I had to add it to the root directory of the application. Would this have anything to do with it Steve Tag: Visual Studio Tools for Office connecting excel file to C++ program Office
  - 3
    - VSTO SE 2005 Runtime Setup for Windows VIsta HI, I want to install VSTO SE 2005 Runtime Setup for Windows VIsta. But on its download page, Windows vista is not listed in the supported OS. Is there a seperate runtime for Windows Vista Regards Kulvinder Singh Tag: Visual Studio Tools for Office connecting excel file to C++ program Office
  - 4
    - Publish deployment issue I'm getting an error message intermittantly when publishing my application Could not load file or assembly ..., Version=1.1.2692.18376, Culture=neutral, PublicKeyToken=...' or one of its dependencies. The located assembly's manifest definition does not match the assembly reference. (Exception from HRESULT: 0x80131040) Fusion Log Data: Successful load- LOG: Assembly Name is: , Version=1.1.2692.18376, Culture=neutral, PublicKeyToken=205848d03db232df LOG: Binding succeeds. Returns assembly from C:\Documents and Settings\Admin\Local Settings\Application Data\assembly\dl3\3MDEK0QZ.57D\D1GG5QL9.GKL\67c4e139\00df0250_c797c701\.dll. LOG: Assembly is loaded in default load context. Unsuccessful load attempt: LOG: Assembly Name is: , Version=1.1.2690.28864, Culture=neutral, PublicKeyToken=205848d03db232df WRN: Comparing the assembly name resulted in the mismatch: Revision Number ERR: The assembly reference did not match the assembly definition found. ERR: Setup failed with hr = 0x80131040. ERR: Failed to complete setup of assembly (hr = 0x80131040). Probing terminated. I havn't been able to isolate under what conditions it happens and what conditions it doesn't, but I am attempting to do so. My thoughts are that it may be to do with potentially having recompiled the referenced project separately, yet when the publish function is run, it recompiles the project to be published but doesn't include the latest assembly for the referenced project. Not certain tho. Would greatly appreciate any input/insight into how to resolve the issue. Tag: Visual Studio Tools for Office connecting excel file to C++ program Office
  - 5
    - Cache data in workbook created from addin Adding to the comments given by Cindy, she is basically right, there are however some working methods that allow you to make things work. What you could do is create a Template with VSTO containing several cache entries to your own liking and have another addin create documents based on this template. After creating the document containing the cache entries you can access these cache objects through the ServerObject interface. When the document is then opened the data is available to work with. I'm not sure this fits in your scenario and hope I gave you some hints here to get you going ... -= Maarten =- Tag: Visual Studio Tools for Office connecting excel file to C++ program Office
  - 6
    - A question about office clipboard Hi, The Office clipboard is not a paste destination. It is simply a clipboard viewer. Any time an object is placed on the windows clipboard, the Office clipboard viewer receives a WM_CLIPBOARDUPDATE notification and responds by copying the data to its own private clipboard implementation. There isn't any really good way to know whether the clipboard is being accessed by the Office clipboard viewer or in response to a paste. Any possible solution would be little more than a guess and even if it worked, it would be at risk to be broken in a future version of Office since you would be relying on behavior we don't document. Sincerely, Geoff Darst Microsoft VSTO Team Tag: Visual Studio Tools for Office connecting excel file to C++ program Office
  - 7
    - how to implement "in-Ribbon" Gallery ? I have almost read http://blogs.msdn.com/jensenh/default.aspx messages all. But I don't know how to implement "in-Ribbon" Gallery (that's like home styles in word 2007 ) At "2007 Microsoft Office System UI Design Guidelines - Evaluation.doc",they said there were two styles about Gallery ,that's " dropdown " and " in- Ribbon ".Could you tell me how to set " in- Ribbon " Gallery with xml thank you Tag: Visual Studio Tools for Office connecting excel file to C++ program Office
  - 8
    - Excel Edit Delete Disabled Thank you for your feedback. You should not be seeing this behavior with solutions with ListObject in VSTO SE 2005 runtime . We have made some fixes in this region. When ListObject is activated it disables the Edit->Delete option, because deleting columns in databound ListObjects is not allow. However, it re-enables the option once ListObject is not in active focus. You should be able to delete non-ListObject cells, rows, and columns in any case. Let me know if this helps! Thanks, Nikhil Tag: Visual Studio Tools for Office connecting excel file to C++ program Office
  - 9
    - Publishing VSTO 2005 SE addin to a network location Rakesh, I've achieved what you describe but it was tricky First thing I recall is that if you publish to a network location there is an issue that if the network is unavailable when you load your application/addin, your addion is disabled. This is incredibly frustrating. What this means is that the files are not actually copied to your local machine and are run directly off the network which is not ideal for isntances where you want to work offline. Here is what I did. 1. I created a setup project as normal. (This is how you take care of registry, security policy and inital setup of manifest and files) 2. I then created my own updater class that I call from the addin_startup which checks the local manifest file against the manifest file in the publish location (compare the versions). 3. If the version is newer, I use xDirectory ( http://www.codeproject.com/cs/files/xdirectorycopy.asp ) to copy the contents of the publish directory (based upon the version of course) into the local machine directory. 4. I wrote a small application that is launched by my addin which passes details such as the process id and file that is open 5. This app then stops the running process and restarts it with the file that was open Tag: Visual Studio Tools for Office connecting excel file to C++ program Office
  - 10
    - WordApp.Selection.Range.set_Style throws exception Well, I modified the code and tried these ways: Code Block styleHeading2 = "Heading 2"; styleHeading3 = "Heading 3"; First way: Code Block WordApp.Selection.TypeText("Test text."); WordApp.Selection.Range.set_Style(ref styleHeading2); //still throws an exception Second way: Code Block WordApp.Selection.TypeText("Test text."); object o1 = doc.Sentences[1].Start; object o2 = doc.Sentences[1].End; Range range = doc.Range(ref o1, ref o2); range.set_Style(ref styleHeading3); Both threw an exception of not founding the element.What else could I do Tag: Visual Studio Tools for Office connecting excel file to C++ program Office
  - 11
    - Excel Solver macro from VB.NET I've found the reason for the error, thanx to http://www.officehelp.in/ It seems the Solver.XLA needs to be explicitly opened before it can be used. This is done automatically when we open the excel manually, but when we use objects, we have to open it using the following command oExcel.Run("Solver.xla!Auto_Open") Once this was done my application started working as expected... The other error was also cleared... Regards, Dinesh Tag: Visual Studio Tools for Office connecting excel file to C++ program Office
  - 12
    - VSTO Addin crashing outlook on select machines I used to run my vsto excel sheet without Excel PIAs installed, but now it crashes Excel without them (DUH!!!- MS please prevent excel from crashing). Is there something in the VSTO application that requires PIAs I added ActionsPane utilization recently, could that have added the PIA requirement Tag: Visual Studio Tools for Office connecting excel file to C++ program Office
  - 13
    - Interact with MS Access using VB Ok. Thanks for your help. Tag: Visual Studio Tools for Office connecting excel file to C++ program Office
  - 14
    - execute a vsto project on a remote machine A couple of quick notes for anyone else reading this post that reflect a bit of what MathMax and I worked through off-line. The most important thing to recognize is that deployment has changed for the better in VSTO 3 / Office 12. Customizations are now written to the Click-Once cache, so there is no longer any need to muck around with CAS settings. Deploying a VSTO customization is now a simple process: 1) Use the deployment wizard to generate the necessary deployment files and push them to the install location. 2) Ensure that the prerequisites exist on the target machine; .Net FX 3.5, VSTO 3.0 Runtime, and Office applications and PIAS. 3) Run the generated setup.exe (or double-click on the deployment manifest) on the target machine--this will install the customization to the local Click-Once cache. 4) Copy the document to the desired location and open (your customization should run). If you wish to run the document from a network share, the share must be added to trusted locations in the Office Trust Center. Complete documentation for VSTO 3.0 (Beta 2) deployment can be found here: http://msdn2.microsoft.com/en-us/library/bb386179(VS.90).aspx Note that Office 11 projects are still stuck with the VSTO 2.0 deployment model. Tag: Visual Studio Tools for Office connecting excel file to C++ program Office
  - 15
    - Highlighting the active field in the task pane this a document-level customization... I am using Excel 2003 Lets say the user clicks on the Text Field "F1" and there are total 5 user control text fields to the task pane. So we want is when the user selects the user control "F1" only this control should be enabled and all the other fields should be disabled. Thanks, Sandeep Tag: Visual Studio Tools for Office connecting excel file to C++ program Office
  - 16
    - What about Macs? Hi, Is there any way to port my Office VSTO customization to Apple Mac platform I'm completely ignorant about macs, and now I am asked about it, and I need help. So, is there the equivalent MS Office 2003 for Mac which supports customizations and also whether there is .NET framework for Mac that can run VSTO assemblies Thanks Tag: Visual Studio Tools for Office connecting excel file to C++ program Office

nicelily

Hi every body

I am a new programmer and I have been studying C++ for one semester. I know how to link and use files with these extinsions (.dat , . txt). However, I need to know how to connect excel spreadsheet with my C++ program "win 32 console application" and then I need to read my input from this spreadsheet and produce my output on it. I searched a lot but I did not find any thing. Actually, I do not know what is the solution for my problem, is it a code or a tool or something else If there is any one who can help me, I will be thankful. Moreover, If there is a refrence or a book that helps me ,please tell me and I will be glad to study it.

I use MS Office 2003, Visual Studio 2005.

Sorry if my question seems silly, but I really want to learn it and it is urgent.

Thank you a lot .

Re: Visual Studio Tools for Office connecting excel file to C++ program

Steve Hansen

Hi,

This isn't really the correct forum for your question. This forum deals with a product that allows you to automate Office using managed code (either C# or VB.NET).

Here is an article however that you might find useful to get started:

http://support.microsoft.com/kb/216686/

Also, check out:

http://support.microsoft.com/kb/196776/

Best of luck with your studies!

Sincerely,

Steve Hansen

Re: Visual Studio Tools for Office connecting excel file to C++ program

Cindy Meister

Hi nicelily

In addition to Steve's recommendations, if you need help generally with C++ the place to ask questions is the Windows Developer newsgroups. Start here

http://msdn.microsoft.com/newsgroups/default.aspx dg=microsoft.public.win32.programmer.ole&lang=en&cr=US

To see other newsgroups, click "Windows Development" at the left, then choose Windows SDK. You'll find a number of win32 newsgroups, listed by topic.