SK logo
  • Product
  • Clients
  • Contact
  • Partners
  • Documentation
  • Blog
  • Release Notes
  • Technical Specifications
  • Implementation Guide
    • Prerequisites
    • Simple Example
    • Working with the Addin
      • Basic Concepts
  • Exercises
    • Export
      • Database
        • Create Table
        • Update or Insert data
        • Replace table
        • Batch Replace
        • Insert All
        • Insert New
        • Update All
        • Update Existing
        • Predecessor
        • Column Addition
    • Import
      • Database
        • Data from Table with partitioning
        • Data from Table with filtering and sorting
        • Data using Manual query
      • Excel
        • Multiple Workbooks
        • Multiple WorkSheets
        • Multiple Worksheets & Workbooks
        • Sheet Number
        • Repeated Column Headers
        • Variable Data Positioning
        • Ignore Blank Rows
        • Extra Data Columns
        • Variable Column Headers
        • Convert Blanks
        • Missing Columns
    • Operations
      • Fill, Stack and Remove Duplicates
      • Filter
        • Basic Filter
        • Custom Column
        • Contains Substring
        • Distinct dates
        • Nesting
        • Replace
        • Text Matches Regex
      • Lookup
        • Add Column From Key Range
        • Aggregation
        • All data
        • If No Match
        • If No Match
        • Match Only Once
        • Unique Items
  • Functions
    • Case Generation
    • Data From Database
    • Data From PDF
    • Export To Database
    • Export To Text
    • Fill
    • Import From Text File
    • Lookup
    • Pivot Table
    • Remove Duplicates
    • Stack Rows
  1. Documentation
  2. Functions

Functions

  • Case Generation
  • Data From Database
  • Data From PDF
  • Export To Database
  • Export To Text
  • Fill
  • Import From Text File
  • Lookup
  • Pivot Table
  • Remove Duplicates
  • Stack Rows
Address:
Quantum Phinance Consulting Pvt.Ltd.
Unit No. 701 in the “C” (J)
Kailash Business Park, 7 th floor,
S. Veer Savarkar Marg, Park Site,
Vikhroli (W), Mumbai-400079.
T: 022-62362043
For general queries:
contactus@sheetkraft.com

For support and technical queries:
support@sheetkraft.com

For sales and demos:
sales@sheetkraft.com

A product of

Quantum phinance Logo
Generated by Wyam