Amicuk Programming Answers

How to compare data between two worksheet in Excel for applescript

2015-10-11   Views:3


Hi All, How to compare the data from two different worksheet in Excel and set the value into one worksheet according to the same name? Here is the example. Worksheet 1 & 2 current we have, the final worksheet is the result we want and the value can b

Hi All,
How to compare the data from two different worksheet in Excel and set the value into one worksheet according to the same name? Here is the example. Worksheet 1 & 2 current we have, the final worksheet is the result we want and the value can be input in worksheet 1. Much appreciate if you can help on it.
Worksheet 1:
Name          Number
Leo                 25
Jame               55
Leo                 30
Jame               60
Tim                 44
Tomas             77
Lyne                35
Tonny              66
Jame               22
Game              88
Worksheet  2:
Name          Number  2
Leo                60
Jame             150
Tim                66
Tomas            88
Lyne               55
Tonny            99
Game             111
Rusult in Worksheet 1
Name          Number        Total Number per name in Worksheet 1         Number 2 in Worksheet 2
Leo                 25                          55                                                        60
Jame               55                         137                                                       150
Leo                 30                           55                                                        60
Jame               60                         137                                                       150
Tim                 44                          44                                                         66
Tomas             77                          77                                                        88
Lyne                35                          35                                                        55
Tonny              66                          66                                                        99
Jame               22                         137                                                       150
Game              88                          88                                                        111

The replay answer
I'd probably use a database for this, if there's any quantity of data involved here.  Import from Excel into {SQLite, MySQL, PostgreSQL, FileMaker, maybe Core Data}, or pick your preferred key-value store, keep your data in the database, then export or (via ODBC/JDBC) then access live database data from within the spreadsheets.
Alternatively and if you're looking at small quantities of data (say, less than 10,000 entries, or less than a thousand depending on the language), then just use whatever passes for a key-value store in your preferred scripting language {Python, bash, Lua, or maybe php, AppleScript or Java} and use that.  Export Excel to CSV {gag} or XML, then load that into Python and process as needed, then write out CSV {gag} or XML.
AppleScript is a scripting language for GUI applications, and also useful for processing events.  If you're not doing that sort of stuff, then there can be other choices, and other choices can often have extensive frameworks and libraries for common tasks.
Sooner or later, most everybody runs into a wall when using a spreadsheet...  Various folks have encountered those limits and have migrated from spreadsheets to FileMaker databases, and now use a database as the central store for their operations — and that's the other issue that can arise with spreadsheets... Where's the canonical data?

Go to See the other 3 answers

How to compare data between two worksheet in Excel for applescript

Category:DefaultRelease time:2015-10-11Views:130

Hi All, How to compare the data from two different worksheet in Excel and set the value into one worksheet according to the same name? Here is the example. Worksheet 1 & 2 current we have, the final worksheet is the result we want and the value can b[More]

Upload data from multiple worksheets of excel file into SAP by using MIME?

Category:DefaultRelease time:2015-10-11Views:130

Hi all, I'm trying to getting the data from a multiple worksheet excel file by usin the MIME Repository. First of all i realizied it like [here|] in a normal ABAP R[More]

How to Transfer SAP data to perticular Worksheet in Excel file

Category:DefaultRelease time:-0001-11-30Views:130

Hi, I have a requirenment to Transfer SAP data to Perticular WorkSheet in an Existing Excel file, i tries using EXCEL_OLE_STANDARD_DAT but this FM deletes all Existing worksheets in the Excel file and creates only one new worksheet and adds data to i[More]

Compare data in R/3 with data in a BW Cube after the daily delta loads

Category:DefaultRelease time:2015-10-11Views:130

Hi Friends, How can I compare data in R/3 with data in a BW Cube after the daily delta loads? Are there any standard procedures for checking them or matching the number of records?Hi Sunil, If you want to check the records daily instead of checking t[More]

Comparing data b/w biw and oltp

Category:DefaultRelease time:2015-10-11Views:130

hi Could some one can halp me how to compare data between biw and oltp system.which has been extracted. Thank for your precious time spent to help me in learning. Thanks, JagadeeshJagadish, It is not always all extracted data are coming from one stan[More]

Comparing data in different resultsets

Category:DefaultRelease time:2015-10-11Views:130

Hi everybody! I am working on an web application involving some EAI, as a requirement i need to compare data from two different sources (databases to be precise) and fill a XML based on certain rules. I wish to know if there is a way to compare two R[More]

Table_comparison - how to compare data at a high level

Category:DefaultRelease time:2015-10-11Views:130

Hi, I have to do data validation at a high level between two tables that I am loading. I am trying to use table_comparion transform but the problem is that my target table is at a much lower level than at which I want to compare data. So it has many[More]

Compare data from a table

Category:DefaultRelease time:2015-10-11Views:130

Hello, I am trying to compare data from one and the same table. In short I have:      NAME     DTM     CHARGE      Atanas     8/18/2012 9:33:23 AM     100 Atanas     8/18/2012 9:33:23 AM     101      Niki     8/18/2012 9:33:43 AM     200      Niki   [More]

Comparing data from two tables

Category:DefaultRelease time:2015-10-11Views:130

My PL/SQL is very limited, however, I need to write some code that compares data stored in two different Oracle tables and then writes the differences to a third table. Both tables have primary keys that I will use to ensure I am comparing like for l[More]

How to compare date which is greatest date

Category:DefaultRelease time:2015-10-11Views:130

iam new to sql how to compare date which date is greatest date with example can i use to_char to compare date SELECT eno, ename, GREATEST (TBLE.MAX1, TBLE.MAX2) recent_date "                FROM (SELECT TBLA.eno, TBLA.ename, "                MAX[More]

How to compare date and time together

Category:DefaultRelease time:2015-10-11Views:130

Hi, How to compare Date and Time together? For example in a database table there are two fields rundate and runtime.  I want to compare these two with perticular date and time in the program.  Like, I want to pull all the records where the records's[More]

I have several users complaining about their Voice Mails ending up in their Junk folder.  When a user creates a rule to allow this email, Outlook produces an error.  Outlook won't let you create a rule unless the email comes from a valid address.  Cu [More]
I upgraded Firefox and now I cannot get to my bookmarks. Much of my work is in that list. When I click on bookmarks, it asks me to "sign in" to access my google bookmarks. I'm already signed in and still, no access! Can I speak with a human who [More]
...from my iPod Touch to my TV? I have an older video iPod that just uses the red, white and yellow cable and everything plays beautifully. With the iPod Touch I get just sound, but no picture. Any help is appreciated. TIAJim and Jason Thanks very mu [More]
I'm trying to create a query where the latest value shows up on my query. For example, my data looks like the following: Week      Hours 05/2007   1360.0 06/2007   1360.0 07/2007   1440.0 08/2007   1440.0 09/2007   1400.0 If I have a variable on the [More]
Having transferred all my music - album by album (1500 tunes) to my new computer from my old one, I have just downloaded the 7.6 upgrade and ALL my music library has been deleted from i-Tunes. I had an earlier deletion last week when I tried to trans [More]
I have a Power Mac G5 2.3GHz dual core processor with 2GB memory, running LogicPro 8 connected to a MOTU 2408 Mk3. I originally assigned the outputs on the individual channel strips on my Logic default work page to the individual outputs on the MOTU, [More]
I am using version 4.0 of APEX.  My question concerns linking to other APEX pages from a report.  In APEX we link to another page, which may be a form or another report, by using a column in the report as a link column.  Any column may be used to tra [More]
Hey guys, I am using my T500 with an Advanced Mini Dock at work. I keep the headphones (with microphone) plugged into the docking station.  Sometimes I want to listen to the audio on my laptop's speakers rather than inside the headphones. Is there an [More]
Dear Experts, I am new to this feature. I am developing sap interactive form with offline scenario. I try to put the button in adobe designer and call my Function module that exposed as web services. Questions 1. When I execute, It was failed. Do I n [More]
I have created a simple Flash movie that loops three logos. I want visitors to be able to access each respective website as the logos cycle through, so I have linked each logo to each company's website. However, when I play the SWF movie and click an [More]