Blog Posts

How to read subscript/superscript using PHPExcel library?

if ($objPHPExcel->getActiveSheet()->getCell($cell)->getValue() instanceof PHPExcel_RichText)
                {
                    // $plaintext = $objPHPExcel->getActiveSheet()->getCell($cell)->getValue()->getPlainText();
                    
 $cellValueAsString = '';
$elements = $objPHPExcel->getActiveSheet()->getCell($cell)->getValue()->getRichTextElements();
foreach ($elements as $element) {
    // Rich text start?
    if ($element instanceof PHPExcel_RichText_Run) {
        if ($element->getFont()->getSuperScript()) {
            $cellValueAsString .= '<sup>';
        } else if ($element->getFont()->getSubScript()) {
            $cellValueAsString .= '<sub>';
        }
    }
    // Convert UTF8 data to PCDATA
    $cellText = $element->getText();
    $cellValueAsString .= htmlspecialchars($cellText);
    if ($element instanceof PHPExcel_RichText_Run) {
        if ($element->getFont()->getSuperScript()) {
            $cellValueAsString .= '</sup>';
        } else if ($element->getFont()->getSubScript()) {
            $cellValueAsString .= '</sub>';
        }
    }
}
echo $cellValueAsString;

Imagick create image from pdf file

$url ='file.pdf';
$path='img';
$file=$path.'/300.png';
$im = new imagick();
            $im->setResolution(300, 300);
            $im->readImage($url.'[0]');
            $im->setImageFormat('png');
            $im->setImageBackgroundColor('white');
            $im->setImageAlphaChannel(11);
            $im->mergeImageLayers(Imagick::LAYERMETHOD_FLATTEN);
            if (!file_exists($path)) {
                mkdir($path, 0777, true);
            }
            file_put_contents($file, $im);
            $im->clear();
            $im->destroy();

7 Ways to Make Money Online

Youtube
Blog/Website
Affiliate Marketing
Dropshipping
Paid services
Selling online courses
Share Market

Video Editing softwares free and paid

If you want to create video for YouTube or any other platform
You will definitely need video editing software
if you are beginner you must first try basic free softwares like shotcut, openshot, hitfilm express
you can do all basic stuff with these softwares..
If you have money and want to get some simple software to edit video you may go with filmora
And if you have more money and want to go with best softwares you can go with premier pro, final cut pro these softwares are used professionally to edit movies