Search Results for "database in excel (vba)"
Sort By:
Showing 29 open source projects for "database in excel (vba)"
View related business solutions-
$300 in Free Credit Across 150+ Cloud ServicesStart your project in minutes. After credits run out, 20+ products include free monthly usage. Only pay when you're ready to scale with Google Cloud.
-
Train ML Models With SQL You Already KnowBuild and deploy ML models using familiar SQL. Automate data prep with built-in Gemini. Query 1 TB and store 10 GB free monthly.
-
1
SQL Explorer
Easily share data across your company via SQL queries
...It is a Django-based application that you can add to an existing Django site, or use as a standalone business intelligence tool. Quickly write and share SQL queries in a simple, usable SQL editor, preview the results in the browser, share links, download CSV, JSON, or Excel files (and even expose queries as API endpoints, if desired), and keep the information flowing! Comes with support for multiple connections, to many different SQL database types, a schema explorer, query history (e.g. lightweight version control), a basic security model, in-browser pivot tables, and more. SQL Explorer values simplicity, intuitive use, unobtrusiveness, stability, and the principle of least surprise. ... -
2
AI Data Science Team
An AI-powered data science team of agents
AI Data Science Team is a Python library and agent ecosystem designed to accelerate and automate common data science workflows by modeling them as specialized AI “agents” that can be orchestrated to perform tasks like data cleaning, transformation, analysis, visualization, and machine learning. It provides a modular agent framework where each agent focuses on a step in the typical data science pipeline — for example, loading data from CSV/Excel files, cleaning and wrangling messy datasets, engineering predictive features, building models with AutoML, connecting to SQL databases, and producing visual outputs — all driven by natural language or programmatic instructions. The project includes ready-to-use applications that showcase these agents in action, such as an exploratory data analysis copilot that generates reports, a pandas data analyst that combines wrangling and plotting, and SQL database agents that can query business databases and output results directly. -
3
DiLu Converter
A powerful Import and Export tool between Excel and Database
DiLu Converter is a powerful Excel import and export tool that supports more than 10 databases such as MySQL, Oracle, SQL Server, PostgreSQL and so on. The supported file formats include xls, xlsx, xlsm, xlsb, csv, txt, xml, json, and dbf. Its native user interface brings users a comfortable experience of simplified Excel import and export, making Excel import and export easier than ever before. Whether you want one-click, batch, and personalized import and export, or want to use... -
4
File Sorter for Photographers
Organize files/images from a csv or xlsx file.
A user-friendly application to efficiently sort all types of files from a source folder into a destination folder based on a list of filenames provided in an Excel or CSV file. -
Cut Cloud Costs with Google Compute EngineSave on compute costs with Compute Engine. Reduce your batch jobs and workload bill 60-91% with Spot VMs. Compute Engine's committed use offers customers up to 70% savings through sustained use discounts. Plus, you get one free e2-micro VM monthly and $300 credit to start.
-
5
Data Preprocessing Automate
Data Preprocessing Automation: A GUI for easy data cleaning & visualiz
Data Preprocessing Automation is a Python-based GUI application designed to simplify and automate data preprocessing tasks. It allows users to upload Excel files, automatically handle missing values, remove duplicates, and detect and remove outliers using statistical methods. The application provides data visualization tools, including box plots for distribution analysis and scatter plots for exploring relationships between variables. Users can download the processed data for further... -
6
sqlitebiter
A CLI tool to convert CSV / Excel / HTML / JSON / Jupyter Notebook
A CLI tool to convert CSV / Excel / HTML / JSON / Jupyter Notebook / LDJSON / LTSV / Markdown / SQLite / SSV / TSV / Google-Sheets to an SQLite database file. -
7
asammdf
Fast Python reader and editor for ASAM MDF / MF4 (Measurement Format)
*asammdf* is a fast Python parser and editor for ASAM (Associtation for Standardisation of Automation and Measuring Systems) MDF / MF4 (Measurement Data Format) files. It supports MDF versions 2 (.dat), 3 (.mdf) and 4 (.mf4). *asammdf* works on Python 2.7, and Python >= 3.4 -
8
Secure Password Manager
Application to generate, store, and manage passwords with encryption
Secure Password Manager is a portable application designed to securely generate, store, and manage passwords using advanced encryption techniques to protect sensitive data. This practical, efficient, and simple application ensures that your passwords are always safe and easily accessible. To learn more, visit our website at https://securepassapp.netlify.app/ Key features include: Robust Password Generation: Create strong passwords using a combination of letters, numbers, and special... -
9
csv2odf
csv2odf can convert csv data to formatted spreadsheets and documents.
csv2odf can create business intelligence reports from csv data sources with output to ods, odt, html, xlsx, or docx documents. It uses a template file that you design to control the layout, fonts, and colors. Just query your database with output to csv (or tsv), then use csv2odf to insert the data into your template to produce a nice looking formatted output. It is a command line tool and you can automate the generation of reports by using scripts and cron. It can be used to create spreadsheets and documents for LibreOffice, OpenOffice, Microsoft Office Excel and Word. ... -
Gemini 3 and 200+ AI Models on One PlatformBuild generative AI apps with Vertex AI Studio. Switch between models without switching platforms.
-
10
LibreOffice
A free and powerful office suite
LibreOffice is a free and powerful office suite, and a successor to OpenOffice. Its clean interface and feature-rich tools help you unleash your creativity and enhance your productivity. LibreOffice is Free and Open Source Software (FOSS) – development is open to new talent and new ideas, and our software is tested and used daily by a large and devoted user community. Your documents will look professional and clean, regardless of their purpose: a letter, a master thesis, a brochure,... -
11
MySQL 2 Excel Exporter 3-105 [I.S.A]
MySQL 2 Excel: Exporter 3-105 [Improved.Simplified.Alternative]
'MySQL2Excel_Exporter' is an desktop application developed using python 3.6.8 and other add-on libaries. The application exports MySql tables as a excel file. MySQL2Excel_Exporter has two parts: 1) Export - converts all records in mySQL table into excel file 2) Export Filter - converts selected recorerds in mySQL table into excel file Compatible only for windows OS. -
12
Alfi Face
Face Recognition based Attendance System for school, college...
ALFI FACE uses facial recognition technology to record the attendance through a digital camera that detects and recognizes faces and compare the faces with students’ faces images stored in faces database. Once the recognized face matches a stored image, attendance is marked in attendance database for that person. Note: While adding a new student you have to click on" Train the Recognizer" button . In excel sheet dates are "#" so that no one can change the dates. -
13
The purpose of the current project is the development of a potentially open-source platform that would provide the capability to conduct virtual bioequivalence trial simulations. Ideally, this user-friendly platform will provide the user with many user-defined capabilities. Algorithm implementation for population pharmacokinetic analysis: The current project describes the marriage between PBPK modeling and population-based statistical analysis. The latter is necessary for parameter...
-
14
QAL
Query Abstraction Layer
Project has moved to: https://github.com/OptimalBPM/qal QAL is a collection of libraries for mining, transforming and writing data from and to a number of places. Sources and destinations include different SQL and NoSQL backends, file formats like .csv, XML and excel. Even untidy HTML web pages. It has a database abstraction layer that supports connectivity to Postgres, MySQL, DB2, Oracle, MS SQL server. JSON and MongoDB is coming. It uses XML/JSON formats(self-generated SQL schemas) for representing queries, transformation and merging, making it scriptable. This means that QAL can be backend agnostic about a subset of SQL features and data types. ... -
15
MaeBlok
Rapid web development tool for business applications
You assemble *blocks* in your django template, with each block wired to a tastypie resource, which in turn is mapped to a django model. Each *block* will reside in a dijit ContentPane which you must define in your template. You have a choice of 2 layouts for each *block*, Form or Grid based. Form displays a single record in either a 1, 2 or 3 column layout while Grid displays many rows in a spreadsheet like grid. You can perform edits in place on fields in both layouts. You can... -
16
ExcelPython
An interface for calling Python from Excel
ExcelPython is a lightweight, easily distributable library for interfacing Excel and Python. It enables easy access to Python scripts from Excel VBA, allowing you to substitute VBA with Python for complex automation tasks which would be facilitated by Python's extensive standard library. v2 is a major rewrite of ExcelPython! - see GitHub site for more details. LICENSE NOTICE MIT License, please see new GitHub site for more details. -
17
Protospacer
Rapid gRNA design and validation for CRISPR
...From here, users are able to evaluate potential off targeting, to export results in FASTA format or tabulated (e.g. for Microsoft Excel), and to connect to the Integrative Genomics Viewer (IGVref) and view target-sites in the context of genomic annotations, amino acid translations, and HT-Seq data (for off-target validation). We provide online video tutorials and a toy database from our main website. -
18
OpenNumismat
Coin collecting software for organize and manage your own catalogue
This project has been migrated to github - please visit http://opennumismat.github.io OpenNumismat is a handy and reliable application aimed at coin lovers, numismatists or amateurs looking to create a numismatics collection. With OpenNumismat, you will be able to create, organize and manage your own coin catalogue with detailed description and photos for each of the items. -
19
windEPAF
Import and Export EPAFs to Ellucian/SunGard Banner
This application allows bulk import and exports between Banner EPAFs and Excel spreadsheets. Despite what your sales rep told you, doing EPAFs in Excel and then importing them into Banner is no easy task. Each EPAF can have a variable number of rows in variable number of tables and transaction numbers must be carefully kept in sync among all of these rows and records. WindEPAF takes this difficult and error-prone process and makes it easy. -
20
-
21
OxygenOffice Professional(OOOP, O2OP)is an enhanced version of free OpenOffice.org what is a multi-platform office productivity suite.OxygenOffice Professional contains more extras like templates, cliparts, samples, fonts and VBA support. Get 3.2.1
-
22
Excel Spy
An excel search application to search in multiple excel files
Excel Spy is GUI application which is intended for office use . It features searching in multiple excel files (.xls format) and save search results instantly . Files containing results can immediately be accessed directly for editing. -
23
gLib
A very simple standalone library management application.
gLib helps you manage information on your library's books and members. The program has several filter options that allow you quickly and easily find the information you need. Once you've made a list, you can export it to a spreadsheet friendly format with the click of a button. -
24
Python Spreadsheet Middleman. Aims to be the best cross platform--cross application python spreadsheet module for any spreadsheet program. Currently supports Excel and Gnumeric. Made to be easy to use and newbie friendly. Documentation in zip!
-
25
Generating Excel 97+ files with Python 2.4+ (need decorators), importing Excel 95+ files, support for UNICODE in Excel files, using variety of formatting features and printing options, Excel files and OLE2 compound files dumper. No need in Windows/COM
