Hi, I'm relatively new to excel programming. I'm working on making a spread sheet that shows exponential decay. I have one column (A1:A1000) of 1000 random numbers between 1 & 10 using the TRUNC(RAND()*10,0) in each cell. The next Column (B1:B1000) has a logic mask =IF(A1=0,1,0) , where if the value in the A cell is 0, then the B cell sh...
Hi All, My environment is VS2005 C# targetting Excel 2003. I gave myself a small dose of over confidence with the installer of this add-in when I saw that an .msi project was created just for me :) within the solution. Needless to say, this has been the trickiest part of the whole project and I am completely stuck on how to deploy and...
If I have a block of cells such as A1:D5, what's the quickest way of multiping each cell by another number, 1.1? ...
I have a MS Office COM addin written in C# (Visual Studio 2005) and uses a COM Shim dll. The addin DOES NOT use VSTO technology and supports Excel XP and higher. The addin adds a new toolbar and a menu. The addin works fine in Excel 2007 but it is displayed in a separate tab named "AddIns" along with its toolbars and menu. I want integr...
I have a list in SharePoint that has versioning turned on. This list contains a multiline text column that stores notes about the list item. The "Export to Excel" function works and produces a spreadsheet of all the list items however, each list item only contains the most recent entry in the notes column. I'd like this export to contain...
I'm responsible for developing a large Python/Windows/Excel application used by a financial institution which has offices all round the world. Recently the regulations in one country have changed, and as a result we have been told that we need to create a "locked-down" version of our distribution. After some frustrating conversations wi...
How do I track e-mails in and out of a shared in-box in Outlook using excel? We have a large number of e-mails coming in and we need to track responses to make sure that e-mails don't get lost. Is there as way to get the results from advanced find to an excel sheet? ...
So here's my challenge. I have a spreadsheet that looks like this: prod_id | pack | value | durable | feat | ease | grade | # of ratings 1 75 85 99 90 90 88 1 2 90 95 81 86 87 88 9 3 87 86 80 85 82 84 37 4 92 ...
I'm using SSIS to import data from Excel sheets into SQL Server 2005, the data contains some columns with data that should have the value of the previous non-empty cell in the same column, it looks like this: 2005 | 15 | Something1 | 12 | Something2 | 14 | Something3 2006 | 10 | Something4 | 2 | Something5 | 18 | So...
I am writing a Perl/Tk script which displays Excel worksheets using the ss2tk example script from the Spreadsheet::Read module. It does not round off two decimal places but the function from Spreadsheet::XLSX::Utility2007 does round off to two decimal places. Why? I'm trying to use that second function as a feature of my program to offer...
I have developed "get snapshot" button on excel, after I got data and closed , the error message occured like this Error Signature AppName: excel.exe AppVer: 11.0.8169.0 AppStamp:465f27bd ModName: otaclient.dll ModVer: 9.2.0.5109 ModStamp:485168c0 fDebug: 0 Offset: 0008beeb How we solve this problem. Note: I use VBA for creating butt...
Hi, My problem is the following... I have a little aeroplane and I need to track the hours. I have to track the hours by sectors and not the total of the day (that's why sometimes I have 2 or 3 on the same day). Now this is the problem... On column C I need to SUM the hours of the last 7 days. And any given 7 days, not just last week....
Hi, I want to copy some data from an excel file to a textbox in a win app. The copy paste works ok if the cells are continuos, but if I select (with CTRL) the first and the third cell, when I paste it to the textbox, it will paste also the 2nd cell. What is the best way to get just the cells i'm interested in? Thank you ...
Does anyone know if it's possible to add VB to an Excel document, from within Java? I basically want to add a pivot table to a sheet, and set some of it's properties dynamically. I know that I can access the pivot table settings from VB, but not directly from POI. ...
I am writing an Excel add-in that hosts IronPython 1.1 and I want to provide the Excel.Application COM object to the PythonEngine instance. My C# can access members of the COM object just fine. However, when my IronPython script accesses members of the COM object, I get a "System.ArgumentException: Object of type 'System.Int32' cannot b...
Can I sum these numbers with a formula ? 1 2 3 4 5 6 No, Im not looking for ="Sum(Cell___1:Cell_6)". With "Product" you multiply - I just want to add them. Like "=1+2+3+4+5+6", but just with a formula. Eg "formulaName(6)". ...
I'm just beginning to dive into VBA and I've hit a bit of a roadblock. I have a sheet with 50+ columns, 900+ rows of data. I need to reformat about 10 of those columns and stick them in a new workbook. How do I programmatically select every non-blank cell in a column of book1, run it through some functions, and drop the results in book...
I've got a Visual Studio Excel Workbook project. When I publish the workbook and examine the source of the workbook (I open WinZip and check custom.xml), I see the tag _AssemblyLocation, which corresponds to the publish path. Is there a way to read _AssemblyLocation from my .NET code? I'd like to be able to read the publish path and de...
This is probably a simple question, but I really don't know what I'm doing in Excel, so hopefully someone can help me out. I've been given an Excel spreadsheet that has two relevant columns to my task. The first column is an "External ID", and the second column is an "Internal ID". I need to select a bunch of data out of our databases (...
I want to make CSV::Writer generate a line break within a quoted string: A,B,"Line Line",C So that the row would display in Excel as: A,B,Line,C Line Is it possible to prevent CSV:Writer from stripping out newlines? If not, would switching to FasterCSV solve this problem? ...