dennismonsewicz Posted February 3, 2009 Share Posted February 3, 2009 I have a huge excel spreadsheet and a lot of rows are highlighted the same color (IE: red) I am wanting to go through and delete all of the rows that have the same background color... is there anyway of doing this? I have tried googling it and I can't find anything... everything i find is in VB (EW) Quote Link to comment Share on other sites More sharing options...
premiso Posted February 3, 2009 Share Posted February 3, 2009 I do not think you can do this in PHP. VB Would definitely be the way to go. If you can do it in PHP it would be using http://www.codeplex.com/PHPExcel But I think that part of excel is done in Binary. So yea, good luck with VB 6! Quote Link to comment Share on other sites More sharing options...
Mark Baker Posted February 4, 2009 Share Posted February 4, 2009 The latest Subversion code for PHPExcel provides row and column iterators. You could use a rowIterator to loop through every row in each worksheet, test the background colour of each row, and delete it as required before writing the whole workbook back to file. Quote Link to comment Share on other sites More sharing options...
dennismonsewicz Posted February 5, 2009 Author Share Posted February 5, 2009 Thanks! I will have to check it out... I have used the PHPExcel before to dump results from MySQL out to an excel spreadsheet so loading in an excel spreadsheet and modifying it via this script shouldn't be too hard to do. Thanks again! Quote Link to comment Share on other sites More sharing options...
Recommended Posts
Join the conversation
You can post now and register later. If you have an account, sign in now to post with your account.