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.

Enable OpenXML for VSTO add-ins

Tools to automate data input from excel to website forms

Stop taking your breath away merging excel files by hand 😉

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

A Python project to automate human resource-related tasks

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…

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

🛠️ 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

💡 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等多项功能，持续不定期更新。

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

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.

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

Simple Monte Carlo Add-in for Excel using C# and Excel-DNA

Promise date verification automation utility

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

This is a demo .py file, In this code , I'm creating a pivot table using win32 to launch an excel app instance and performing the required steps.

Python Programs for combining and renaming excel tabs