excel

insert row keeping formula in excel

Hi, I have a range of rows with a column with a formula I populated using ctrl-D. How can I insert a new line so values are blank but formulas are copied? Thank you ...

VSTO - Shared addin for Word and Excel to modify the ribbon

I have successfully used the Excel and Word addin templates in Visual studio 2008 to create a project that adds to the ribbon, but I am having difficulty with shared addins. I have created an add in that uses a xml file to modify and add to the ribbon and I can catch the events from buttons added, but I can't for the life of me figure o...

Accessing Excel Custom Document Properties programatically

I'm trying to add custom properties to a workbook I have created programatically. I have a method in place for getting and setting properties, but the problem is the workbook is returning null for the CustomDocumentProperties property. I cannot figure out how to initialize this property so that I can add and retrieve properties from th...

OleDb connection to Excel; how do I select fixed width, unbounded height?

I'm using OleDb to select data from excel spreadsheets. Each spreadsheet can contain many small tables, and possibly furniture like titles and labels. So it might look like this, where we have two tables and some titles; A B C D 1 . . . . 2 . . ...

how to delete an image on a sheet

hi let's say i have images on my excel worksheet, how is it possible to delete/remove them from the sheet using c#, following code gives me exception Excel.Worksheet ws = Globals.ThisAddIn.GetActiveWorksheet(); foreach (Excel.Shape sh in ws.Shapes) { sh.Delete(); } thanks! ...

Where can I find documentation for Excel's Pictures collection?

I have seen many references to doing something like the following to insert a picture in Excel: Set p = ActiveSheet.Pictures.Insert(PathToPicture) Where can I find the canonical documentation for this? ...

Excel "External table is not in the expected format."

I'm trying to read an Excel (xlsx) file using the code shown below. I get an "External table is not in the expected format." error unless I have the file already open in Excel. In other words, I have to open the file in Excel first before I can read if from my C# program. The xlsx file is on a share on our network. How can I read the fil...

Programmatically create checkboxes in c# in an excel spreadsheet

As part of a project I am working on, I a need to be able to create checkboxes inside an excel spreadsheet, could anyone provide a simple example or direct me to a useful reference? I am using the excel Interop. Thanks in advance. ...

Using Python to Automate Creation/Manipulation of Excel Spreadsheets

I have some data in CSV format that I want to pull into an Excel spreadsheet and then create some standard set of graphs for. Since the data is originally generated in a Python app, I was hoping to simply extend the app so that it could do all the post processing and I wouldn't have to do it by hand. Is there an easy interface with Pytho...

JEXCelAPI on android

When I added the JExcelAPI http://jexcelapi.sourceforge.net/ to the class path and run my app, I get: trouble writing output: shouldn't happen [2009-07-16 14:32:19 - xxx] Conversion to Dalvik format failed with error 2 any idea? thanks ...

Integer zero, "0' will be ignored when upload to SQL Server.

i have a page that allow user to upload an excel file and insert the data in excel file to the SQL Server. Now i have a small issue that, there is a column in excel file with values, such as "001", "029", "236". When it's insert to the SQL Server, the zero in front will be ignored in SQL, so the data would become "1", "29", "239". The da...

Re-Initializing "ThisWorkbook.Path"

First, thanks to those of you who gave me the suggestion on using "ThisWorkbook.Path". It worked like a charm. However, my code walks through seven (7) workbooks and when using "ThisWorkbook.Path" I can not re-initialize the "This.Workbook". Let me elaborate. This is the workbook where the Macro resides: Workbooks("Financial_Aggrega...

Reporting services, Excel rendering problem reporting services

Hi, I am rendering my report in excel from reporting services. Sometimes, when a cell value contains mutiplelines of text, it just stops with the first line. I found a kind of work around in this link http://www.kodyaz.com/articles/reporting-services-excel-rendering-autogrow.aspx But it doesnt work everytime. I compared the xml with othe...

Creating an Excel list with Ruby

I'm generating an excel in ruby which each line represents the results of an nmap scan. An example of a line could look like that: ip, yes (because port is 22 open), no (because port 80 is not open), etc. I would like to be able to create a header line with a drop down list for each port that allow me to select if that port is open or ...

FBA (forms authentication) site - Export to Excel

Office Client Integration features are disabled by design on an FBA site. How would I export a list into Excel programmatically? Pointers appreciated! ...

Excel xth letter of the alphabet

Hi, is there a short formula to get the xth letter of the alphabet? So if I give parameter '5' to the function, I would get the letter 'e'. thanks! ...

How do I make a burn down chart in Excel?

I have several books I want to finish reading by a certain date. I'd like to track my progress completing these books, so I decided to try making a simple burn down chart. The chart should be able to tell me at a glance whether I'm on track to completing my books by the target date. I decided to try using Excel 2007 to create a graph ...

Multiple conditions in excel 2002

Hello, I am using excel 2002 to create a spreadsheet. What I am trying to do is use the countif function but I have more than one condition. So I have 2 columns with a list of numbers and what I want to say is count the number of occurences where the number x is in one column and the number y is in the other column (in the same row). E....

How to immediately shutdown/close Excel VSTO Workbook when customize assembly not found.

Hi I create an Excel Workbook solution in Visual Studio 2008. When I build the solution I get a .XLS file and a .DLL (customize assembly). I can now start up the Excel sheet just by double clicking on the .XLS and there is my sheet functioning with all my C# code. But in cast of that customize dll unavailable. I start up Excel workboo...

Mediawiki / Excel: Hyperlink from Excel to a non-existant wiki page gives a 404 - how can I fix or work around this?

Hello, I suspect this could be something faulty with Excel (although I keep an open mind), but I wondered if anyone knew how I could get around this apparent bug: I wish to create Excel spreadsheets which link to pages in a local wiki (running MW 1.14.0, full details below) where those pages don't yet all exist. The idea is that over...