topic Re: Excel import Points in Fusion Support Forum

Excel import Points

Anonymous — Wed, 14 Apr 2021 17:04:22 GMT

I can't import Excel Points in Fusion 360

My Steps

1.Save XYZ values in Excel Version 16 45. file format :CSV UTF-8

2. Open Skript->ImportSplineCSV

3.Klick on the CSV File (Gear)->no valid points

Pc =MacBook Air Version 11.2.2

Re: Excel import Points

HughesTooling — Wed, 14 Apr 2021 17:14:26 GMT

When I look at your file you have a mix of commas and semicolons. Not sure if that's the problem. When I open in a spreadsheet you also have 4 columns for some entries.

Re: Excel import Points

JeromeBriot — Wed, 14 Apr 2021 18:12:56 GMT

Some crazy people in Europe use comma as decimal separator. 😄

Edit the script ImportSplineCSV.py and replace line 32:

pntStrArr = line.split(',')

By:

pntStrArr = [x.replace(',', '.') for x in line.split(';')]

@HughesTooling wrote:

When I look at your file you have a mix of commas and semicolons.

Maybe the true reason for brexit: too many calculation mistakes in the EU institutions.