2.7.7 expExcel


Contents

Additional Information

Minimum Origin Version Required: 2019b

Command Line Usage

expExcel C:\Users\OL\Documents\OriginLab\User Files\Book1.xls sheets:=active;

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
Input Worksheet iwp

Input

WorksheetPage

<active>
 Specify the input workbook where the worksheet(s) you want to exported exists. By default, current workbook will be selected.
File Name fname

Input

string

fname$
 Specify the output file path and file name.
Overwrite Existing overwrite

Input

int

1
 Overwrite Existing
  • 0=rename:Auto Rename
  • 1=replace:Replace
  • 2=skip:Skip
  • 3=ask:Ask
Export Sheets sheets

Input

int

1

Specify the worksheets you want to export. Option list:

  • Whole Book
    Current whole workbook will be exported, minus excluded sheets and report sheets. Exclude sheets by right-clicking on the sheet tab and choosing Exclude from Excel Export.
  • Active Sheet Only
    Only current activated sheet will be exported.
Export Cell Formats cellfmts

Input

int

0

Specify whether to export the Excel with cell format.

Option list:

  • 0=false
  • 1=true

Description

This X-Function can be used to export current workbook or specified worksheet(s) as an Excel file.

Related X-Functions

expASC, expNITDM, expXLS