2.7.17 expSQLite


Menu Information

File: Export: SQLite

Brief Information

Export worksheet data as an SQLite file (sqlite, db, squlite3)

Command Line Usage

expSQLite path:="C:\Users\userName\Documents\OriginLab\User Files" ext:=db colskip:=1;

X-Function Execution Options

Please refer to the page for additional option switches when accessing the x-function from script

Variables

Display
Name
Variable
Name
I/O
and
Type
Default
Value
Description
iw

Input

Worksheet

<active>
The active worksheet.
File Name name

Input

string

<long name>

Export to book Long Name if it exists, otherwise Short Name.

File Path path

Input

string

path$

The file path of the exported file.

File Extension ext

Input

string

sqlite

File extension of the exported file.

Option List:

  • sqlite: sqlite
  • db: db
  • sqlite3: sqlite3
Overwrite Existing overwrite

Input

int

1
Specify whether to overwrite the existing file.

Option List:

  • 0: false
  • 1: true
Export Sheets sheets

Input

int

0
Specify the export sheets

Option List:

  • 0: active
Active Sheet Only
  • 1: whole
Whole Book
Skip Hidden Columns colskip

Input

int

0

Skip hidden columns:

  • 0: false
  • 1: true
Skip Hidden Rows rowskip

Input

int

0

Skip hidden rows:

  • 0: false
  • 1: true

Description

The expSQLite function exports worksheet data as an SQLite file. File structure and content is the same, regardless of specified file extension (sqlite, db, sqplite3).