🔍 Code Extractor

Search Components

Full-Text: Fast keyword matching | Semantic: AI-powered understanding of intent (finds similar concepts)

Search Results for "excel"

Found 48 matching component(s)

  • function create_excel_report_improved

    Creates a multi-sheet Excel report from warranty data, including main report, summary view, complete data, references, and statistics sheets with auto-formatted columns.

    File: /tf/active/vicechatdev/improved_convert_disclosures_to_table.py

    excel reporting data-export pandas multi-sheet
  • function main_v9

    Orchestrates the conversion of an improved markdown file containing warranty disclosures into multiple tabular formats (CSV, Excel, Word) with timestamp-based file naming.

    File: /tf/active/vicechatdev/improved_convert_disclosures_to_table.py

    file-conversion markdown-processing warranty-data csv-export excel-export
  • class RegulatoryExtractor

    A class for extracting structured metadata from regulatory guideline PDF documents using LLM-based analysis and storing the results in an Excel tracking spreadsheet.

    File: /tf/active/vicechatdev/reg_extractor.py

    pdf-extraction regulatory-documents llm-extraction ocr data-extraction
  • function create_excel_report

    Creates a multi-sheet Excel report from warranty data, including main report, summary view, complete data, and statistics sheets with auto-formatted columns.

    File: /tf/active/vicechatdev/convert_disclosures_to_table.py

    excel reporting data-export pandas openpyxl
  • function main_v16

    Converts a markdown file containing warranty disclosure data into multiple tabular formats (CSV, Excel, Word) with timestamped output files.

    File: /tf/active/vicechatdev/convert_disclosures_to_table.py

    markdown-conversion data-extraction report-generation csv-export excel-export
  • class DocumentProcessor_v4

    Process different document types for RAG context extraction

    File: /tf/active/vicechatdev/offline_docstore_multi_vice.py

    class documentprocessor
  • class DocumentConverter

    A class that converts various document formats (Word, Excel, PowerPoint, OpenDocument, Visio) to PDF using LibreOffice's headless conversion capabilities, with support for parallel processing and directory structure preservation.

    File: /tf/active/vicechatdev/pdfconverter.py

    document-conversion pdf libreoffice batch-processing parallel-processing
  • class ReferenceManager_v4

    Manages extraction and formatting of references for LLM chat responses. Handles both file references and BibTeX citations, formatting them according to various academic citation styles.

    File: /tf/active/vicechatdev/OneCo_hybrid_RAG.py

    class referencemanager
  • class PDFConverter

    A class that converts various document formats (Word, PowerPoint, Excel, images) to PDF format using LibreOffice and ReportLab libraries.

    File: /tf/active/vicechatdev/msg_to_eml.py

    pdf conversion document-processing file-conversion libreoffice
  • class DocumentProcessor_v5

    Process different document types for RAG context extraction

    File: /tf/active/vicechatdev/offline_docstore_multi.py

    class documentprocessor
  • function view_document

    Flask route handler that serves documents for in-browser viewing by accepting a file path as a query parameter, validating security constraints, and returning the file with appropriate MIME types and CORS headers.

    File: /tf/active/vicechatdev/docchat/app.py

    flask file-serving document-viewer security path-validation
  • class DocChatRAG

    Main RAG engine with three operating modes: 1. Basic RAG (similarity search) 2. Extensive (full document retrieval with preprocessing) 3. Full Reading (process all documents)

    File: /tf/active/vicechatdev/docchat/rag_engine.py

    class docchatrag
  • class DocumentProcessor_v7

    Process different document types for indexing

    File: /tf/active/vicechatdev/docchat/document_indexer.py

    class documentprocessor
  • class DocumentIndexer

    A class for indexing documents into ChromaDB with support for multiple file formats (PDF, Word, PowerPoint, Excel, text files), smart incremental indexing, and document chunk management.

    File: /tf/active/vicechatdev/docchat/document_indexer.py

    document-indexing vector-database chromadb embeddings pdf-processing
  • class ContractDataExtractor

    Extract structured data from legal contracts using LLM analysis

    File: /tf/active/vicechatdev/contract_validity_analyzer/extractor.py

    class contractdataextractor
  • function main

    Main entry point function for a Legal Contract Data Extractor application that processes contracts from FileCloud, extracts data, and exports results to multiple formats (CSV, Excel, JSON).

    File: /tf/active/vicechatdev/contract_validity_analyzer/extractor.py

    main-entry-point contract-extraction data-processing filecloud csv-export
  • function test_excel_output

    A test function that validates Excel output generation for contract analysis results, ensuring new fields (third_party_emails, third_party_tax_ids) are properly formatted and persisted.

    File: /tf/active/vicechatdev/contract_validity_analyzer/test_excel_output.py

    testing unit-test excel data-validation contract-analysis
  • class ContractAnalyzer

    Main class for analyzing contract validity from FileCloud documents.

    File: /tf/active/vicechatdev/contract_validity_analyzer/core/analyzer.py

    class contractanalyzer
  • class LLMClient_v2

    Client for interacting with LLM providers (OpenAI, Anthropic, Azure, etc.)

    File: /tf/active/vicechatdev/contract_validity_analyzer/utils/llm_client.py

    class llmclient
  • class DocumentConverter_v1

    A class that converts various document formats (Word, Excel, PowerPoint, images) to PDF format using LibreOffice, unoconv, or PIL.

    File: /tf/active/vicechatdev/document_auditor/src/document_converter.py

    document-conversion pdf file-processing office-documents image-to-pdf
  • function convert_european_decimals

    Detects and converts numeric data with European decimal format (comma as decimal separator) to standard format (dot as decimal separator) in a pandas DataFrame, handling mixed formats and missing data patterns.

    File: /tf/active/vicechatdev/vice_ai/smartstat_service.py

    data-processing data-cleaning decimal-conversion european-format locale-handling
  • function extract_excel_metadata

    Extracts comprehensive metadata from Excel files including cell comments, merged regions, named ranges, document properties, and sheet-level information that standard pandas operations miss.

    File: /tf/active/vicechatdev/vice_ai/smartstat_service.py

    excel metadata openpyxl data-extraction spreadsheet
  • function validate_sheet_format

    Analyzes Excel sheet structure using multiple heuristics to classify it as tabular data, information sheet, or mixed format, returning quality metrics and extraction recommendations.

    File: /tf/active/vicechatdev/vice_ai/smartstat_service.py

    data-validation excel-processing sheet-classification data-quality heuristic-analysis
  • function detect_table_boundaries

    Detects distinct tables within a pandas DataFrame by identifying empty rows as table boundaries and returns metadata about each detected table region.

    File: /tf/active/vicechatdev/vice_ai/smartstat_service.py

    data-processing excel table-detection boundary-detection pandas
  • function extract_sheet_context

    Extracts comprehensive text context from Excel DataFrame sheets that contain mixed structured and unstructured content, converting them into markdown-formatted text while preserving table structures, key-value pairs, and section headers.

    File: /tf/active/vicechatdev/vice_ai/smartstat_service.py

    excel-processing data-extraction markdown-generation text-parsing table-detection
  • function read_excel_file

    Reads Excel files and returns either metadata for all sheets or detailed data for a specific sheet, including format validation, European decimal conversion, and rich metadata extraction.

    File: /tf/active/vicechatdev/vice_ai/smartstat_service.py

    excel data-loading pandas file-io validation
  • class SmartStatSession

    A session management class that encapsulates a SmartStat statistical analysis session, tracking data, analysis history, plots, and reports for a specific data section.

    File: /tf/active/vicechatdev/vice_ai/smartstat_service.py

    session-management data-analysis statistics dataframe multi-dataset
  • class SmartStatService

    Service for running SmartStat analysis sessions in Vice AI

    File: /tf/active/vicechatdev/vice_ai/smartstat_service.py

    class smartstatservice
  • class DocumentProcessor_v6

    Lightweight document processor for chat upload functionality

    File: /tf/active/vicechatdev/vice_ai/document_processor.py

    class documentprocessor
  • function api_upload_document_v1

    Flask API endpoint that handles document file uploads, validates file type and size, stores the file temporarily, and extracts basic text content for processing.

    File: /tf/active/vicechatdev/vice_ai/new_app.py

    file-upload document-processing api-endpoint flask validation
  • function smartstat_upload_data

    Flask route handler that uploads CSV or Excel data files to a SmartStat analysis session, with support for multi-sheet Excel files and session recovery.

    File: /tf/active/vicechatdev/vice_ai/new_app.py

    flask file-upload csv excel data-analysis
  • function smartstat_select_sheet

    Flask API endpoint that processes one or more Excel sheets from an uploaded file, validates them, categorizes them as datasets or information sheets, and adds them to a SmartStat analysis session.

    File: /tf/active/vicechatdev/vice_ai/new_app.py

    excel data-loading sheet-selection api-endpoint authentication
  • function smartstat_upload_files

    Flask API endpoint that handles multi-file uploads (CSV, Excel, PDF, Word, PowerPoint) to a SmartStat session, processing data files as datasets and documents as information sheets.

    File: /tf/active/vicechatdev/vice_ai/new_app.py

    file-upload multi-file csv-processing excel-processing pdf-extraction
  • function upload_analysis_dataset

    Flask API endpoint that handles file upload for data analysis sessions, accepting CSV and Excel files, validating user access, and processing the dataset through a data analysis service.

    File: /tf/active/vicechatdev/vice_ai/new_app.py

    flask file-upload data-analysis api-endpoint authentication
  • class DataAnalysisService

    Service class for managing data analysis operations within document sections, integrating with SmartStat components for statistical analysis, dataset processing, and visualization generation.

    File: /tf/active/vicechatdev/vice_ai/data_analysis_service.py

    data-analysis statistical-analysis session-management dataset-processing visualization
  • function main_v24

    Orchestrates and executes a comprehensive test suite for the Vice AI Data Analysis Integration, running multiple test functions, creating test datasets, and providing detailed pass/fail reporting.

    File: /tf/active/vicechatdev/vice_ai/test_integration.py

    testing integration-tests test-runner data-analysis test-orchestration
  • class ControlledDocumentFlaskApp

    Main Flask application class for Controlled Document Management System.

    File: /tf/active/vicechatdev/CDocs/main_flask.py

    class controlleddocumentflaskapp
  • class PDFConverter_v1

    A comprehensive document-to-PDF converter class that handles multiple file formats (Word, Excel, PowerPoint, images) with multiple conversion methods and automatic fallbacks for reliability.

    File: /tf/active/vicechatdev/CDocs/utils/pdf_utils.py

    pdf conversion document-processing file-conversion word
  • class DocumentDetail_v2

    Document detail view component

    File: /tf/active/vicechatdev/CDocs/ui/document_detail.py

    class documentdetail
  • class DataProcessor

    Handles data loading, validation, and preprocessing

    File: /tf/active/vicechatdev/full_smartstat/data_processor.py

    class dataprocessor
  • class VendorEnricher

    A class that enriches vendor information by finding official email addresses and VAT numbers using RAG (Retrieval-Augmented Generation) with ChromaDB document search and web search capabilities.

    File: /tf/active/vicechatdev/find_email/vendor_enrichment.py

    vendor-enrichment data-enrichment RAG web-search ChromaDB
  • function main_v14

    Command-line interface function that orchestrates the enrichment of vendor data from an Excel file with email and VAT information using ChromaDB and RAG engine.

    File: /tf/active/vicechatdev/find_email/vendor_enrichment.py

    cli command-line data-enrichment vendor-management excel-processing
  • class VendorEmailExtractor

    Extract vendor email addresses from all organizational mailboxes

    File: /tf/active/vicechatdev/find_email/vendor_email_extractor.py

    class vendoremailextractor
  • function load_vendor_list

    Loads unique vendor names from the first column of an Excel file, removing any null values and returning them as a list.

    File: /tf/active/vicechatdev/find_email/extract_vendor_batch.py

    data-loading excel pandas vendor-management file-processing
  • function extract_batch

    Batch processes a list of vendors from an Excel file to extract their email addresses by searching through Microsoft 365 mailboxes using AI-powered email analysis.

    File: /tf/active/vicechatdev/find_email/extract_vendor_batch.py

    email-extraction vendor-management batch-processing microsoft-graph-api openai
  • function main_v27

    Command-line entry point that parses arguments and orchestrates the extraction of vendor emails from all vicebio.com mailboxes using Microsoft Graph API.

    File: /tf/active/vicechatdev/find_email/extract_vendor_batch.py

    cli command-line entry-point argparse email-extraction
  • class DataProcessor_v1

    Handles data loading, validation, and preprocessing

    File: /tf/active/vicechatdev/smartstat/data_processor.py

    class dataprocessor
  • function int_to_alpha

    Converts a non-negative integer to an Excel-style alphabetic column label (A, B, C, ..., Z, AA, AB, ..., ZZ, AAA, etc.).

    File: /tf/active/vicechatdev/patches/util.py

    string-conversion alphabetic-labels excel-columns base-26 spreadsheet

Search Examples