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]

So my friend that I text with occassionaly has left Apple for Android (i know right?). Anyway, we had a nice little iMessage session going but now that she has continued texting me from her android, my iPhone insists on replying via iMessage and will [More]
How can I remove an image from the stage when the next thumbnail is clicked? I tried removeChild as you can see in the code, but it removes the last thumbnail. Otherwise it works. Only problem, it removes the last thumbnail!!Yes, the thumbnails are b [More]
Dear members, (Forms 6i c/s) Function keys have different behaviors in enter_query mode: some are allowed (F1), some are forbidden (F6), some are unused (F2). It seems that I can't use a KEY-F* trigger to intercept the function key behavior and make [More]
Before I upgraded to Firefox 4, the back button (as it is in every other browser under the sun,) had a dropdown so you could skip one tier of going back and drop back multiple levels. This is especially important when there is a site redirecting you [More]
Does Weblogic Server 5.1 supports RedHat Linux 7? Thanx in advance.FYI. I am running RH 6.2 and Weblogic 5.10 with no problems. w/Apache 1.3.12 Only using WL for EJBs and jdbc pool at this time. So your milage may vary. Michael Girdley wrote: No, not [More]
I finally acclimated to my upgraded to PS CS5 Extended after transferring over presets, brushes, actions, etc and decided to uninstall CS4.  Of course now when I open CS5, I receive an error message indicating the some of the support files are missin [More]
Dear Expert, We trying using module AR Invoice with payment ad POS system... We just change the barcode column field become the first column, then using barcode scanner to key in the items. Unfortunately each time the scanner send the numbers also se [More]
Suddenly when opening files, the files are not sorted out in alphabetical order; I don't have a clue how this happened.Did you check that the Name column in the file picker has a arrow to indicate sorting by name?Read other 3 answers [More]
Hi All Basically what Im trying to ask is that I have been developing jsp pages with some javabeans to insert information into databases and then to insert/retreive this information. I have been doing this by hand and it takes time even though I have [More]
In May of this year, I purchased the full Creative Cloud membership, allowing me to download any program on to my desktop. But now, not being able to work I can't afford the $50 a month and am wanting to switch from the full membership to just the Ph [More]