Member Avatar for Antony Rayan

Hi, I am new to this concept.

I donot know how to make certain coulmns to be readonly , but when uploading it into server , I have to access that column value,
I used this comment but it is not working. Here $avst is my excel file object.
$avst->getActiveSheet()->protectCells('A5:D5', 'PHP');

  • 2 Contributors
  • 1 Reply
  • 216 Views
  • 1 Hour Discussion Span
  • Latest Post Latest Post by rproffitt
Member Avatar for rproffitt

I'm unclear on the problem you are having but let's say the cells are not protected. Read http://stackoverflow.com/questions/17162711/phpexcel-cell-protection and see where you have a line before this to enable protection.
`$objPHPExcel->getActiveSheet()->getProtection()->setSheet(true);

Also, be sure to tag or mention when you use a library like PHPExcel or folk have to guess.

Be a part of the DaniWeb community

We're a friendly, industry-focused community of developers, IT pros, digital marketers, and technology enthusiasts meeting, networking, learning, and sharing knowledge.