Win a copy of Grokking Bitcoin this week in the Cloud/Virtualization forum!

krishnadhar Mellacheruvu

Ranch Hand
+ Follow
since Sep 03, 2015
krishnadhar likes ...
Android Java Objective C
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
4
Given in last 30 days
0
Forums and Threads
Scavenger Hunt
expand Ranch Hand Scavenger Hunt
expand Greenhorn Scavenger Hunt

Recent posts by krishnadhar Mellacheruvu

Thanks Dave, clearly understood why is it happening that way...
1 year ago
Hi

i have this following code.


this code when executed is giving me the following output.


i am calling 2 instance methods m1,m2 from the main method by the object "im". I have also declared a String array variable a and passed it in my main method which i called from within my main method itself .my general perception was that i would get the output of the 2 instance methods and not knowing what would be the output for calling the main method from within the main method. Can any one explain what exactly is happening here.

Thanks
1 year ago
Hi

Tim,

The first link shared tough shifts the cell leaves the old cell as it is so tried modifying the code with and the entire code block fell in to place and worked like a charm. Though i worked on it previously did not pay full attention to it but a bit more concentration and work on the same worked for me.

Thanks
Hi

Paul,

I tried doing it with the below code



but the above line shifts the entire column down by 1 row.

Thanks
Hi

The below code creates row and then corresponding cell, but the situation i have is i all-ready have an xlsx sheet with 3 columns and 5 rows, i need to add a column at the beginning of the first column.


Thanks
Hi

From what i read and understood is there is no straight method to insert a column in the excel sheet by using Apache POI, please do correct me if am wrong..

Thanks
Hi

Is there a way to insert a new column in the excel sheet without loosing the existing data in the columns.

Thanks

Krishnadhar
Hi

I have written the below code to generate excel files from 1 workbook. The initial workbook contains 20 sheets, i have used file copy to copy the contents of the main sheet to new created workbooks(the new workbooks are created basing on the sheet names in the main workbook. I wanted to create a new workbook with only one sheet each from the main workbook. In that process i have arrived till the below code. Can any one throw some light as to how i can achieve that.



how to use the clone method to clone the sheets in the same location as that of the original file location.

Thanks
Hi

Tim,

The problem is splitting a file into pieces and how to implement the logic(splitting the file basing on number of sheets in a work-book) for the same. I have just started with POI of how to read and write files. But it would be great if you can point me out in the right direction in my quest.

Thanks

Hi

Tim,

Thanks for the reply, i am not stuck anywhere as i just started working with Apache POI, i was going through their documentation of splitting the excel file basing on the number of rows that is when i had this doubt as to how to split the file into multiple files basing on the sheets(irrespective of the cell type,format, etc.).

Thanks

Krishnadhar
Hi

I just started working on the apache poi i.e. working with excels, i came across many articles of how to split the excel in to multiple files basing on row count,size etc but i was wondering as to how to split a workbook basing on the number of worksheets. Suppose say i have a workbook with 3 sheets, i have to split the workbook into 3 workbooks with 3 sheet's i.e. 1 sheet per workbook (3 sheets are in the initial workbook). Can some through light on this as to how to go about it.

Thanks
That was a great example Jesper, i now clearly understand the concept...
2 years ago
Hi

Jesper

That means initially the value of the instance variable is the value initialized by instance block..if so is there a possibility to view the first set value?
2 years ago
Hi

Dave thanks for the reply, the order is Instance block->constructor block which is known(correct me if am wrong),what i was trying to understand is if the instance variable can be initialized from both instance block and constructor, what is the reason that the instance variable is getting initialized by constructor if  both constructor and instance blocks are used.
2 years ago