How can you create formated excel files through a program. By formatting, i mean individual cell background colors, row widths, column heights.. and stuff.
Thanks in advance.
Creating a formatted Microsoft excel file.
Visual Studio Tools for Office
-
- Previous
- 1
- Office 2007 Quick Parts Hi Ivo Can you be a bit more specific about what you have in mind Describe your scenario, perhaps We are talking about Word 2007, right Tag: Visual Studio Tools for Office Creating a formatted Microsoft excel file. Office
- 2
- How to Import a .msg and .pst file into Outlook 2007 with C# code? Sue, Thanks for the help! I managed to get both to work, however I can't find a way to import (or move) the imported .PST file to the main "Mailbox - ..." store. When I use the following code: Outlook. _NameSpace olNs = outlookApplication.GetNamespace( "MAPI" ); Outlook. _NameSpace mySession = (Outlook. _NameSpace )outlookApplication.Session; mySession.AddStore(@"C:\\Temp\\MyPst.pst"); it imports the pst as a new root level folder/store in outlook. Do you know what I need to do to store the pst into the Mailbox folder with all of the other default folders I have tried mySession.DefaultStore.Session.AddStore(@"C:\\Temp\\MyPst.pst"), but it appears to be the same thing above. I have tried to use the MAPIFolder.MoveTo function, but it would not move the folder. Any ideas Thanks again. Tag: Visual Studio Tools for Office Creating a formatted Microsoft excel file. Office
- 3
- Error - InfoPath cannot open the selected form This forum is specific to the VSTO technology. It has nothing to do with VSTA or programming in InfoPath. Please address your questions to the InfoPath newsgroup http://msdn.microsoft.com/newsgroups/default.aspx dg=microsoft.public.infopath &lang=en&cr=US Tag: Visual Studio Tools for Office Creating a formatted Microsoft excel file. Office
- 4
- Multiple windows Thanks Helmut, Your suggestion helped me realize a way I could achieve what I wanted. Denis Tag: Visual Studio Tools for Office Creating a formatted Microsoft excel file. Office
- 5
- NamedRanges in Excel 2007 with VSTO SE Hi Sole, Let see if the following can get You started in the right direction: Code Snippet Friend Sub Create_Name_Range() Dim xlsheet As Excel.Worksheet = Globals.ThisAddIn.Application.ActiveSheet Dim rnArea As Excel.Range = xlsheet.Range( "A1:A3" ) Dim Name As Excel.Name = Globals.ThisAddIn.Application.ActiveWorkbook.Names.Add( "XLDennis" , rnArea) MessageBox.Show(Name.RefersTo.ToString) End Sub Friend Sub Use_Name_Range() Dim xlRange As Excel.Range = Globals.ThisAddIn.Application.ActiveSheet.Range( "XLDennis" ) MessageBox.Show(xlRange.Address.ToString) End Sub Tag: Visual Studio Tools for Office Creating a formatted Microsoft excel file. Office
- 6
- MAPI.SessionClass in Outlook 2007 Hi, Previously, I work with Outlook 2003 and install CDO in my machine. This code snippet was work in Outlook 2003. MAPI.SessionClass session = new MAPI.SessionClass(); session.Logon("", "", false, false, Type.Missing, Type.Missing, Type.Missing); session.Logoff(); Recently, I upgrade to Outlook 2007 and found out that MAPI was not in Outlook 2007 anymore, may I know how to replace the code snippet above using Outllok 2007 API. Regards Kendy Tag: Visual Studio Tools for Office Creating a formatted Microsoft excel file. Office
- 7
- Outlook Appointments Hi Sue Thanks for your reply. the appointment will be on another users calendar for which I have write permission. Thanks Jay Tag: Visual Studio Tools for Office Creating a formatted Microsoft excel file. Office
- 8
- Add TaskPanes in Office 2003 Hi, I spend last day trying to find a solution to add customs taskpanes in office 2003, Is this possible I'm using vsto 2005. I founded that office 2007 has the CustomTaskPane property....but for office 2003 didn't find nothing. Bye, Pedro Rocha Tag: Visual Studio Tools for Office Creating a formatted Microsoft excel file. Office
- 9
- Support for multiple columns in Form Region controls Only in Orcas can you add a .NET control to a form region. And if you do, it's .NET controls only, none off the Outlook-aware olk* controls. Tag: Visual Studio Tools for Office Creating a formatted Microsoft excel file. Office
- 10
- WindowActivate not being called Ji, I have the box you talked about unchecked already. Let me just ask you one more question. Since that box is unchecked, when I click a link within IE to open a Word document, the Word document opens in an instance of Microsoft Word. However, this still does not call my "WindowActivate" event in my VB code. Is this normal behavior/the "known issue" still or am I doing something wrong My code puts up a custom window during the WindowActivate event and since opening a document through IE is not calling WindowActivate, it does not put up the custom menu. If there is another event that I could use that you know of, please let me know. Thanks for your help. Jennifer Tag: Visual Studio Tools for Office Creating a formatted Microsoft excel file. Office
- 11
- building outlook toolbar in contacts is there a way to do it using explorer as that is how ive set it up atm Tag: Visual Studio Tools for Office Creating a formatted Microsoft excel file. Office
- 12
- Before an Appointment item is saved, how can I get the occurrences specified by the recurrence pattern? The RecurrencePattern.Exceptions collection is empty. This code is acting within a custom form - in this case on a brand new AppointmentItem object. The idea is that before the item is saved, the user would be able verify the availability of some resources (i.e. video conference equipment) by using the controls on the the extra tab we are putting on the custom form. At the point this code is called, the user has just set the recurrence pattern and then maybe selected a resource - I am trying to use the recurrence pattern to identify the date/times of the appointment. An exception with the message "You changed one of the recurrences of this item, and this instance no longer exists. Close any open items and try again." is being thrown for each date I pass to the GetOccurrence method, as I loop from the PatternStartDate to the PatternEndDate of the RecurrencePattern object. Any ideas Tag: Visual Studio Tools for Office Creating a formatted Microsoft excel file. Office
- 13
- Outlook 2007 RTM FormRegion & InfoPath control Thanks for your reply (sorry I didn't see it sooner). The basic form region is made up of the standard to, cc, subject, and message fields and then an InfoPath control at the bottom. The form region is a "replacement" form as opposed to a partial region that exists in another form. Using the simplest repro method, have the add-in cause the InfoPath control to create a new form using a template (we open a File Open dialog to get the template but you can hard-code it for your tests). Once the form region (as its own form since it is a replacement form region) is open, you can tab to all of the controls except the InfoPath control. You can click (with a mouse) into a field in the InfoPath control, but if you press tab, you will leave the control and go to the next Outlook field. I believe you should be able to tab into the InfoPath control and then remain there until you click out of it (in other words, the InfoPath control should process all keys while it has focus). Let me know if you need more information. Pete Loveall Tag: Visual Studio Tools for Office Creating a formatted Microsoft excel file. Office
- 14
- Conditionally create multiple MS Word documents based on a single, master MS Word doc? There are indeed various approaches that can be used to generate documents from multiple, other documents, or parts of other documents. This, however, is not the correct venue to discuss it, as it's not related to the VSTO technology. You'll find a large number of Word-related newsgroups where you should be able to get a useful discussion, I recommend word.docmanagement (for discussion about Word's capabilities) with a cross-post to word.vba.general (for the parts about the object model). In all cases, no matter where you post, don't forget to mention the version of Word you're targeting. FWIW, the most basic approach is to mark each "section" with a bookmark. You can then use InsertFile method and pick up the bookmark to bring across just the contents of the bookmark. (Or you can go the other way around and delete the bookmarks out of a document). Mail merge can do something like this, as well, if you use an IncludeText field to choose which bookmarks you want to pick up based on information in the database. Lots of possibilities... Tag: Visual Studio Tools for Office Creating a formatted Microsoft excel file. Office
- 15
- VSTO 2005 and VS 2005 Pro - how to get all features of both Sorry if the answer is already out there and obvious but I can't find it and need to make a purchasing decision: I'm using VS 2005 Team Suite Trial Edition. I don't need all that this version has to offer. Basically I want VS 2005 Pro with full VSTO capabilities. I understand that VSTO SE will help but doesn't offer full capabilities. I also need the capabilities in VS 2005 Pro that aren't in the VSTO version. From a purchasing standpoint the most cost effective way to go seems to be to buy VS Pro with MSDN Pro subscription to get both. Does this make sense Thanks in advance for your information. Tag: Visual Studio Tools for Office Creating a formatted Microsoft excel file. Office
- 16
- outlook toolbar in sent messages Thanks helmut that first site looks ace. nice one! michal Tag: Visual Studio Tools for Office Creating a formatted Microsoft excel file. Office
- 1
- Next
- 1
- Printing Range of Pages prints in a 20 page document, prints it 20 times It is a 20 page document. object pageRange = "1,3,5,7,9,11,13,15,17,19" object PrintRangeOfPages = Microsoft.Office.Interop.Word. WdPrintOutRange .wdPrintRangeOfPages; object PrintDocumentContent = Microsoft.Office.Interop.Word. WdPrintOutItem .wdPrintDocumentContent; object PrintAllPages = Microsoft.Office.Interop.Word. WdPrintOutPages .wdPrintAllPages; Document .PrintOut(ref BooleanTrue, ref MissingValue, ref PrintRangeOfPages, ref MissingValue, ref MissingValue, ref MissingValue, ref PrintDocumentContent, ref pageRange, ref PrintAllPages, ref BooleanFalse, ref MissingValue, ref MissingValue, ref BooleanFalse, ref MissingValue, ref MissingValue, ref MissingValue, ref MissingValue); Please advise if I am doing something wrong. shrini Tag: Visual Studio Tools for Office Creating a formatted Microsoft excel file. Office
- 2
- Disable VSTO toolbar when cell is being edited I've used Change event for something before, and it fires after the user has finished editing (by hitting Enter or Tab). What the problem here is that people click on the toolbar buttons without finishing the edit. Some of these buttons trigger code that reads the current cell and when the cell is not committed (editing completed properly), this throws memory read exceptions or behave unpredictably. So I just want to prevent them from clicking on the buttons without exiting the currently editing cell. Tag: Visual Studio Tools for Office Creating a formatted Microsoft excel file. Office
- 3
- Deploying Visual Studio 2005 Tools for Office Second Edition Solutions Using Windows Installer (Part 1 of 2) Douglas, Thanks for this helpful reply. I will go ahead and install the Windows Server 2003 Platform SDK. I have to admit that I never would have guessed that that's the package being referred to in the article. I appreciate your help. Tag: Visual Studio Tools for Office Creating a formatted Microsoft excel file. Office
- 4
- How to store meta-data in Outlook 2007 I am developing an Outlook plug in where I have to store meta-data in Outlook for the customizations user does. How to store meta-data in Outlook without persisting to the user (and) without storing in different file(like xml file) I did research on table object. But, I think it doesn't help me out because it is read only object. Please let me know if u have any ideas I am using VSTO SE/ Outlook2007 /VS 2005/C# Thanks, Rama Tag: Visual Studio Tools for Office Creating a formatted Microsoft excel file. Office
- 5
- A strange problem in retrieving a file path and creating a button in Word Hi X4U Before I posted my question I already searched for similar threads and found it. I tried to use some of the code there but so far I didn't successed. First, like I wrote, I don't have a lot of expireance with COM so I don't konw what is a COM shim. According to some of the answers in that thread I managed to get the name of the application - PowerPoint - but that's it. When I try to get the ActivePresentation - the activeDocument object - I'm thrown to the catch block. Besides, like I wrote, I want to do it in Word - create a button in Word and get the current document that's running - not in powerpoint :-) I have office 2003 Windows xp Home Why can't I get "activeDocument" and then the "documentPath" And why does the Word and Excel applications don't even connect to the Addin Does it has any connection to the registry keys. Code Snippet try { Type applicationType = applicationObject . GetType (); string ApplicationName = ( string ) applicationType . InvokeMember ( "Name" , System . Reflection . BindingFlags . GetProperty , null , applicationObject , null ); object activeDocument = applicationType . InvokeMember ( "ActivePresentation" , System . Reflection . BindingFlags . GetProperty , null , applicationObject , null ); string documentPath = ( string ) activeDocument . GetType (). InvokeMember ( "FullName" , System . Reflection . BindingFlags . GetProperty , null , activeDocument , null ); MessageBox . Show ( "Successed" , ApplicationName ); } catch { MessageBox . Show ( "failed" ); } Tag: Visual Studio Tools for Office Creating a formatted Microsoft excel file. Office
- 6
- Word automation from a Web Service Just recently it was announced that Save to PDF will not be integrated into Office 2007. It should be available as a d/l to add in. Don't know if that will work in the scenario you visualize. John mentions XML file formats; Word 2003 has this already. The main difference between now and what will be available when Office 2007 comes out is that a conversion filter will also be available at that time. For Word 2002 and 2003, this can be installed as an "automatic update", providing full capability for opening and writing Word 2007 XML files. For Word 2000 the converter can be installed, but it won't be integrated as fully with the Word application, meaning the conversions may not be as good or as seamless. If you go the XML route, then you should be able to find (or program) a tool that will convert the Word XML to PDF without needing to automate Word at all. (Note: the same should be possible already with Word 2003 XML, search the Internet for tools.) Tag: Visual Studio Tools for Office Creating a formatted Microsoft excel file. Office
- 7
- Deployment path setting Hello, I've developed an addin for Word 2007 using VSTO 2005 SE. For the setup file, I'm using the default setup file when I created the project. My question is, how can I set a default installation folder for my addin For example:- When the setup file launched, I want to make the *.msi file to automatically install the addin to a predefined folder. It means that no user interaction required, no need to choose an installation path and no clicking needed. Just a direct installation like the MS Office 2007 PIA msi setup file. Can it be done Hope someone can help me about this. Regards, Westman Tag: Visual Studio Tools for Office Creating a formatted Microsoft excel file. Office
- 8
- Adding images to home-made context menus Thank you, it works. Another solution is to forget the Style property and it works as well. Tag: Visual Studio Tools for Office Creating a formatted Microsoft excel file. Office
- 9
- Adding a large amount of contacts Thanks a million. It worked perfectly! Tag: Visual Studio Tools for Office Creating a formatted Microsoft excel file. Office
- 10
- Attaching custom actions Pane to all documents !!! Hi All, After reading quite a few posts and trying out various shortcuts or hacks to acheive an " Application Level Task Pane " for Word 2003, i have really come to a grinding halt !! few of the paths that i followed were 1. Tried to modify the XML of a WORD document by adding the _AssembleName=* and _AssemblyLocation custom document properties.... I am now trying to acheive this by Attaching Managed Code Extensions to Documents...still work in progress i guess my question would be that in one of these posts Misha Shneerson did point out that it was possible to attach a task pane at an Application level but could only be acheived by someone like her who knows the internals of ActionsPane and VSTO and that it wasnt for the *****Faint Hearted***** .... still trying to locate that post... so if any one could point me in the right direction or suggest an alternative, that would be great !!! I know that Custom Task panes are possible in word 12/ 2007... but i def. require to achieve this with word 2003 / Office Pro edition... as our target audience is not likely to move to office 2007 for quite some time !!! If i haven't been clear please do ask for clarifications !!! tha, koms Tag: Visual Studio Tools for Office Creating a formatted Microsoft excel file. Office
- 11
- Convert a selection and convert it to rtf Does anyone know of any 3rd party tools out there that would help me with this I am developng for MS Word 2003. Tag: Visual Studio Tools for Office Creating a formatted Microsoft excel file. Office
- 12
- ComboBox on an Outlook PropertyPage doesn't seem to get DrawItem events I also post this problem to the Windows.Forms group, but they're pretty sure that it is an Outlook problem: http://forums.microsoft.com/MSDN/ShowPost.aspx PostID=2009602&SiteID=1&mode=1 Any suggestions how how to do custom drawing of lists and combo boxes in an outlook addin Thanks, Ben Tag: Visual Studio Tools for Office Creating a formatted Microsoft excel file. Office
- 13
- ServerDocument.AddCustomization throwing COMException HRESULT: 0x80040407 Tim, First of all, do you have the VBA project system enabled You can check this in Excel 2003 by opening Excel and clicking on the "&Tools | &Options..." menu command, selecting the "Security" tab, clicking "Macro &Security..." and checking that "Trust access to &Visual Basic Project" is checked. If you have successfully created and built a VSTO 2005 solution on the machine in question this should already have been selected for you, but it is worth checking it manually. If the VBA project system is not enabled, try enabling it and running the server document code again. If VBA project is enabled already or the server document code continues to fail, please create a new empty Excel workbook, save it to the file system and run the server document code against this file. Does this fail also If so, could you please supply the error code and call stack. If not, please let me know. Best regards, Richard. SDE Visual Studio Tools for Office Tag: Visual Studio Tools for Office Creating a formatted Microsoft excel file. Office
- 14
- Support for multiple columns in Form Region controls Only in Orcas can you add a .NET control to a form region. And if you do, it's .NET controls only, none off the Outlook-aware olk* controls. Tag: Visual Studio Tools for Office Creating a formatted Microsoft excel file. Office
- 15
- Error when trying to install ClickOnce Application Possibly, but since the VSTO (Visual Studio Tools for Office) technology doesn't support ClickOnce you're less likely to find people here with experience. And it's off-topic for this forum :-) If you don't know which forum to ask in, try the "Where is the forum for..." forum for directions. Tag: Visual Studio Tools for Office Creating a formatted Microsoft excel file. Office
- 16
- Unlocking a project... #1 - I already stated I thought I was in the wrong place so reitterating that same information does nobody any good. #2 - I already read the link you posted. I am not a new to forums. I do my research before I post and as I said, I couldn't find this information anywhere else. So what better place to ask than a place that develops tools for Office Since I am developing a 'tool' for my company to use in Excel, I thought this might be the place to ask that question because this is 'Tools for Office'... right Again I say my apologies for being in the wrong area. If there is an MSDN forum for this, kindly point me in the right direction and I'll go that way (with the exception of the microsoft.public.excel.programming websites). About your opinion: Regardles of the fact that I agree with you on the 'code of ethics', I didn't ask for your opinion; I asked for information regarding an issue with my project. At certain points it is entirely necessary to 'work around' built-in security to make things work correctly and there is absolutely nothing wrong with that when you're the developer provided you stay within the confines of the program you're working in. I stated that if it couldn't be done I was open to suggestions on how to protect my code! It's not a wrong path when I am the developer . If you would have read my entire post you would know that I am not trying to circumvent the security of Excel, I am trying to enable my code to delete itself upon replication to a new worksheet out of the main program to protect 2 things: 1) the end user from errors in code execution because the sheet controls were deleted and 2) protection of my code from tamper. I even stated that I wanted to "...keep the guts protected..." I am a certified CCNA & MCSA and I know the reprocussions of reverse engineering so for you to go and state that I am trying to break someone elses protection code is down right preposterous and rude. Thanks for being informative, Dennis. Tag: Visual Studio Tools for Office Creating a formatted Microsoft excel file. Office
- 1
- Previous
AshishShakya
Hi,
How can you create formated excel files through a program. By formatting, i mean individual cell background colors, row widths, column heights.. and stuff.
Thanks in advance.
How can you create formated excel files through a program. By formatting, i mean individual cell background colors, row widths, column heights.. and stuff.
Thanks in advance.
Re: Visual Studio Tools for Office Creating a formatted Microsoft excel file.
TaylorMichaelL
You can use VSTO to create and manipulate any Office document through the programming interface exposed by the application itself. Since this is unrelated to the C# language I'm moving this posting from C# language to the VSTO forum. Someone in that forum can probably provide you more details.
Michael Taylor - 7/12/07
Re: Visual Studio Tools for Office Creating a formatted Microsoft excel file.
Dennis Wallentin
Hi,
This is a rather "open - ended" question as the number of available tools are more then just one 
However, You need to provide additional info in order to provide any relevant recommendations.
# Will Excel be available and if so what version(s) are involved.
# Will the file(s) be generated on a Server
Re: Visual Studio Tools for Office Creating a formatted Microsoft excel file.
Peter Ritchie
VSTO is not an API for creating Office files. VSTO is a tool to build applications targeting Office 2007, creating add-ins or document customiztions. It's is not a means of automating Office applications. For discussions relating to automating office applications and documents via .NET see http://msdn.microsoft.com/newsgroups/default.aspx dg=microsoft.public.officedev&lang=en&cr=US
VSTO is not an API for creating Office files. VSTO is a tool to build applications targeting Office 2007, creating add-ins or document customiztions. It's is not a means of automating Office applications. For discussions relating to automating office applications and documents via .NET see http://msdn.microsoft.com/newsgroups/default.aspx dg=microsoft.public.officedev&lang=en&cr=US
Re: Visual Studio Tools for Office Creating a formatted Microsoft excel file.
AshishShakya
Thanks for all your messages.. Let me give the full details to my problems. I'm leaving Office 2007 out of the picture.. So, lets say Office 2003 will be available at the max. You say VSTO is for Office 2007. So, maybe i can't use it... Thanks coz' i'll look into it anyway.
Cheers.
Thanks for all your messages.. Let me give the full details to my problems. I'm leaving Office 2007 out of the picture.. So, lets say Office 2003 will be available at the max. You say VSTO is for Office 2007. So, maybe i can't use it... Thanks coz' i'll look into it anyway.
Cheers.
Re: Visual Studio Tools for Office Creating a formatted Microsoft excel file.
Ji Zhou ¨C MSFT
Hi,
In fact, VSTO only supports Word&Excel2003 document-level solution and Outlook2003 AddIns. It is VSTO SE support Office 2007 AddIns. In my opinion, you can use either Office Automation or VSTO in your scenario. But your question is too general. You can get some information from msdn to start:
http://msdn2.microsoft.com/en-us/library/cww296yz(VS.80).aspx
Thanks
Ji