# Create a new worksheet
wks = op.new_sheet()

# Specify the path to the CSV file
csv_file_path = 'C:\\Users\\PC-043012\\Desktop\\GuySimon\\test.csv'

# Load only the 4th and 5th columns from the CSV file into the worksheet
def load_csv_data(csv_file_path):
    x_values = []
    y_values = []
    with open(csv_file_path, 'r') as file:
        csvreader = csv.reader(file)
        for row in csvreader:
            # Extract the 4th and 5th columns and convert them to float
            x_value = float(row[3])  # Assuming the 4th column index is 3 (0-indexed)
            y_value = float(row[4])  # Assuming the 5th column index is 4 (0-indexed)
            # Add the values to the lists
            x_values.append(x_value)
            y_values.append(y_value)
    # Add the accumulated values to the worksheet
    wks.from_list(0, x_values, 'X')
    wks.from_list(1, y_values, 'Y')

# Load data from the CSV file
load_csv_data(csv_file_path)

model = op.NLFit('lorentz')
model.set_data(wks, 0, 1)
model.fit()

r, c = model.report(True)
wReport=op.find_sheet('w', r)
wReport.activate()