On 5/27/09 Wed May 27, 2009 2:14 AM, "Kelvin Philip" <kelvinphi...@gmail.com> scribbled:
> Hi, > > Is there any method to append a row to an existing Excel file? Can I do it > using the Spreadsheet::WriteExcel module? The Spreadsheet::WriteExcel (SS:WE) module will not add data to an existing spreadsheet. If you are on Windows, you can try one of the OLE modules (I haven't used them) to run Excel and get it to add the row. Otherwise, you can use Spreadsheet::ParseExcel to read your existing spreadsheet and SS:WE to copy the data to a new spreadsheet, adding whatever data you want. However, you may lose some data or formatting in that approach if the two modules cannot handle something in your spreadsheet or you are not careful to copy everything. -- To unsubscribe, e-mail: beginners-unsubscr...@perl.org For additional commands, e-mail: beginners-h...@perl.org http://learn.perl.org/
