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) Link to comment https://forums.phpfreaks.com/topic/143691-solved-php-excel-question/ 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! Link to comment https://forums.phpfreaks.com/topic/143691-solved-php-excel-question/#findComment-753966 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. Link to comment https://forums.phpfreaks.com/topic/143691-solved-php-excel-question/#findComment-754560 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! Link to comment https://forums.phpfreaks.com/topic/143691-solved-php-excel-question/#findComment-755209 Share on other sites More sharing options...
Recommended Posts
Archived
This topic is now archived and is closed to further replies.