nicolas diogo

thanks for the pointers

i will follow them up

with regards,

hi,

i have come across this problem where one of our bespoke applications only supports ASCII but our integration systems use Java.
so when we have strings that contains characters outside the ASCII spectrum, our bespoke application call fails.
it seems that we have to convert these strings into ASCII before calling this application.

so my question is to find out the best way to handle this in Java.

for instance, we have a string like:

Nicolas Systèmes

how can i convert it to ASCII in such a way that you can still recognise it?
as something like this:

Nicolas Systemes

thanks,

thanks for moving into a better area

hi,

i am not very versed with Maven.
so i am trying to achieve something that i understand the process.

in Eclipse, i have created a JSF2 project, and i would like to have a second project (child/module) for the JPA2 (DB logic).
if i try creating a new project as:
new Maven Module

it will give an error saying:
The parent project must have a packaging type of POM

i have tried to understand this document here:
https://maven.apache.org/plugins/maven-eclipse-plugin/reactor.html

it seems that i am not able to understand the explanation.

the aspects of packaging the parent project into POM, and adding this POM reference to the child/module project seems counter intuitive.
as i expected these references to the other way around.

could i ask for some clarification here?

thanks,

tried by it does not accept NULL

really frustrating..

i honestly do not understand the logic of POI

public Workbook removeSheetMergedRegions(Workbook workbook, int sheetIndex){ int nbrMergedRegions = workbook.getSheetAt(sheetIndex).getNumMergedRegions(); System.out.println("found a total of merged regions of: " + String.valueOf( nbrMergedRegions )); for(int i = 0; i < nbrMergedRegions; i++){ System.out.println("testing MR existance: "+ String.valueOf(i)); if(workbook.getSheetAt(sheetIndex).getMergedRegion(i) != null ){ System.out.println("there is a MR with index"); workbook.getSheetAt(sheetIndex).removeMergedRegion(i); } System.out.println("trying to remove MR: "+ String.valueOf(i)); }


this method is supposedly providing me the number of Merged Regions on the sheet:

workbook.getSheetAt(sheetIndex).getNumMergedRegions();

i have a value of 44 returned by this method, but my loop throws error at iteration 22.

and if i changed my code for:

public Workbook removeSheetMergedRegions(Workbook workbook, int sheetIndex){ int nbrMergedRegions = workbook.getSheetAt(sheetIndex).getNumMergedRegions(); System.out.println("found a total of merged regions of: " + String.valueOf( nbrMergedRegions )); for(int i = 0; i < workbook.getSheetAt(sheetIndex) .getNumMergedRegions(); i++){ workbook.getSheetAt(sheetIndex).removeMergedRegion(i); System.out.println("trying to remove MR: "+ String.valueOf(i)); } return workbook; }

by checking on every iteration i find that not all merged regions are removed..

anybody has any suggestions?

hello

i receive a file that i have to process and i am trying to use Apache POI for that.

the sheet i have to collect data from has multiple merge regions (merged cells)

in POI, i can find a method that removes this merged cells.

but how do i find the merged cells?

in POI i can have this method:
workbook.getSheetAt( 0 ).removeMergedRegion( <int> )

but i would presume that i would be able to have a list of the Merged Regions in the sheet.

but i can not find how to collect it.

would someone please explain this?

thanks,

thanks for the editing.

i have checked your suggested page. and bookmarked it.

but i am still not able to remove links from existing cells.

maybe someone else will be able to give a suggestion.

i am sure it will be something simple.

i tried the following without success:
public void removeCellLink( Workbook workbook , int sheetIndex , int rowIndex , int colIndex) { CreationHelper creationHelper = workbook .getCreationHelper(); Cell cell = workbook.getSheetAt(sheetIndex) .getRow(rowIndex) .getCell(colIndex); Hyperlink link = creationHelper .createHyperlink(Hyperlink.LINK_URL); link.setAddress(""); cell.setHyperlink(link); }


thanks,

hello

i am trying to delete the hyperlinks from cells withing a range.

and i can not understand:

- which method to use to remove the hyperlink of a cell
- if i can use Excel coordinates to define a range (eg: B2:L45)

i have managed to delete the content of cells but the hyperlinks are still there.
in fact, i have searched the documentation of POI website on google:
excel poi (remove OR delete) hyperlink site:http://poi.apache.org

but nothing has been found


these are the portion of the class that i am working on:


/** * creates an instance of an Excel Workbook using WorkbookFactory * to avoid problems with Excel versions * * @param filepath is the path to a valid Excel file * @return an instance of a workbook */ public Workbook workbookOpenFile(String filepath){ File file = new File(filepath); Workbook workbook = null; try { workbook = WorkbookFactory.create(file); } catch (InvalidFormatException | IOException e) { System.out.println("WorkbookFactory has failed" + " to create a valid object for this Excel file"); e.printStackTrace(); } return workbook; } public static void removeCellLink(Workbook workbook, int sheetIndex, int rowIndex,int colIndex) { //TODO: need to find method that removes the link, it is possible to //remove the content of a cell by the Hyperlink persists //(ie: hyperlinks still available) Cell cell = workbook.getSheetAt(sheetIndex).getRow(rowIndex) .getCell(colIndex); cell.??? }

thanks in advance,

thanks

how do i implement your suggestion of 'find'
i do not really understand what you have meant by it.

hi,

i would like to find out if there is a way of knowing which attribute has changed in an entity managed by EclipseLink.

i have to implement a business rule if different attributes are updated - but i do not know how to 'compare' the new values that were updated against those that exist in the database.

i would appreciate if you could post links to documentation about this. i have searched but i doubt that i am using the correct terminology on this subject.

thanks a lot,

Nicolas

Many thanks Joanne

i was getting lost in trying to figure out this name

Cheers!

hi,

i am sorry for asking this topic again - but do not know how to call it and when searching for "<T>" it only turns up pages with any T in it.

i have done some java coding - but would not qualify myself as knowing it all.

but something that i am find more and more useful is the usage of abstract classes.

but i am failing to fully understand the process that i can pass a TYPE into the abstract to use.

i figure that my class has to have the type on it 'name' as:

class abstract MyShow<T>{ private String name=null; // getters and setters }

but i am failing to use the type <T> within the class.
could someone please provide me with a link or clarification on this?

thanks,

so eclipse just overwrites all entity classes?
is that right?

hello

i think this is something that i am missing when using eclipse to create/recreate my JPA entities' classes.

if i decide to recreate the entities eclipse will overwrite them and destroy any @NamedQuery that i have added.
is there some configuration in eclipse that would allow for me to change this behaviour?
i am sure that netbeans keeps @NamedQuery when recreating JPA entities.

thanks.