Computer Science Canada need help receiving data form excel file and update the data to another excel file using java |
| Author: | yingmu [ Thu Feb 07, 2008 1:14 pm ] |
| Post subject: | need help receiving data form excel file and update the data to another excel file using java |
hi, i'm making a program that can take selected cells from an Excel file, then i have to take these new cells and add them to the end of a list of another excel file, i can already obtain data from the original Excel file and put in a new Excel file, please help me on how to take these data and insert it in an existing excel file, btw i saved all the excel files in .csv, this way each cell is divided by comma, |
|
| Author: | OneOffDriveByPoster [ Thu Feb 07, 2008 3:28 pm ] |
| Post subject: | Re: need help receiving data form excel file and update the data to another excel file using java |
yingmu @ Thu Feb 07, 2008 1:14 pm wrote: please help me on how to take these data and insert it in an existing excel file How are you planning to insert it? New rows at the end of the file? |
|
| Author: | HeavenAgain [ Thu Feb 07, 2008 3:34 pm ] |
| Post subject: | RE:need help receiving data form excel file and update the data to another excel file using java |
when you use new FileWriter("here is your file name", true); set the append boolean to true, this way it'll append the new data instead of killing your preexisting datas |
|