kevin Abel

Ranch Hand
+ Follow
since Jan 15, 2018
Cows and Likes
Cows
Total received
0
In last 30 days
0
Total given
0
Likes
Total received
2
Received in last 30 days
0
Total given
32
Given in last 30 days
0
Forums and Threads
Scavenger Hunt
expand Ranch Hand Scavenger Hunt
expand Greenhorn Scavenger Hunt

Recent posts by kevin Abel

//This code comes from come from StackOverFlow.    



it seems to work when I RUN the script. It is bringing back the numeric data as a string of number characters.

It crashes when I use the DEBUG mode and I don't know why.  I attached the error part in the Attachments.  

Thanks,

Kevin
Tim,
I appreciate your reply.
Is this the type of metadata that your are writing about?

if (currentCell.getCellTypeEnum() == CellType.NUMERIC) {
  //do something
}

Is there a way to get more specific details about the numeric type?

Thanks,

Kevin
Tim,
I agree.  I missed his way of communicating with him about the class.
I filled in the reply sheet and sent it to him.
I hope that he contacts me.
Thanks,
Kevin
2 months ago
I'm using POI to fetch a cell from an Excel Sheet and that is working well.

I determine that the cell contains numeric data but I don't know how it is being represented.  It may be 884312314  OR 34.555 OR 74.23 OR 27.34E6

I need the result to be a String.

I'd like to show the scientific value as a string of numbers without the E.

I can throw away the decimal part but prefer not to round.

If it was always the same input format I could use a Java method or formatting to get to a String.  The trouble is that I wont know the starting format.

What can I do?

Thanks,

Kevin



Henry, Campbell, Stephan,
I see it now.  My eyes were messing around with me.  I wasn't seeing that the <> were operating as a pair.  
Sorry about that.
I kept looking at the > and thinking it was attached to the[] brackets.
Thanks,
Kevin
2 months ago
What do the > mean in the code below?



Thanks,

Kevin
3 months ago
Hello Office,
I'm trying to reach Yoel Fisher.  He is offering Java classes.  I'm not sure if I'm using the messaging feature of this site correctly.  Yoel sounds like a good resource but I'm having trouble connecting with him.
Once I was blocked because I included my telephone number.
I'm not sure what happened with the next attempt.
Thanks,
Kevin
3 months ago
Jeanne and Dave:

I'm at work so I could not paste all of the code.
I understand that by not showing all of the code it may not be possible to assist me.  
I'm working on a version of the software that is completely mine so that I can paste the entire thing.

I'm posting some of my progress.  It is OK if you don't respond.  

The calling class "public class DCFNewInTake2" is the higher level class which communicates with the Application Under Test.  It calls "ToListArray.parseExcelData();" which reads data from an Excel Workbook, stuffs it into a list array and sends it back to DCFNewInTake2.

In the mean time I got some on-site assistance and did these things:

I added this import statement:


I also changed the code in the calling class.  I was not correctly referring to the Class which is ToListArray and the method inside of the class.

     

When I run the code I receive an initialization error.  
Also it says:
At Java Lang Reflect at constructor new instance(Unknown source)

Again... I know this is not complete information and a response is not required.    

Thanks,

Kevin

3 months ago
Background
Eclipse/Java/TestNG/Selenium
I'm not an advanced Java programmer but I have a plan of what I'm trying to accomplish.
A colleague demonstrated an automated script.  He gets the data from a CSV file.  I want to know how to do this with POI.
My function is reading in the Work Sheet data.  I don't know how to send it to the calling function which does the work of communicating with the Application Under Test.

Setup
Two classes are involved.
The first one uses POI to get data from an Excel Workbook Sheet.   It gets the data into a two dimensional array list.  I will pass this array list into another class.
The second one should receive the array list and then use its contents to do automation testing work.
It may be better for me to first only send the outline of the code so I can explain the parts that I'm having trouble with.  I can send more of it if requested.

Challenge
I don't know how to pass the array list and then get specific data from it once I pass it to the "calling class/method".

Code


Next I will show the calling class/method



Summary
I want to know how to pass a list array and get the contents.
3 months ago
In eclipse I am hovering over a method such as below:

DataParser.Breakup();

I am hovering over the breakup part with the mouse.  I am holding down the control key.

It shows to choices in the pop up rectangle button:

1)  Open Declaration
2) Open Implementation

What is the difference?

4 months ago
Yoel,
I am a QA Automation Developer.  I'm from the UFT side. I have been studying The Eclipse/Java/selenium/appium topic for years.  My level of java does not have to be at a high level.  My biggest roadblock is usually setting up the shareware.  I get the jars in the wrong place, paths wrong, wrong versions.

I have a tutor on these topics but I wouldn't mind a second set of assistance.

I'm older now and seem to get more technically frustrated with spending hours getting things to work.  I need to know enough to solve technical issues and keep moving.

Another path for me might be to go toward pure Java and getting away from QA automation but I don't know what the learning curve would be.

My original message was blocked because I included my telephone number.  I am attempting this again.

Thanks,

Kevin

5 months ago
Jeanne,
I'll try F5.  I didn't know about this in Eclipse.  F5 seems to be popular in many environments.
Now my client locked down the environment so I cannot even get the new zip file on the machine.  Once I find out how to migrate the zip file I'll get to attempt again.
Thanks,
Kevin
5 months ago
Please let me explain better:

I moved java code from one PC to another.  I made a project with the same name.  I made a sec folder.  I copied the src folders which are also packaged using file explorer.
The packages don't appear.  When I try to create the packages eclipse says they already exist.  Can I sync eclipse to the file structure?  Should I have copied files from a higher level?
This is sort of the same question on Code Ranch but I'm not getting responses.

Thanks,
Kevin
5 months ago
I am working on Eclipse with Java.

I moved files from PC A -> PC B

I created a project inside of eclipse.  I moved the files to the correct place (I think so) in the file directory.  I do not see the files under the src folder as packages.  When i try to create the package it says that it already exists but it does not show it in the project in Eclipse. How do I sync between the file directory and Eclipse?

Thanks,

Kevin
5 months ago
I like this sentence:

When a bride gets married she gets a new name and a dress(address).

Thanks,

Kevin
6 months ago