excel-2007

Creating an Excel 2007 bubble chart with date values in axis

I'm trying to create a graph showing the duration of issue resolution. I believe a bubble chart in excel will show what I want but I can't manage to get it working correctly. For each date I have a number of days (duration) and a number of issues (magnitude). Most dates have a duration of 1 with a large magnitude, and I want to avoid th...

How to focus a cell in Excel VSTO using C#? How to select first cell using C# in VSTO?

How to focus a cell in Excel VSTO using C#? How to select first cell using C# in VSTO? Please help with code... ...

Manipulate Excel workbooks programmatically

I have an Excel workbook that I want to use as a template. It has several worksheets setup, one that produces the pretty graphs and summarizes the numbers. Sheet 1 needs to be populated with data that is generated by another program. The data comes in a tab delimited file. Currently the user imports the tab delimited file into a new ...

Excel 2007 VSTO plugin exception when setting Font.Color

Hello all, I am working on an Excel 2007 VSTO plugin that is throwing COM exceptions on the client but not when debugging on my development machine. What the plugin does is capture Excel's Startup event, define a specialized style, then add an event handler to the SheetChange event. Anytime a value is changed in the sheet, the cell is...

Column No to Column Letter in Excel/VSTO using C#

How to find column's name or header? For example if i select column 5 in excel means i want the result as "E". How to get the alphabet or letter corresponding to column no. Please help me with the code ...

How to effectively use WorkbookBeforeClose event correctly?

On a daily basis, a person needs to check that specific workbooks have been correctly updated with Bloomberg and Reuters market data; i.e. all data has pulled through and that the 'numbers look correct'. In the past, people were not checking the 'numbers' which led to inaccurate uploads to other systems. The idea is that 'something' nee...

Exporting dataset to Excel file with multiple sheets in ASP.NET

In C# ASP.NET 3.5 web application, I need to export multiple datatables (or a dataset) to an Excel 2007 file with multiple sheets, and then provide the user with 'Open/Save' dialog box, WITHOUT saving the Excel file on the web server. I have used Excel Interop before. I have been reading that it's not efficient and is not the best appro...

Using Excel to work with SQL data (read/write)

I have a ton of data in a sql database which I would like to be able to import and display in excel (I can already do this) and additionally modify or append to the dataset within excel and write the changes/additions back to the database. What is the best way to go about doing something like this? Please let me know, thanks! ...

Excel 2007 file writer in C# results in a corrupt file

Hi, I am using a BinaryReader to read an Excel 2007 file from an Exchange mailbox using a OWA, the file is then written to disk using a BinaryWriter. My problem is that the two files don't match when the writer finishes. Worse still Excel 2007 won't open the writen file. Previously Excel 2003 has had no problem with the solution belo...

Excel VSTO ->Hide/Unhide Ribbon Button based on another Ribbon Button click

We are creating Excel 2007 AddIn using VSTO. Now we have a scenario where in there are 2 buttons. Button 'A' and Button 'B'. Button 'B'needs to be hidden based on the click on the button 'A'. But since the ribbon bar is not getting refreshed dynamically we are unable to see the change on the Ribbon Bar. I heard from some blods we need...

Excel hyperlink

Hi All, I have a column in excel, wherein I have all the website url values. My question is I want to turn the url values to active links. There are about 200 entries in that column with different urls in all cells. Is there a way I can create active hyperlinks to all the cells without writing a macro. ...

How to test to see if a computer has Excel installed (any version)?

I have a windows form application that when it starts needs to see if the user has Excel installed on the computer and if not display a message informing user that part of functionality will be disabled. Is their an easy way to perform this check? Working in Visual Studio 2008 with VB.Net ...

How can I find out if a cell in Excel contains a number/text or a formula?

What I like to do is conditionally format cells depending on whether the cell contains a formula (something starting with "=") or not. Is this feasible in Excel 2007? ...

Opening HTML Table in Excel - numbers are getting changed

so I have this HTML table with a bunch of big numbers in it that I want to open in Excel 2007... you can follow along at home: <table> <tr> <td>this is a big number</td> </tr><tr> <td>1111111</td> </tr><tr> <td>2335322864</td> </tr><tr> <td>23353228641</td> </tr><tr> <td>233532286418</td> </tr><tr> <td>2335322864...

Is there a utility that will let me write to an Excel 2007 .xlsm file with macros enabled?

I am writing a program that writes to Excel files. I am restricted to writing to Excel 2007, which is fine, and I'm using EPPlus, which is a great utility. The thing is that I need to have macros and VBA enabled for an update function in the sheet, but EPPlus will only write to .xlsx files, not macro-enabled .xlsm files. If I try to writ...

Creating excel template 2003 in C# on a machine with both 2003 and 2007 installed.

I have both 2003 and 2007 Excel versions installed on my machine. The current source code uses Office11 (2003) interop assembly Microsoft.Office.Interop.Excel.dll to create the Excel template. When I create the template and open in Excel 2007, it opens perfectly. The same template when I open in 2003 I get the message "File format is no...

How can I Export a Table in Access using VBA into a specific sheet in an Excel spreadsheet?

I have a some tables, we will call them Table1,Table2.... and I need them to be Exported into specific spreadsheets in a macro enabled Excel File (.xlsm) that already exists. So I would need to put Table1 into Sheet2, Table2 into Sheet3... and so on. I had been doing this manually by going to the export menu in Access but it is getting m...

run-time error '429' activex component can't create object

I've created a simple application .Net Class that converts an excel spreadsheet into a a pdf file. I then get a Excel 2007 application to call this dll which works fine on my development machine. However when i deploy it on to a Vista machine that has both the .net framework and excel 2007, i get this error - run-time error '429' acti...

Excel 2007 UDF keeps failing, why?

I've been trying to browse info about this for a while now. The user defined functions in Excel 2007 just make no sense to me whatsoever. According to all the tutorials, it should be really simple. Just press alt + f11, insert a new module, and enter the VBA code there. At this point typing '=FUNCTIONNAME(parameters)' into any cell shou...

Excel and Tab Delimited Files Question

I am encountering what I believe to be a strange issue with Excel (in this case, Excel 2007, but maybe also Excel 2003, but don't have access to it as I write this). I can reliably convert some server data over into a tab-delimited format (been doing this for years) and then open it using Excel - no issue. However, what seems to be hap...