Click here to Skip to main content
11,721,053 members (83,704 online)
Rate this: bad
good
Please Sign up or sign in to vote.
See more: Java
I am generating excel file from text file,now i want to compare 2 excel files based on their content and want to highlight the updated content by making colour changing of the rowetc. Can someone suggest some sort of idea how ths can be done???Anyhelp would be really appreciated..thanks in advance
Posted 2-May-13 19:06pm
Surbhi1253

1 solution

Rate this: bad
good
Please Sign up or sign in to vote.

Solution 1

Probable Steps :
1. Read the text file
2. Read the old_excel file using POI api.
3. On the basis of text file create an new_excel instance using POI
4. before writing it i.e at the time of creation compare it with old_excel file
5. do the necessary update i.e. row color/column color change on the POI instance
6. finally write it.
  Permalink  
Comments
TorstenH. at 3-May-13 2:33am
   
+5.

to add in: you'll fiond the POI API here: Apache POI API

This content, along with any associated source code and files, is licensed under The Code Project Open License (CPOL)

  Print Answers RSS
0 Sergey Alexandrovich Kryukov 500
1 OriginalGriff 334
2 Mika Wendelius 160
3 F-ES Sitecore 140
4 Maciej Los 80
0 Sergey Alexandrovich Kryukov 2,199
1 OriginalGriff 959
2 F-ES Sitecore 640
3 Maciej Los 609
4 Richard MacCutchan 540


Advertise | Privacy | Mobile
Web01 | 2.8.150901.1 | Last Updated 3 May 2013
Copyright © CodeProject, 1999-2015
All Rights Reserved. Terms of Service
Layout: fixed | fluid

CodeProject, 503-250 Ferrand Drive Toronto Ontario, M3C 3G8 Canada +1 416-849-8900 x 100