3.7.5.71 System.Excel

Close the Select Data for Plotting dialog box after plotting the workbook data. 1 = close the dialog box, 0 = do not close the dialog box. The Select Data for Plotting dialog box is only available when dlgPlot = 0.

Plot by highlighting workbook data and assuming column designations appropriate to a selected graph type. 1 = enable, 0 = disable.

Drag-and-drop plot method for adding workbook data (and Origin worksheet data) to an existing graph. 1 = line, 2 = scatter, 3 = line+symbol, and 4 = current data plot style holder.

Automatically search the workbook for legend text. Origin searches for text in the cell immediately above the cell that contains the first Y data values, and then continues to search upward in the workbook. 1 = enable, 0 = disable.

Control the selection in the Open Excel dialog box (when openAsPrompt = 1). 1 = open as Excel workbook, 0 = open as Origin worksheet.

Display the Open Excel dialog box after selecting File:Open Excel. This dialog box determines how Excel files are opened in Origin (as workbooks or as Origin worksheets). 1 = enable opening dialog box, 0 = disable opening dialog box and always open as a workbook.

When selecting multiple datasets for plotting in the Select Data for Plotting dialog box, control the display of the data plots. 0 = plot all data into single layer graph, 1 = plot each data plot into its own layer of the same graph window, 2 = plot each data plot into its own graph window.

Control how internal and external Excel workbooks are saved when you save the associated project. 0 = do not open the Save Excel Workbooks dialog box. External workbooks are automatically updated when the associated project is saved. 1 = Open the Save Excel Workbooks dialog box when you select File:Save Project or click the Save button on the Standard toolbar. 2 = Open the Save Excel Workbooks dialog box when you select File:Save Project As.