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]

Hello, I am a novice in JSP area. What I am working on thesedays is to send an email when a password has been expired. The password will be expired after 60 days. Can I embed the codes in Servlet? Or should I use something else such as Oracle pl/sql? [More]
I downloaded norton internet security and it says I need firefox 4 to opperate correctly. I went to your site and downloaded lateset version and Norton still doesn't work . How do I get version 4 so that my computer and I are protected?How can I go b [More]
I am trying to configure custom OWSM authorization policies to grant web service access in OSB to userids associated with custom WebLogic groups. Both OSB and SOA are version with an Oracle Enterprise 11g database backend. To help rule out s [More]
Hi, What I require is: In a webdynpro table , which can have multiple rows, I want to make the rows which are retrieved fom backend as disabled for selection. And when I add a new row (using an ADD functionality) , this newly added row should only be [More]
Hi, anyone managed to install CRM 2015 Update 0.1? The software installed fine but the DB updates fail with a SQL error. Just want to know if this is just my issue or if MS have a bug in the update. This is the SQL error: System.Reflection.TargetInvo [More]
I mistakenly changed the language on my itunes to arabic and need to change back to english,  I have an ipod shuffle 2nd generationClick here and follow the instructions. (113615)Read other 3 answers [More]
I have alot of music in my iTunes library that are from "various artist" cds.  when in cover flow view i want to see "song" & "artist" fields displayed not "album" & "album artist".  is there a way [More]
Hi All, Please any one can give me an idea for calling Print screen in Webdynpro. Ex: I have  Button "PRINT IMMEDIATELY"   - when i click on this it should call the Print Dialog  for asking number of copies. Thanks, AnithaInteresting question, I [More]
Hi! I've made a template so that I don't have to keep telling Pages not to make space after each paragraph, but... Each time I use a style (like Heading) it automaticlly sets the space after a paragraph to 12 pt. This is annoying - can I change it? T [More]
I have 3 AirPort Dual Band BaseStations on the wired network and security is handled by the Radius service on a Mac (Snow Leopard) Server. In fact, 1 of them is a Time Capsule and although the wireless setup is identical to the other BSs, a MacBook P [More]