Python code to read Blob Files

 

from azure.storage.blob import BlobServiceClient
import pandas as pd

# Azure Blob Storage connection string
connection_string = 'Connection String'

# Initialize the BlobServiceClient
blob_service_client = BlobServiceClient.from_connection_string(connection_string)

# Container names
containers = ['b2barchive', 'b2bbadfiles']

# Dictionary to store DataFrames for each container
dfs = {}

for container_name in containers:
    # Get the container client
    container_client = blob_service_client.get_container_client(container_name)

    # List all blobs in the container
    print(f"Listing blobs in the container: {container_name}")
    blob_list = container_client.list_blobs()

    # Create a list to store blob names and last modified dates
    blob_data = []

    for blob in blob_list:
        print(f"Blob Name: {blob.name}, Last Modified: {blob.last_modified}")
        blob_data.append({'Blob Name': blob.name, 'Last Modified': blob.last_modified})

    # Create a DataFrame from the list of blob data
    dfs[container_name] = pd.DataFrame(blob_data)

# Specify the full path to save the Excel file
output_excel_file = r'C:\Users\kar\Desktop\B2B File Details\blob_list.xlsx'

# Write the DataFrames to separate sheets in an Excel file
with pd.ExcelWriter(output_excel_file) as writer:
    for container_name, df in dfs.items():
        df.to_excel(writer, sheet_name=container_name, index=False)

print(f"Blob lists have been written to {output_excel_file}")

To find your Azure Storage account key, follow these steps:
Steps to Find Your Azure Storage Account Key
Log in to the Azure Portal:
Go to the Azure Portal.
Navigate to Your Storage Account:
In the left-hand menu, click on "Storage accounts" to see a list of your storage accounts.
Click on the storage account you want to use (e.g., strorageaccountanme).
Access the Access Keys:
In the storage account's menu, under the "Settings" section, click on "Access keys".
You will see two access keys (key1 and key2) and their corresponding connection strings.
Copy the Account Key:
Copy one of the account keys (either key1 or key2). You can use this key in your connection string.
Example Connection String
Once you have your account key, you can construct your connection string. For example, if your account key is , your connection string would look like this:
connection_string = 'DefaultEndpointsProtocol=https;AccountName=strorageaccountanme;AccountKey=acceountkey