Automates Excel workflows on Windows using Python's win32com library to create pivot tables, apply formulas, and format reports directly within Excel.

We can fetch the NSE live data using API from the excel itself, built python exe based application which is responsible to fetch live market data from NSE India such as LiveMarket, PreMarket, NseHolidays, NseFNO, Symboldata, and so on... Here, we automate excel itself for live data extraction.

Excel tools and VBA snippets for focused business tasks

Dropshipping Product Research Bot is an automation tool built with UiPath that simplifies the dropshipping process by searching, filtering, and analyzing product data from Amazon and BestBuy. It generates a comprehensive report and automates email delivery, making product research more efficient for e-commerce professionals.

Enable OpenXML for VSTO add-ins

Excel UDF Automation Add-In with Installer in vb.net

Tools to automate data input from excel to website forms

💡 You can easily extract photos 📸 from an Excel 📊 cell using this Python script. But wait, there's more! These photos can also be saved with names created by given cells. To discover how to make the most of this powerful tool, follow the steps below or watch the video guide. Happy extracting! ✨🔍

这些是我在工作中编写的VBA程式，包括BI报告自动化/User Form等多项功能，持续不定期更新。

A Framework for Excel based reports to allow rapid & simple automation

🛠️ Python 🐍 script automates the extraction of product pricing details from the AmerisourceBergen 🌐 website https://abcorder.amerisourcebergen.com By inputting your username, password, and National Drug Code (NDC) codes and the 📜 script navigates the website and retrieves the 💰 Average Wholesale Price (AWP) and Acquisition Cost (AC) 📊 data

Office Script for Microsoft Excel, Office 365. Searches for a suffix parameter in all sheets in a file & extracts data using lookups. Scaleable for any dataset.

Stop taking your breath away merging excel files by hand 😉

Practice work project on the 2nd year of studies at ITMO

OUT OF DATE VERSION-CURRENT VERSION IS PINNED TO MY FRONT PAGE.This is a python app built to automate excel data from Zoom Info. It uses the Pandas module to automate excel data entry as well as the TKinter module for a rudimentary front end. THIS IS IN NO WAY SHAPE OR FORM the most efficient way to implement this however it is a proof of concep…

Allocate raw materials into manufacturing lots using an inventory report and user specified finished good build priorities.

A Robotic Process Automation created to generate a summary report and email it using Python

Utility for merging data into the supply line order status report.

This repository provides a tool to convert JSON data to Excel format (.xlsx). It allows you to easily transform structured JSON data into a well-organized spreadsheet for better analysis and visualization.

Python Programs for combining and renaming excel tabs