How to clear all cells style(formating)

Topics: Developer Forum, Project Management Forum, User Forum
Jan 15, 2014 at 5:46 AM
Hello All,

I am using the PHPExcel library for excel sheet related works like ( reading the data from excelsheet, writing the data to the excelsheet).

In that we have one clarification. Please clarify.

When I import a new excel spreadsheet, I need to remove all styling/formatting through PHPExcel?. Please suggest the solution.

We tried with foreach it took much time. Is any method available to clear the styles/formatting for a spreadsheet.

Awaiting for your response.

Thanks
Mohamed
Coordinator
Jan 15, 2014 at 7:06 AM
There is no method for this purpose. My best suggestion would be to load one workbook, instantiate another new workbook, then use loop through the worksheets using toArray() and fromArray() to copy data from the original to the new (unstyled) workbook