in excel i have a column which contains about 5 numbers cola num1 num2 num3 num4 num5 now i have another excel file which has two columns and three numbers cola colb num1 5 num4 4 num2 1 and another excel file which has two columns and three numbers cola colb num2 2 num3 6 how can i use excel f...
Is it possible to reference data from one Excel spreadsheet to another spreadsheet and filter it? The data on the new sheet should be updated automatically. E.g. Sheet 1 colA|colB|colC xxxx|1111|2222 yyyy|3333|4444 xxxx|5555|6666 filter by xxxx: Sheet 2 colA|colB|colC xxxx|1111|2222 xxxx|5555|6666 Sheet 2 should be automatically up...
I want to plug a range object into a formula. An example should look roughly like this: Dim x As Range Set x = Range(Cells(1, 1), Cells(2, 1)) Range("C1").Formula = "=SUM(" & x & ")" The result should be "=SUM(A1:A2)" in cell C1. The point is to plug the the range object into a formula. I used SUM as an example, the real formula is...
Hello Friends, I am trying to connect to read Excel file data using BDC in SharePoint 2007. I have used the Microsoft ApplicationDefinitionDesigner.exe and created the following Application Definition file. I can test the Method instances and can import this file as well. But when I use this in Business Data List webpart, I am getting a...
I have some data in the first columns, some calculated fields right afterwards and I want to autofill the rest of the rows with the same rules that are in the first row. The total number of rows, number of columns for input/calculated data are known and I would appreciate a working example for this data: | A | B | C | D ...
I'm creating an excel-sheets that reads the tags from the MP3-files situated in a folder. Yet the time apparently is or calculated from data inside the MetaProperties of a file or is inside those data. When I use the Property MetaProperties VBA always provokes an error, even in using a copy of the example in adapting the appropiate data....
I'm trying to read an excel file from C# using COM, and can get it opened and loaded just fine. However, I don't want to use all of the data on the sheet (it expands monthly), just a certain subset that starts below the top of the sheet (row 3 for headers, row 4 for data) and goes to the end. I can currently get a range representing th...
Hello all! I need to implement a functionality where a user can upload an Excel file, that is, .xls file and i need to write a function that will read that file and then save the values in a table, compare them to values in another table and then print some kind of billing quotation. From what I have read, it seems that the best way to...
I want to know if it is a possiblility to find the frequency string data occurs in the table which contain strings. I find there is a FREQUENCY function, but it is to find the frequency numeric data occurs between some specific values. For example, I have the table: And want to know how many times in first column (ID number of prod...
I'm looking for a simple macro to specify cells as being of type "time" and typing only numbers (for example "955") will format that (and recognise as) "hh:mm" time. In other words, by typing "955", the cell would interpret to "09:55", whereas all I can have it do right now is interpret to "1902-08-12 00:00:00" (most likely 955 is the d...
Hi, I am able to read the excel sheet from c# + asp.net application with MS interop Excel services (namespace). Data retrieving fine. But my excel sheet have a colummn whose formate type is of hh:mm:ss type. while retriving data i found value of this column fetching as General column getting some 0.45645646... like value. What should thi...
Is there a way I can create Excel Pivot tables using ASP .NET 3.5 with C# ? ...
Suppose you have an database with the largest tables containing about 200.000 rows, and frequently modified. The client wants Excel to connect via ODBC to the database, and work as a frontend to manage the data. The data should be modifiable by up to 25 users concurrently. My first instinct would be to recommend something else, for exa...
Hi, While saving an excel file with chainese character to csv, these characters are converting to ??? (Question marks) junk characters. Please let me know if any of you have any solution for this. I tried saving it in unicode text, it worked fine but when I tried saving it as .csv, its not working. Thanks ...
So I want to capture some key-commands in our Docuement-level Excel VSTO addin. I can't seem to find a way to do it, other than to use VBA and have our addin talk to the VBA. Any help/examples would be greatly appreciated. I am using Excel 2007. ...
currently i'm doing this: string cellValue = sheet.get_Range("A12", _missing).Value2.ToString(); this works but i really need to select a cell by row and column index. i get a null exception when i try string cellValue = ((Range)sheet.Cells[row, column]).Value2.ToString(); any ideas? ...
How do I write a macro that copies columns into a list and inserts some words in between? Like follows: John Doe 1256 856 Jane Doe 5462 564 Tom... becomes John Doe word word word word 1256 word word 856 Jane Doe word word word word word 5462 word word 564 Tom..... The word is constant i...
Hi, Is there anyway that I can assign a value/name to cell within a function ? Thank you EDIT Sorry for being unclear, here is my requirement. I'm having a user defined function (=MyFunction()) which can be called from a excel sheet. Thus, I also having a menu button where I need to recall the all the functions calls to =MyFunction(...
Hi, I need to find out cell addresses which has called a specific function, If my function is MyFunction (arg1, arg2), I should be able to find the cell addreses using name "MyFunction". Please help me to find out what would be the most efficient way to do this. Thank You ...
I am trying to connect to excel table from Delphi 7 using TAdoConnection component. The problem is when I select Microsoft.Jet.OLEDB.4.0, Extended Properties="Excel 8.0;", I sometimes receive error, that external table is not in the expected format. When i select: Provider=Microsoft.ACE.OLEDB.12.0;Extended Properties=Excel 12.0;...