I am using office 2007 excel work sheet function in c# code. VS2010 issues this warning Warning 3 Ambiguity between method 'Microsoft.Office.Interop.Excel._Worksheet.Activate()' and non-method 'Microsoft.Office.Interop.Excel.DocEvents_Event.Activate'. Using method group. D:\EXLANEDB01p\dev\libraries\EXCEL\Excel.cs 531 95 EXCEL How ...
I'm having issues with Unicode characters in Perl. When I receive data in from the web, I often get characters like “ or €. The first one is a quotation mark and the second is the Euro symbol. Now I can easily substitute in the correct values in Perl and print to the screen the corrected words, but when I try to output to ...
I have in one column lastname and firstname (Smith John) in the same field I would like to create an ID for each name with the following logic first two letters of lastname, first two letters of first name +a number starting 001. Ideally and this may not be possible in Excel I would like it to auto increment the number if there is one e...
The spreadsheet gem isnt documented properly, so I cant understand how can I write hyperlinks using spreadsheet gem. Can anyone tell me? ...
Excel has a "lookup" function that finds a specified value in a row or column and returns a corresponding value from another column. But is there a lookup that returns the reference of the found cell? I have a case where I have a column of dates, and I want to search the list for a given date and then return the reference -- A23 or what...
I have a table for soccer data in the following format: http://www.karpi.com/excel.jpg I would like to convert this data to one tab where I have each game like this: game date TEAM A TEAM B 3 1 Name 1 Name 2 Name 3 Name 4 Name 5 Name 6 Name 7 Name 8 Name 9 Name 10 Name 11 and another tab where I have game date T...
Hi all, I need to copy certain columns of every row in sheet A into sheet B. I have created a sub that creates 2 arrays (variants) of the matching column numbers, so I can map column 3 in sheet A to be equal to column 8 in sheet B, etc. Everything works fine, thing is it's quite slow, here it is: Sub insertIntoSelectedOpps(opCols As...
I am using spreadsheet gem to generate excel file. Now the problem with it is that when we modify an existing file it wont allow to save it with same name http://spreadsheet.rubyforge.org/GUIDE_txt.html and in the running script I cant delete and recreate the file beacause it is still being used. Doing so throws permission denied error. ...
I need to export my EditorGridPanel grid data to excel without sending any data to server-side, cross browser and cross platform solution that will work in ie6 and ie7. Any pure JavaScript solution is good as well! So far i have found only data URI solution which is great but ie supports it only from 8-th version. Also there is a possib...
Hi all, Just have a simple question. Does CR11 R2 has CONFIDENCE function from Excel? http://support.microsoft.com/kb/828124 If not how do I get confidential value? ...
anybody knows how or some library to use for this ? ...
I've got this error when I create a COM object in order to use Excel automation. Any one knows why I am getting this error? System.Runtime.InteropServices.COMException(errorCode = -2146959355) Message: Retrieving the COM class factory for component with CLSID {00024500-0000-0000-C000-000000000046} failed due to the following error: 8008...
hi, i want to insert data from an excel file into a local database in a UNIX server with java without any manipulation of data. 1- someone told me that i've to convert the excel file extension into .csv to conform with unix. i created a CSV file for each sheet (i've 12) with a macro. the problem is it changed the date format from DD-...
The first three columns exist. I am trying to create a formula for the fourth (HH_ANALYSIS_FLAG). ACCOUNT_NUMBER HOUSEHOLD_NUMBER ACCOUNT_ANALYSIS_FLAG HH_ANALYSIS_FLAG 1001 1 1 0 1002 2 0 0 1003 3 1 ...
In VBA / VB.NET you can assign Excel range values to an array for faster access / manipulation. Is there a way to efficiently assign other cell properties (e.g., top, left, width, height) to an array? I.e., I'd like to do something like: Dim cellTops As Variant : cellTops = Application.ActiveSheet.UsedRange.Top The code is part of a ...
i have an array: Dim qcNo(4, 2, 350) As String the problem i have is that sometimes there is a requirement for the matrix to be bigger. i need the 350 to sometimes go to 1000. is it possible to do a redim preserve on a 3 dimensional array? if so, how would i do it? ...
i have an excel spreadsheet of about 3 million cells. i asked the following question and i liked the answer about saving the spreadsheet as CSV and then processing it with python: http://stackoverflow.com/questions/3322939/solution-to-perform-lots-of-calculations-on-3-million-data-points-and-make-charts/3323168#3323168 is there a libr...
I am getting the error Win32::OLE<0.1709> error 0x80020009: "Exception occurred" in PROPERTYPUT "Value" at line 109. The code in is Perl. foreach my $ref_array1 (@$array1) { # loop through the array foreach my $col1 (@$ref_array1) { foreach my $ref_array2 (@$array2) { # loop through the array foreach my $col2 ...
I'm using the Spreadsheet_Excel_Writer plug-in to perform a data export from a PHP web app. All has worked well for quite some time now, but my client just informed me that in the last couple days the export behavior has changed: the downloaded file opens in Excel, then starts a new Excel instance and opens again. If you try to edit eith...
VBA is not cutting it for me anymore. i have lots of huge excel files to which i need to make lots of calculations and break them down into other excel/csv files. i need a language that i can pick up within the next couple of days to do what i need because it is kind of an emergency. i have been suggested python, but i would like to che...