Adding a Single Audio to Multiple Videos using Python and MoviePy

Md Morshedul Islam — Wed, 24 Jan 2024 11:34:41 +0000

MoviePy is a Python module used for video editing. You can automate many video editing tasks using this library. In this blog, we will explore how to add sound to silent(or noisy) video(s).
Make sure you have Python installed, and install the moviepy library using the following command:

pip install moviepy

Scenario: We have a folder with multiple videos and an audio track to add to all of these videos. If the video length is greater than audio the the audio will loop otherwise trim. We will save the output to another folder.

Reading videos and audio track

video_files = [f for f in os.listdir(video_folder_path) if f.endswith('.mp4')]
audio_clip = AudioFileClip(audio_path)

Process each video

Loop over videos and do the following for each video:

Get the absolute path of the video and define the absolute path of the output video.
Load the clip to the program using the moviepy module.
Check if the video length is greater than the video length then clip the audio otherwise loop the audio to fit in the video length.
Save and Close the video. Done!

for video_file in video_files:
        # Specify the paths for the current video and output video
        video_path = os.path.join(video_folder, video_file)
        output_path = os.path.join(output_folder, video_file)

        # Load the video clip
        video_clip = VideoFileClip(video_path)

        # Trim or loop the audio to match the duration of the video
        if audio_clip.duration > video_clip.duration:
            # Trim the audio to match the duration of the video
            audio_clip_processed = audio_clip.subclip(0, video_clip.duration)
        else:
            # Loop the audio to cover the entire video duration
            audio_clip_processed = audio_clip.volumex(video_clip.duration // audio_clip.duration + 1)

        # Set the video clip's audio to be the modified audio
        video_clip = video_clip.set_audio(audio_clip_processed)

        # Write the final video with audio using different codec options
        video_clip.write_videofile(output_path, codec='libx264', audio_codec='aac')

        # Close the current video clip
        video_clip.close()
        audio_clip.close()

That's it! Adding sound to your videos is now just a few lines of Python code away. Happy coding!

Excel Generation in C# using NPOI Library

Md Morshedul Islam — Tue, 16 Jan 2024 11:46:19 +0000

Installation

NPOI is a popular package for reading and manipulating Excel in C#. To get started with NPOI, you need to install the NPOI NuGet package into your project. You can do this using the NuGet Package Manager Console by dotnet add package NPOI or Visual Studio's NuGet Package Manager.

Basic Usage

Create a new workbook
Add sheets to the workbook
Populate cells with data
Add formula
Merge Cells
Formatting and styling

Note: Accessing cells is similar to accessing a 2D array.

using System;
using System.IO;
using NPOI.HSSF.Util;
using NPOI.SS.UserModel;
using NPOI.XSSF.UserModel;

class Program
{
    static void Main()
    {
        // Create a new workbook and sheet
        IWorkbook workbook = new XSSFWorkbook();
        ISheet sheet = workbook.CreateSheet("Sheet 1");

        IRow row = sheet.CreateRow(0);
        ICell cell = row.CreateCell(0);
        cell.SetCellValue("List of employee");

        // lets make a simple table with header
        IRow headers = sheet.CreateRow(1);
        ICell header_id_cell = headers.CreateCell(0);
        ICell header_name_cell = headers.CreateCell(1);

        // assign value to header cell
        header_id_cell.SetCellValue("ID");
        header_name_cell.SetCellValue("Name");

        // add background color to header
        ICellStyle headerStyle = workbook.CreateCellStyle();
        headerStyle.FillForegroundColor = IndexedColors.LightYellow.Index;
        headerStyle.FillPattern = FillPattern.SolidForeground;

        header_id_cell.CellStyle = headerStyle;
        header_name_cell.CellStyle = headerStyle;


        // Create some data
        for (int i = 2; i < 10; i++)
        {
            row = sheet.CreateRow(i);
            row.CreateCell(0).SetCellValue(i - 1);
            row.CreateCell(1).SetCellValue($"Name {i - 1}");
        }

        // Save the workbook to a file
        string filePath = "Output.xlsx";
        using (FileStream fileStream = new FileStream(filePath, FileMode.Create, FileAccess.Write))
        {
            workbook.Write(fileStream);
        }

        Console.WriteLine($"Excel file created at: {Path.GetFullPath(filePath)}");
    }
}

We can do lots of things with this package. Here are some examples.

Lock specific cell

// Protect the sheet
sheet.ProtectSheet("password");
//Pass the cell you want to make read-only
static void SetCellReadOnly(ICell cell)
{
    // Create a new style with the "locked" property set to true
    ICellStyle style = cell.Sheet.Workbook.CreateCellStyle();
    style.IsLocked = true;

    // Apply the style to the cell
    cell.CellStyle = style;
}

Merge Cell

static void MergeCells(ISheet sheet, int firstRow, int lastRow, int firstCol, int lastCol)
{
    sheet.AddMergedRegion(new CellRangeAddress(firstRow, lastRow, firstCol, lastCol));
}
// example:
// Merge cells A1 to D1
MergeCells(sheet, 0, 0, 0, 3);
// Merge cells B2 to D5
MergeCells(sheet, 1, 4, 1, 3);

Add Formula

static void AddFormulaToCell(ICell cell, string formula)
{
    cell.CellFormula = formula;
}
// Example formula: Sum of values in cells B3 to B9
AddFormulaToCell(totalCell, "SUM(B3:B9)");
For using the formula into another sheet: `"Sheet1!A2+Sheet1!A3";`

Auto size row and column

static void SetAutosize (ISheet sheet, int colNo)
{
    sheet.AutoSizeColumn(colNo);  // for row: AutosizeRow(rowNo)
}
// example :
SetAutosize(sheet, 0) // this  will auto size first col

Read Existing Excel

// Load the existing workbook
string existingFilePath = "plan.xlsx";
using (FileStream existingFileStream = new FileStream(existingFilePath, FileMode.Open, FileAccess.Read))
{
    IWorkbook workbook = new XSSFWorkbook(existingFileStream);

    // Create a new sheet named "erosNext"
    ISheet erosNextSheet = workbook.CreateSheet("erosNext");
}

Hope this blog will help you. For more examples refer to this github repository.

DEV Community: Md Morshedul Islam