import originpro as op
import pandas as pd
import os
 
def read_file(file):  
    wks = op.find_sheet() # Get the active worksheet.
    
    with open(file, 'r') as f:
        # Read the Longname line
        line = f.readline()
        cols = line.split()
        
        # Read the Unit line
        line = f.readline()
        wks.set_labels([line], 'U')
        
        # Read in the data
        rows = []
        for line in f.readlines():
            rows.append(line.split())
 
    df = pd.DataFrame(data=rows, columns=cols)
    
    # Save data to worksheet
    wks.from_df(df)
    
    # Set column designation
    wks.cols_axis('XY') 
    
    # Set sheet name to file name
    wks.name = os.path.basename(file)
 
# The file chosen by Origin import filter is placed into the fname$
# LabTalk variable. Must bring it into Python.

fname = op.get_lt_str('fname')
data = read_file(fname)