Forem: Soumyajit Pan

Milligram-Connect Social Media Application

Soumyajit Pan — Sun, 01 Dec 2024 12:40:43 +0000

Splash Screen

A splash screen is the initial screen featuring the app's logo or branding that appears when the app is launched, providing a visually engaging introduction as it loads.

Login Screen

The login screen allows existing users to access their accounts, while the signup screen enables new users to create an account by providing their details.

Home Screen

Once logged in, the home screen displays a scrollable feed where users can view all posts, like, comment, share, and save them. Additionally, users can open each post to see detailed information about likes and comments.

Users can comment and share on the posts shown in the images below.

Search Screen

On the Search Screen, users can navigate to the search option in the bottom navbar to find and search for usernames available in the application.

Create Post Screen

Users can access the Create Post screen via the bottom navigation bar, add images from the mobile gallery, write a caption, and post the content.

Notification Screen

Users can navigate to the Notifications screen via the bottom navigation bar to view and open all notifications.

Messaging Screen

Users can navigate to the Messaging screen via the bottom navigation bar, view the list of users, select a user to chat with, and see all messages for that conversation.

To delete user chats, click on the three dots in the top right corner of the screen. This will display the following popup with the delete option.

Settings Screen

After clicking the settings icon in the top right corner, the following settings screen will open. Users can access:

Account Center
Saved Posts
Account Privacy
Blocked (Not implemented yet)
Milligram Verification
Logout
Delete Account Options

1. Account Center
Upon clicking on the Account Center, the following page will open. Here, users can choose from two additional options:

Personal Details
Password and Security

Personal Details
After clicking on the Personal Details option, users will be directed to the Personal Details screen where they can view the email address they used to register and log in to the Milligram Connect application.

Password and security
After clicking on the Password and Security option in the Account Center, users will be directed to the Change Password screen, where they can update their password.

Below
Left Image: Personal Details screen
Right Image: Password and Security screen

2. Saved Posts
Upon clicking the Saved Posts option in Settings, users will be redirected to the Saved Posts screen where they can view posts they have saved from the feed.

3. Account Privacy
Upon clicking the Account Privacy option in Settings, users can choose between two privacy settings:

Public: All users in the Milligram application can see their profile.
Private: Only connected people can see their profile.

4. Milligram Verification
Upon clicking the Milligram Verification option in Settings, users will be redirected to the Milligram Verification screen. Here, they will see an option to send a verification email. After selecting this option, a verification email will be sent to their registered email address. The email will contain a URL that users must click to complete the verification process. Once successfully verified, the Milligram Verification screen will display a message saying "Your email ID is verified."

5. Log out
Upon selecting the Log Out option, users will be logged out of the application and redirected to the login screen.

6. Delete your account
Upon selecting the Delete Your Account option, users can permanently delete their account and all associated data from the application.

Profile Screen

Upon clicking the user profile logo image in the top left corner, the profile screen will open.

Edit Profile Screen
Upon clicking the Edit Profile button in the profile screen, users will be redirected to the Edit Profile screen. The screen shown in the left image below will become visible.

Share Profile
Upon clicking on the share icon to the right of the username, users can share their profile URL with any user on other platforms, the screen shown in the right image below will become visible.

Followers & Followings Screen
On the user profile screen, if a user clicks on the "Followers" or "Followings" text, the respective screen will open. Here, users can view the list of followers who follow them and the list of users they are following.

Open Another User's Profile
Upon clicking on any user from the followers or followings lists, the profile screen of that user will open. Users will be able to view the selected user's profile data, as shown in the image below.

Download and Install

The Android version has been released! Click the link below to download and install
Milligram Connect

Tech Stack Used

React Native CLI
Firestore and Firebase Database
Firebase Email Authentication
Styled-Components for styling

ExcelSheetIO

Soumyajit Pan — Wed, 31 Jan 2024 16:21:46 +0000

Click here to open ExcelSheetIO in PYPI

A Python package for efficient Excel sheet operations. Enables easy read/write functionality, data manipulation, and workflow automation. Ideal for handling both small and large datasets. Get started with ExcelSheetIO for a simplified data processing experience.

Installation Guide

pip install ExcelSheetIO

# For upgrade to the latest version
pip install --upgrade ExcelSheetIO

Method : `Read Data From Excel Sheet`

The ExcelReaderWriter class in Python provides an efficient way to read and retrieve data from Excel sheets. This guide will help you understand how to use the readCellData method in this class.

Sure, here's a more refined explanation:

To use the readCellData method in Python, you need to identify the specific cell data you want to read. Let's say, for example, you want to read the cell value Sr. Analyst from an Excel sheet.

First, identify the sheet that contains the data you're looking for. In this case, the sheet name is Sheet1.

Next, determine the row where your data resides. In this example, Sr. Analyst is in row number 6. To better identify the row, we use the data from the first column as a unique identifier(make sure the data of the 1st column of the sheet should be uniquely identifier data).

Then, identify the column header that contains your data. In this scenario, the column header name is Job Title.

With these parameters - the sheet name, the unique identifier from the first column, and the column header name - you can use the readCellData method to read the data. The syntax would be:

data = excel_reader_writer.readCellData('SheetName', 'UniqueIdentifierInRow', 'ColumnHeaderName')

In this code, replace 'SheetName', 'UniqueIdentifierInRow', and 'ColumnHeaderName' with your actual values (Sheet1, E5, and Job Title, respectively) when you use this method. This will return the data from the specified cell.

Python Usage

# import the ExcelSheetIO library package
from ExcelSheetIO import ExcelReaderWriter

# Create an instance of the ExcelReaderWriter class
excel_reader_writer = ExcelReaderWriter('path_to_your_excel_file')

# Use the readCellData method
data = excel_reader_writer.readCellData('SheetName', 'UniqueIdentifierInRow', 'ColumnHeaderName')

# Print the retrieved data
print(data)

In the above code, replace 'path_to_your_excel_file', 'SheetName', 'UniqueIdentifierInRow', and 'ColumnName' with the path to your Excel file, the name of the sheet in the Excel file, the unique identifier from the first column, and the name of the column header, respectively.

Robot Framework Usage

If you're using Robot Framework, you can create a custom keyword that uses the readCellData method. Here's how you can do it:

*** Settings ***
Library    ExcelSheetIO.ExcelReaderWriter    relative_path_to_your_excel_file

*** Keywords ***
Keyword for read data from excel sheet
    [Arguments]    ${sheetName}    ${UniqueIdentifierInRow}    ${ColumnHeaderName}
    ${data}=    Read Cell Data    ${sheetName}    ${UniqueIdentifierInRow}    ${ColumnHeaderName}
    Log To Console    ${\n}${data}

*** Test Cases ***
Test case for read data from excel sheet
    Keyword for read data from excel sheet    Sheet1    E5    Job Title
    [Tags]    read     test

In the above code, replace 'relative_path_to_your_excel_file', 'SheetName', 'UniqueIdentifierInRow', and 'ColumnHeaderName' with the path to your Excel file, the name of the sheet in the Excel file, the unique identifier from the first column, and the name of the column header, respectively.

Please replace 'relative_path_to_your_excel_file', 'SheetName', 'UniqueIdentifierInRow', and 'ColumnHeaderName' with your actual values (.\\Data\\Employee.xlsx, Sheet1, E5, and Job Title, respectively) when you use this code.

Method : `Write Data In Excel Sheet`

The ExcelReaderWriter class in Python provides an efficient way to read and write data to Excel sheets. This guide will help you understand how to use the writeCellData method in this class.

To use the writeCellData method in Python, you need to identify the specific cell where you want to write data. Let's say, for example, you want to write the value Sr. Analyst into a cell in an Excel sheet.

First, identify the sheet where you want to write the data. In this case, the sheet name is Sheet1.

Next, determine the row where you want to write your data. In this example, Sr. Analyst is to be written in row number 6. To better identify the row, we use the data from the first column as a unique identifier (make sure the data of the 1st column of the sheet should be uniquely identifier data).

Then, identify the column header where you want to write your data. In this scenario, the column header name is Job Title.

Finally, determine the data you want to write. In this case, the data is Sr. Analyst.

With these parameters - the sheet name, the unique identifier from the first column, the column header name, and the data to be written - you can use the writeCellData method to write the data. The syntax would be:

excel_reader_writer.writeCellData('SheetName', 'UniqueIdentifierInRow', 'ColumnHeaderName', 'WritableData')

In this code, replace 'SheetName', 'UniqueIdentifierInRow', 'ColumnHeaderName', and 'WritableData' with your actual values (Sheet1, E5, Job Title, and Sr. Analyst, respectively) when you use this method. This will write the data into the specified cell. Please ensure that you have write permissions for the Excel file.

Python Usage

Here's how you can use the writeCellData method in Python:

# import the ExcelSheetIO library package
from ExcelSheetIO import ExcelReaderWriter

# Create an instance of the ExcelReaderWriter class
excel_reader_writer = ExcelReaderWriter('path_to_your_excel_file')

# Use the writeCellData method
excel_reader_writer.writeCellData('SheetName', 'UniqueIdentifierInRow', 'ColumnHeaderName', 'WritableData')

In the above code, replace 'path_to_your_excel_file', 'SheetName', 'UniqueIdentifierInRow', 'ColumnHeaderName', and 'WritableData' with the path to your Excel file, the name of the sheet in the Excel file, the unique identifier from the first column, the name of the column header, and the order number, respectively.

Robot Framework Usage

If you're using Robot Framework, you can create a custom keyword that uses the writeCellData method. Here's how you can do it:

*** Settings ***
Library    ExcelSheetIO.ExcelReaderWriter    path_to_your_excel_file

*** Keywords ***
Keyword For Write Data in Excel Sheet
    [Arguments]    ${sheetName}    ${UniqueIdentifierInRow}    ${ColumnHeaderName}    ${WritableData}
    Write Cell Data    ${sheetName}    ${UniqueIdentifierInRow}    ${ColumnHeaderName}    ${WritableData}

*** Test Cases ***
Test case for write data in excel sheet
    Keyword For Write Data in Excel Sheet    Sheet1    E6    Job Title    Software Developer
    [Tags]    write     test

Breakdowns

Let's break down how the writeCellData method works internally, in a more understandable way :

Creating a Copy : The method starts by creating a copy of the original Excel file. This is done to ensure that the original file remains unchanged until all write operations are successfully executed. The copy is stored in a folder named CopyFolder and is given a temporary file name like *_Temp*.xlsx. Make sure add CopyFolder in .gitignore in your project.

Writing Data : The method then performs the write operation on this temporary Excel file. It writes data to a specific cell in an Excel sheet. The cell is identified by the sheet name, the unique identifier from the first column (which should be unique), and the column header name.

Saving Changes : After all write operations are completed, the method saves the changes made to the temporary file.

Updating the Original File : The method then transfers the data from the temporary file back into the original file. This ensures that the original file is updated with all the new data.

Cleaning Up : Finally, the method removes the temporary Excel file after all operations are finished. This is done to free up storage space and maintain cleanliness in your file system.

By using this method, you can efficiently write data to an Excel file while ensuring the integrity of the original file until all operations are successfully completed. It's a safe and efficient way to manipulate Excel data in Python. Please ensure that you have write permissions for the Excel file.

Method : `Remove Temporary TestData Files`

The removeTemporaryTestDataFiles method is a utility function in this Python script that is designed to clean up temporary Excel files that may have been created during the execution of the script. This method is particularly useful in maintaining a clean workspace and ensuring that temporary files do not consume unnecessary storage. Make sure add CopyFolder in .gitignore in your project.

How it works:

Locate the Current Directory : The method first identifies the directory where the Python script is currently located.

Construct the Path It then constructs the path to a subdirectory named 'CopyFolder' within the current directory.

Iterate Over Files : The method iterates over all files present in the 'CopyFolder' subdirectory.

Identify and Remove Temporary Files : If a file name contains the string 'temp', the method attempts to remove (delete) the file.

Error Handling : If an error occurs during the file removal process, the method captures the error and logs it using the logger.error function.

Python Usage

Here's how you can use the removeTemporaryTestDataFiles method in Python:

# import the ExcelSheetIO library package
from ExcelSheetIO import ExcelReaderWriter

# Create an instance of the ExcelReaderWriter class
excel_reader_writer = ExcelReaderWriter('path_to_your_excel_file')

# Use the removeTemporaryTestDataFiles method
excel_reader_writer.removeTemporaryTestDataFiles()

Robot Framework Usage

If you're using Robot Framework, you can create a custom keyword that uses the removeTemporaryTestDataFiles method. Here's how you can do it:

*** Settings ***
Library    ExcelSheetIO.ExcelReaderWriter    .\\Data\\Employee.xlsx

*** Keywords ***
Keyword For Remove Temporary Test Data Files
    [Arguments]
    Remove Temporary Test Data Files


*** Test Cases ***
Test case for remove temporary data files in excel sheet
    Keyword For Remove Temporary Test Data Files
    [Tags]    remove     test

This will remove all files in the CopyFolder subdirectory of the current directory that contain temporary file name like *_Temp*.xlsx.

Method : `Read All Data In Given Column`

The readAllDataInGivenColumn method is a utility function in this Python script that is designed to read all non-null data for a particular column from a given sheet. This method is particularly useful in extracting specific data from a sheet for further processing or analysis.

How it works:

Check Sheet Existence : The method first checks if the given sheet name exists in the data.

Initialize Column Data List : If the sheet exists, it initializes an empty list to store the column data.

Iterate Over Test Cases : The method then iterates over all test cases in the sheet.

Append Column Data : If the given column name exists in the test case and its value is not None, it appends the value to the column data list.

Return Column Data : If the column data list is not empty after the iteration, it returns the list. If the column data list is empty, it returns a message indicating that no data was found in the given column in the given sheet.

Handle Non-existent Sheet : If the sheet does not exist in the data, it returns a message indicating that the sheet was not found.

Python Usage:

Here's how you can use the readAllDataInGivenColumn method in Python:

# import the ExcelSheetIO library package
from ExcelSheetIO import ExcelReaderWriter

# Create an instance of the ExcelReaderWriter class
excel_reader_writer = ExcelReaderWriter('path_to_your_excel_file')

# Use the readAllDataInGivenColumn method, it'll return data as a list
column_data = excel_reader_writer.readAllDataInGivenColumn('SheetName', 'ColumnHeaderName')

Robot Framework Usage:

In Robot Framework, you can call this method in a similar way. First, you need to create a keyword that calls this method, and then you can use this keyword in your test case:

*** Settings ***
Library    ExcelSheetIO.ExcelReaderWriter    .\\Data\\Employee.xlsx

*** Keywords ***
Keyword for read all data in given column in excel sheet
    [Arguments]    ${sheetName}    ${columnHeaderName}
    ${column_data}=    Read All Data In Given Column    ${sheetName}    ${columnHeaderName}
    Log To Console    ${\n}${column_data}

*** Test Cases ***
Test case for read all data in given column in excel sheet
    Keyword for read all data in given column in excel sheet    Sheet1    Job Title
    [Tags]    read2     test

Method : `Read All Data In Given Row`

The readAllDataInGivenRow method is a utility function in this Python script that is designed to fetch all data for a particular row from a given sheet. This method is particularly useful in extracting specific data from a row for further processing or analysis.

How it works:

Check Sheet Existence : The method first checks if the given sheet name exists in the data.

Check Test Case Existence : If the sheet exists, it checks if the given test case name exists in the sheet.

Retrieve Row Data : If the test case exists, it retrieves all data for the test case. This data is a dictionary where the keys are column names and the values are cell values.

Return Row Data : It returns this dictionary, which represents all data in the given row.

Handle Non-existent Test Case : If the test case does not exist in the sheet, it returns a message indicating that the test case was not found in the given sheet.

Handle Non-existent Sheet : If the sheet does not exist in the data, it returns a message indicating that the sheet was not found.

Python Usage :

Here's how you can use the readAllDataInGivenRow method in Python:

# import the ExcelSheetIO library package
from ExcelSheetIO import ExcelReaderWriter

# Create an instance of the ExcelReaderWriter class
excel_reader_writer = ExcelReaderWriter('path_to_your_excel_file')

# Use the readAllDataInGivenRow method, it'll return data as a dictionary
row_data = excel_reader_writer.readAllDataInGivenRow('SheetName', 'ColumnHeaderName')

Robot Framework Usage :

In Robot Framework, you can call this method in a similar way. First, you need to create a keyword that calls this method, and then you can use this keyword in your test case:

*** Settings ***
Library    ExcelSheetIO.ExcelReaderWriter    .\\Data\\Employee.xlsx

*** Keywords ***
Keyword for read all data in given row in excel sheet
    [Arguments]    ${sheetName}    ${UniqueIdentifierInRow}
    ${row_data}=    Read All Data In Given Row    ${sheetName}    ${UniqueIdentifierInRow}
    Log To Console    ${\n}${row_data}

*** Test Cases ***
Test case for read all data in given row in excel sheet
    Keyword for read all data in given row in excel sheet    Sheet1    E6
    [Tags]    read3     test

Method : `Modify Color And Font Of The Cell`

The modifyColorAndFontOfTheCell method is a utility function in this Python script that is designed to modify the color and font of a specific cell in an Excel sheet. This method is particularly useful for highlighting specific test cases in an Excel sheet, such as failed test cases in a test suite.

How it works:

Create a Temporary Copy : The method first creates a temporary copy of the original Excel file.

Load the Workbook : It then loads the workbook from this temporary file and selects the specified sheet.

Find the Specific Cell : The method iterates over the rows in the sheet until it finds the row with the specified test case name. Then, it iterates over the columns in this row until it finds the specified column name.

Modify the Cell : Once the specific cell is found, it changes the cell's fill color and font color as per the parameters.

Save and Close the Workbook : Finally, it saves and closes the workbook.

In the below image for the cell value Software Developer, modified the cell color as pink, font color as red and font type as BOLD using this method.

Python Usage:

Here's how you can use the modifyColorAndFontOfTheCell method in Python:

# import the ExcelSheetIO library package
from ExcelSheetIO import ExcelReaderWriter

# Create an instance of the ExcelReaderWriter class
excel_reader_writer = ExcelReaderWriter('path_to_your_excel_file')

# Use the modifyCellStyles method to create a CellStyler object for a specific cell in a given sheet.
# Replace 'sheetName', 'uniqueIdentifierInRow', 'columnHeaderName' with your actual data.
# Then, use the set_cell_color, set_font_color, set_font_type, and font_size methods to set the cell's styles.
# The color parameters should be hex color codes.
# The font family should be like 'Arial', 'Bradley Hand ITC' and etc.
# The font type can be 'bold', 'italic', 'underline', or 'double underline'.
# The font size should be an integer.
# The apply_styles method applies the styles to the cell.
# Finally, the save_changes method saves the changes to the Excel file.

excel_reader_writer.modifyCellStyles('sheetName', 'uniqueIdentifierInRow', 'columnHeaderName').set_cell_color('salmon').set_font_color('green').set_font_family('Arial').set_font_styles('bold', 'italic', 'underline', 'double underline').set_font_size(11).apply_styles().save_changes()

# or

excel_obj = e.modifyCellStyles('Sheet1', 'E7', 'Full Name').set_cell_color('salmon').set_font_color('green').set_font_family('Arial').set_font_styles('bold', 'italic', 'underline').set_font_size(11)
excel_obj.apply_styles().save_changes()

Robot Framework:

In Robot Framework, you can call this method in a similar way. First, you need to create a keyword that calls this method, and then you can use this keyword in your test case:

*** Settings ***
Library    ExcelSheetIO.ExcelReaderWriter    .\\Data\\Employee.xlsx

*** Keywords ***
Modify Cell Styles
    [Arguments]    ${sheet_name}    ${unique_identifier_in_row}    ${column_header_name}    ${cell_color}    ${font_color}  ${font_family}    ${font_type}    ${font_size}
    ${excel_reader_writer}=    Get Library Instance    ExcelSheetIO.ExcelReaderWriter
    ${excel_reader_writer}.modifyCellStyles(${sheet_name}, ${unique_identifier_in_row}, ${column_header_name}).set_cell_color(${cell_color}).set_font_color(${font_color}).set_font_family(${font_family}).set_font_styles(${font_type}).set_font_size(${font_size}).apply_styles().save_changes()

*** Test Cases ***
Test Modify Cell Styles
    Modify Cell Styles    Sheet1    E6    Job Title    salmon    green  Arial    bold, italic, underline, double underline    12
    [Tags]    color1     test
    # Replace 'Sheet1', 'E6', 'Job Title', 'salmon', 'green', 'bold, italic, underline, double underline', and '12' with your sheet name, unique identifier in row, column header name, cell color, font color, font type, and font size respectively

Method : `Reset Cell Styles`

The resetCellStyles method is part of the ExcelReaderWriter class. This method resets the styles of a specific cell in an Excel sheet to default values.

How it works:

This method creates a CellStyler object for the specified cell, identified by its sheet name, unique identifier in the row, and column header name. It then sets the cell color to white, the font color to black, the font family to Calibri, the font style to normal, and the font size to 11. After applying these styles, it saves the changes to the Excel file.

Python Usage:

Here's how you can use the resetCellStyles method in Python:

# import the ExcelSheetIO library package
from ExcelSheetIO import ExcelReaderWriter

# Create an instance of the ExcelReaderWriter class
excel_reader_writer = ExcelReaderWriter('path_to_your_excel_file')

# Use the resetCellStyles method to create a CellStyler object for a specific cell in a given sheet.
# Replace 'sheetName', 'uniqueIdentifierInRow', 'columnHeaderName' with your actual data.
excel_reader_writere.resetCellStyles('sheetName', 'uniqueIdentifierInRow', 'columnHeaderName')

Robot Framework:

In Robot Framework, you can call this method in a similar way. First, you need to create a keyword that calls this method, and then you can use this keyword in your test case:

*** Settings ***
Library    ExcelReaderWriter    .\\Data\\Employee.xlsx

*** Keywords ***
Keyword for reset cell styles in excel sheet
    [Arguments]    ${sheetName}    ${UniqueIdentifierInRow}     ${columnHeaderName}
    Reset Cell Styles    ${sheetName}    ${UniqueIdentifierInRow}     ${columnHeaderName}

*** Test Cases ***
Testcase For Reset Cell Styles
    Keyword for reset cell styles in excel sheet    Sheet1    E7    Full Name
    [Tags]    color2     test

Instagram Clone Live App

Soumyajit Pan — Fri, 18 Aug 2023 12:40:22 +0000

You can see the Live Demo from here 👇
https://instagram-soumyajitpan.vercel.app/

For this project, I have used these libraries,
▶️ React JS
▶️ Firestore and Firebase Database
▶️ Firebase Email Authentication
▶️ Styled-Components for styling

Signup Page
User have to Signup/Create new account

Login Page
User have to login to their account

Home Page
After Login User can see the Home Page

Notification
User can see all notifications when other users do comments, likes, requests for messages, follows

Comments of random post
User can comment on any user's post

Send post via Messenger
Any user can send any posts via messenger

Insta Profile Page
User can see their own profile like this below image

Insta Profile Edit Mode
After click on Edit Profile button, user can see their profile in edit mode, then user can change their profile data.

Insta Profile Delete Mode
After click on settings icon, user can see delete profile button, then user can delete their profile data.

Watching Other User's Story
When any user can see other user's story by clicking on individual story, it's look like below.

Watching Self Story
When any user can see self story, it's look like below image.

Instagram Messenger
Instagram Messenger looks like below image.

Tic-tac-toe Multiplayer Game

Soumyajit Pan — Sun, 04 Jun 2023 07:38:20 +0000

You can see the Demo from here 👇
https://tictactoe-multiplayer29.netlify.app

Presentation Video

Login Page

Google Authentication*

Page after login

2 Users Page

Lobby after Entered same room

Chat in Lobby

Game

Chat during Game

Tech Stack

React JS
Firestore and Firebase Realtime Database
Firebase Google Authentication
Styled-Components for styling

Any suggestions are welcomed!
Thanks For Reading😄

Swag Lab Automation Testing Project [Selenium, Java]

Soumyajit Pan — Mon, 29 May 2023 19:10:41 +0000

For this project, I developed a model and I have used these libraries,
▶️ Selenium
▶️ Java

Presentation Video

Any suggestions are welcomed!
Thanks For Reading😄

Infy-Verse [A all in one platform for mail+chat+meeting+calender]

Soumyajit Pan — Mon, 29 May 2023 16:35:11 +0000

You can see the Demo from here 👇
https://infy-verse.netlify.app/

For this project, I have used these libraries,
▶️ React JS (CRA)
▶️ Firebase Authentication
▶️ Firestore Database
▶️ Firebase Realtime Database
▶️ WebRtc for Video Calling
▶️ Styled-Components for styling

Presentation Video

youtube.com

Google Authentication Login Page

After Login Calendar Page

Mailing Page

Chatting Page

Meeting Page

Theme Changer

Profile Settings Page

Any suggestions are welcomed!
Thanks For Reading😄

Netflix UI Clone

Soumyajit Pan — Mon, 29 May 2023 16:11:35 +0000

You can see the Demo from here 👇
https://netflix-clone-soumyajitpan.vercel.app

Signup Page

Signin Page

Home Page

Movie Page

My List Page

Video Player

Video Options

Video Picture In Picture Mode

Tech Stack

React JS
TMDB API
Firestore Database
Styled-Components for styling

Presentation Video

Any suggestions are welcomed!
Thanks For Reading😄

Sorting Visualizer [ A web app to visualize sorting algorithm ]

Soumyajit Pan — Mon, 29 May 2023 07:21:04 +0000

You can see the Demo from here 👇
https://sorting-visualizer-29.netlify.app/

For this project, I have used these libraries,
▶️ React JS
▶️ Styled-Components for styling

Presentation Video

Any suggestions are welcomed!
Thanks For Reading😄

Stock Tracker [ A web app to track the real-time stock market data ]

Soumyajit Pan — Wed, 26 Apr 2023 07:03:11 +0000

You can see the Demo from here 👇
https://stocktracker0.netlify.app/

For this project, I have used these libraries,
▶️ React JS (CRA)
▶️ High Chart to display Graph
▶️ Styled-Components for styling
▶️ Real-time stock market data API

Presentation Video

Any suggestions are welcomed!
Thanks For Reading😄

Forem: Soumyajit Pan

Milligram-Connect Social Media Application

Splash Screen

Login Screen

Home Screen

Search Screen

Create Post Screen

Notification Screen

Messaging Screen

Settings Screen

Profile Screen

Download and Install

Tech Stack Used

ExcelSheetIO

Installation Guide

Method : Read Data From Excel Sheet

Python Usage

Robot Framework Usage

Method : Write Data In Excel Sheet

Python Usage

Robot Framework Usage

Breakdowns

Method : Remove Temporary TestData Files

How it works:

Python Usage

Robot Framework Usage

Method : Read All Data In Given Column

How it works:

Python Usage:

Robot Framework Usage:

Method : Read All Data In Given Row

How it works:

Python Usage :

Robot Framework Usage :

Method : Modify Color And Font Of The Cell

How it works:

Python Usage:

Robot Framework:

Method : Reset Cell Styles

How it works:

Python Usage:

Robot Framework:

Instagram Clone Live App

Tic-tac-toe Multiplayer Game

Swag Lab Automation Testing Project [Selenium, Java]

Infy-Verse [A all in one platform for mail+chat+meeting+calender]

Netflix UI Clone

Sorting Visualizer [ A web app to visualize sorting algorithm ]

Stock Tracker [ A web app to track the real-time stock market data ]

Method : `Read Data From Excel Sheet`

Method : `Write Data In Excel Sheet`

Method : `Remove Temporary TestData Files`

Method : `Read All Data In Given Column`

Method : `Read All Data In Given Row`

Method : `Modify Color And Font Of The Cell`

Method : `Reset Cell Styles`