Also, you cannot convert C# code to Java code because there is a lot of difference in the standards of C# language and Java. Even if you could find a tool that converts the bytecodes to nearest Java code, there will be a lot of problems.
The problems will be more tough to solve, compared to creating the new application. You can easily create a new application, in NetBeans if you just look at what was done in C# and do the same in Java.
The sh*t I complain about
It's like there ain't a cloud in the sky and it's raining out - Eminem
~! Firewall !~
In my workplace we have an application that requires us to enter a unique tracking code into a java input field. We normally do this by scanning a barcode on an item until all items are scanned.
We already have a list of the unique tracking codes in excel so rather than scan each barcode when we have 100 or so items we copy from excel, paste into the field press tab to add the item and then copy paste tab repeat until all 100 items are added.
Is there a way to automate the copy cell --> paste id into input box --> Have the script press tab after id is pasted and repeat until all 100 items are added?
Posting this in Java as I am needing to put the data into a java application that is embedded in a web page but maybe I can paste the list into a Windows Form or a C++ application and then have that program perform the copy paste tab function for all items in the list.
Appreciate anyone's help I have no idea where to start.
Just an idea (which depends on the format of multiple selected cells).
Create a multi line input field where the content of all selected and copied cells can be inserted at once. Create a button that reads the input field content, splits it (depending on the separation characters provided by Excel when putting the data on the clipboard), and adds the items.
Excel puts the data in multiple formats to the clipboard but the form usually uses only the text format with line feed terminated rows and space (or tab?) separated columns. To check this just paste into any text editor.
I only have the raw data of Unique IDs so they don't have to be in excel can be in notepad or just pasted anywhere.
The IDs are being input into a Java Applet and must be added one ID at a time. So I need to copy Cell A1, Paste Into Applet & Press Tab and then copy Cell A2, Paste,Tab Repeat until all cells have been added into the applet.
The IDs are in excel but could be in a text file or just pasted into an application that could read all ids line by line input the text into the applet followed by tab key and repeat until there is no more lines to read.
As the applet input field is a text field I don't think any excel formatting of separating values will carry over from excel or a text file to the text field in the applet.
If the data are separated in some form (as text) and you are able to split them, then your applet should be able to iterate over the splitted data and perform the necessary operation on each item.
There will be some separating when Excel generates text to be put on the clipboard (or saved as text file; the default text file format used by Excel is TAB separation). When the cells did not contain spaces it should be always possible to split.
I understand that this might not be possible (especially when there may be multiple formats). Was just a suggestion.
Will it matter if the IDs are in Cell A1, A2 or should they been in A1, B1 all on the same row?
Sorry, but I can't answer that because I did not know in which order they are copied and if the order is important. But if there is no specific relation between the cell position and the content just forget the Excel cell indexes.
If you do not have the applet source then there is nothing you can do to automate this. Recording keystrokes in Excel to create macros does not mean you can then run those macros in other applications.
I have edited your message to delete the spam address of the subject. I suppose you don't want to help them or to get your messaage reported as spam, do you?
If something has a solution... Why do we have to worry about?. If it has no solution... For what reason do we have to worry about?
Help me to understand what I'm saying, and I'll explain it better to you
Rating helpful answers is nice, but saying thanks can be even nicer.
Last Visit: 25-Apr-19 4:15 Last Update: 25-Apr-19 4:15